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
Relational Database
A database made up of tables and only tables. Avoid duplicate tables
26
Foreign Key
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.
27
Parent Table
parent table is a table that contains a primary key that is referenced by at least one foreign key in another table
28
Child Table
The referencing table in a referential constraint
29
What is a duplicate table
Storing information more than once. #1 sin of database design
30
SQL
Language used by relational database managment systems. Doesnt need a ton of code
31
Querry
A request for information from a database.
32
Pivot Table
Visual querry tool that allows you to answer sophisticated questions without writing SQL code
33
Data Warehouse
- data mining - decision support - systems (DDS) - expert system (ES) - artificial intelligence (AI)
34
ETL
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
Latency
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
Schematic Report
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
Analytical design principle
Tuftes way of designing charts
38
Sensitivity Analysis
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
Fixed Cost
Cost that never changes
40
Varible Cost
Cost that changes based on a certain varible
41
Contribution Margin
Sales-Varible Expense
42
Competitive advantage
Competitive advantage occurs when an organization acquires or develops an attribute or combination of attributes that allows it to outperform its competitors.
43
Database Integration
data integration or database integration implies the ability to access any source of data within or outside your enterprise
44
Non Obvious UML symbols
Diamond-Decision Point Slim Rectangle-Beginning of a parallel process Artifact-object involved in the system such as data base
45
What is affinity
showing subtle changes in color or brightness
46
conflicting layout
type is very similar but different (dont use 2 differing serifs together)
47
Ad Design Elements
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
Build vs Buy
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
Website Authoring Tool
Adobe
50
Design View vs Code View
Design view is click and drag interface | Code is more precsise and you write actual code
51
Client Side vs Cloud Development
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
Example of what data integration is
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
Offshoring misconceptions
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
What are forcasts
educated guesses for for future variables
55
Formula vs. Function
In excel are you using (A1+B3) [Formula] or (SUM) function
56
What is an industry analysis
Has to do with surveying the industry not your company
57
What is a company analysis
Looks at competitive position of the company against the industry Strengths and Weakness
58
Porter 5 Forces
Threat of New Entrants, Bargaining Power of Suppliers, bargaining power of buyer, threat of substitution, and Competitive rivalry within industry
59
What do Analytical Design Principles show
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
What is a static Report
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
Dynamic Reports
Online and interactive. A manager wants to see his dashboard data so he drills down further. USES GRAPHS
62
Business Presentation
1st comes the CLAIM (AKA thesis) | 2nd comes the EVIDENCE
63
Who created Zen Principles
Garr Reynolds
64
Signal to Noise Ratio
Inform dont decorate everything is there for a reason Means a strong communication SIGNAL to a weak distracting NOISE
65
Use of Empty Noise
Empty space can be good, but too much makes it look like it is missing info. FIND Balance