Chapter 1 Flashcards

1
Q

What are some responsibilities of a BA

A

may involve strategic planning, operating & business model analysis, process design, and technical business analysis.

They analyze real and hypothetical situations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

is the delivery of accurate useful info to the necessary decision makers in the necessary timeframe to support accurate decision making

A

Business intelligence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A BLANK is used to uniquely identify each record in a table

A

Primary Key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

In the business intelligence project data is extracted from various databases and loaded into a

A

Data Warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Zen Principle presentations include…

A

Large images, full page bleeds and one sentence of text

Simple, No narrative just overview, high signal to noise ratio, make use of empty space, uses rule of 3rds

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the rule of 3rds

A

When possible divide PowerPoint into 9 different sections

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Company A hires company B and B is trying to figure out how company A stores data. What stage of the systems development life cycle does this represent?

A

Analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is an analysis of how outputs will change as the inputs from the assumptions area vary

A

Sensitivity Analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is offshoring and onshoring

A

Hiring in country-onshore Hiring offshore-Offshoring

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

When data like bank transaction are processed it is called Blank. Processes account balances, total debits or total credits

A

Information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

When designing a spread sheet the BLANK is usually at the top and stores the key variables and their values

A

Assumption

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the term that is described as an attribute that allows a firm to beat the competition in some way

A

Competitive Advantage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which function calculates how much is owed to pay back a loan?

A

PMT Payment function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the best reason for showing multiple values (such as buying and leasing) on the same screen?

A

Allows for easy comparison

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You find that there are 1000s of developers and it cost relatively little to develop an app, applying porters 5 forces what would you say

A

Barriers to entry are low

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

These three parts must work together to realize business objectives. This is called

A

Info System Triangle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

This describes how easy it is to use and navigate a system especially for novice users?

A

Usability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

This describes how to create a visually stimulating and organized user space

A

Graphic Design Principle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Used to call attention to a particular piece of a design and highlight it

A

Contrast

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

The relational database model was created by an IBM engineer named

A

E.F. Codd

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

This is a language used by most relational database systems

A

SQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Drill Down

A

The ability to move from summary data to lower and lower levels of detail

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Dashboard

A

Easy to use interface that shows a graphic design presentation of what is going on in the company

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Data Mining

A

Analyzing and summarizing data that is collected via the internet on people. Tries to find trends

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Relational Database

A

A database made up of tables and only tables. Avoid duplicate tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

Foreign Key

A

a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. In other words, a foreign key is a column or a combination of columns that is used to establish and enforce a link between two tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Parent Table

A

parent table is a table that contains a primary key that is referenced by at least one foreign key in another table

28
Q

Child Table

A

The referencing table in a referential constraint

29
Q

What is a duplicate table

A

Storing information more than once. #1 sin of database design

30
Q

SQL

A

Language used by relational database managment systems. Doesnt need a ton of code

31
Q

Querry

A

A request for information from a database.

32
Q

Pivot Table

A

Visual querry tool that allows you to answer sophisticated questions without writing SQL code

33
Q

Data Warehouse

A
  • data mining
  • decision support
  • systems (DDS)
  • expert system (ES)
  • artificial intelligence (AI)
34
Q

ETL

A

Extract, Transform and Load. It is an ETL process to extract data, mostly from different types of systems, transform it into a structure that’s more appropriate for reporting and analysis and finally load it into the database and or cube

35
Q

Latency

A

In general, the period of time that one component in a system is spinning its wheels waiting for another component. Latency, therefore, is wasted time.

36
Q

Schematic Report

A
  1. Title
  2. EX Summary
  3. Table of Contents
  4. Intro
  5. Body—>analysis recommendations, evidence
  6. Conclusions

Could have too much info to just put into a power point

37
Q

Analytical design principle

A

Tuftes way of designing charts

38
Q

Sensitivity Analysis

A

A technique used to determine how different values of an independent variable will impact a particular dependent variable under a given set of assumptions.

39
Q

Fixed Cost

A

Cost that never changes

40
Q

Varible Cost

A

Cost that changes based on a certain varible

41
Q

Contribution Margin

A

Sales-Varible Expense

42
Q

Competitive advantage

A

Competitive advantage occurs when an organization acquires or develops an attribute or combination of attributes that allows it to outperform its competitors.

43
Q

Database Integration

A

data integration or database integration implies the ability to access any source of data within or outside your enterprise

44
Q

Non Obvious UML symbols

A

Diamond-Decision Point
Slim Rectangle-Beginning of a parallel process
Artifact-object involved in the system such as data base

45
Q

What is affinity

A

showing subtle changes in color or brightness

46
Q

conflicting layout

A

type is very similar but different (dont use 2 differing serifs together)

47
Q

Ad Design Elements

A

Headline-concise and clear font can be centered text
Text-The body of the text is used to sell the product
Logo-Logo should include tagline

48
Q

Build vs Buy

A

Build your own solution or buy one that is already in existance. Why reinvent the wheel, if it works for them it works for you

49
Q

Website Authoring Tool

A

Adobe

50
Q

Design View vs Code View

A

Design view is click and drag interface

Code is more precsise and you write actual code

51
Q

Client Side vs Cloud Development

A

Client takes place on a local PC. Everything is tested before it goes online.

Cloud is all done online and is like google site
template based and low cost

52
Q

Example of what data integration is

A

Taking info from a website and putting it into a table

we did this with the sign up for updates part of our website

53
Q

Offshoring misconceptions

A

People think they go overseas just because its cheap. India and Asia prices are increasing. Sometimes companies do it locally for communication reasons. Sometimes local is a competitive advantage

54
Q

What are forcasts

A

educated guesses for for future variables

55
Q

Formula vs. Function

A

In excel are you using (A1+B3) [Formula] or (SUM) function

56
Q

What is an industry analysis

A

Has to do with surveying the industry not your company

57
Q

What is a company analysis

A

Looks at competitive position of the company against the industry

Strengths and Weakness

58
Q

Porter 5 Forces

A

Threat of New Entrants, Bargaining Power of Suppliers, bargaining power of buyer, threat of substitution, and Competitive rivalry within industry

59
Q

What do Analytical Design Principles show

A

1) Comparisons, contrast, and differences
2) shows explanation and potential causes for certain trends and movements
3) Shows multivarible data
4) Integrates words, numbers, images, and diagrams
5) Thoroughly describe the evidence (cite source)
6) Make sure content is relevant and correct

60
Q

What is a static Report

A

Most common form of BI. They are straight forward reports already laid out for you. EX colleges have enrollment reports which are used to decide if they need to hire more faculty

61
Q

Dynamic Reports

A

Online and interactive. A manager wants to see his dashboard data so he drills down further. USES GRAPHS

62
Q

Business Presentation

A

1st comes the CLAIM (AKA thesis)

2nd comes the EVIDENCE

63
Q

Who created Zen Principles

A

Garr Reynolds

64
Q

Signal to Noise Ratio

A

Inform dont decorate
everything is there for a reason
Means a strong communication SIGNAL to a weak distracting NOISE

65
Q

Use of Empty Noise

A

Empty space can be good, but too much makes it look like it is missing info. FIND Balance