Chapter 1 Flashcards
What are some responsibilities of a BA
may involve strategic planning, operating & business model analysis, process design, and technical business analysis.
They analyze real and hypothetical situations
is the delivery of accurate useful info to the necessary decision makers in the necessary timeframe to support accurate decision making
Business intelligence
A BLANK is used to uniquely identify each record in a table
Primary Key
In the business intelligence project data is extracted from various databases and loaded into a
Data Warehouse
Zen Principle presentations include…
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
What is the rule of 3rds
When possible divide PowerPoint into 9 different sections
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?
Analysis
What is an analysis of how outputs will change as the inputs from the assumptions area vary
Sensitivity Analysis
What is offshoring and onshoring
Hiring in country-onshore Hiring offshore-Offshoring
When data like bank transaction are processed it is called Blank. Processes account balances, total debits or total credits
Information
When designing a spread sheet the BLANK is usually at the top and stores the key variables and their values
Assumption
What is the term that is described as an attribute that allows a firm to beat the competition in some way
Competitive Advantage
Which function calculates how much is owed to pay back a loan?
PMT Payment function
What is the best reason for showing multiple values (such as buying and leasing) on the same screen?
Allows for easy comparison
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
Barriers to entry are low
These three parts must work together to realize business objectives. This is called
Info System Triangle
This describes how easy it is to use and navigate a system especially for novice users?
Usability
This describes how to create a visually stimulating and organized user space
Graphic Design Principle
Used to call attention to a particular piece of a design and highlight it
Contrast
The relational database model was created by an IBM engineer named
E.F. Codd
This is a language used by most relational database systems
SQL
Drill Down
The ability to move from summary data to lower and lower levels of detail
Dashboard
Easy to use interface that shows a graphic design presentation of what is going on in the company
Data Mining
Analyzing and summarizing data that is collected via the internet on people. Tries to find trends
Relational Database
A database made up of tables and only tables. Avoid duplicate tables
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.
Parent Table
parent table is a table that contains a primary key that is referenced by at least one foreign key in another table
Child Table
The referencing table in a referential constraint
What is a duplicate table
Storing information more than once. #1 sin of database design
SQL
Language used by relational database managment systems. Doesnt need a ton of code
Querry
A request for information from a database.
Pivot Table
Visual querry tool that allows you to answer sophisticated questions without writing SQL code
Data Warehouse
- data mining
- decision support
- systems (DDS)
- expert system (ES)
- artificial intelligence (AI)
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
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.
Schematic Report
- Title
- EX Summary
- Table of Contents
- Intro
- Body—>analysis recommendations, evidence
- Conclusions
Could have too much info to just put into a power point
Analytical design principle
Tuftes way of designing charts
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.
Fixed Cost
Cost that never changes
Varible Cost
Cost that changes based on a certain varible
Contribution Margin
Sales-Varible Expense
Competitive advantage
Competitive advantage occurs when an organization acquires or develops an attribute or combination of attributes that allows it to outperform its competitors.
Database Integration
data integration or database integration implies the ability to access any source of data within or outside your enterprise
Non Obvious UML symbols
Diamond-Decision Point
Slim Rectangle-Beginning of a parallel process
Artifact-object involved in the system such as data base
What is affinity
showing subtle changes in color or brightness
conflicting layout
type is very similar but different (dont use 2 differing serifs together)
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
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
Website Authoring Tool
Adobe
Design View vs Code View
Design view is click and drag interface
Code is more precsise and you write actual code
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
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
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
What are forcasts
educated guesses for for future variables
Formula vs. Function
In excel are you using (A1+B3) [Formula] or (SUM) function
What is an industry analysis
Has to do with surveying the industry not your company
What is a company analysis
Looks at competitive position of the company against the industry
Strengths and Weakness
Porter 5 Forces
Threat of New Entrants, Bargaining Power of Suppliers, bargaining power of buyer, threat of substitution, and Competitive rivalry within industry
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
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
Dynamic Reports
Online and interactive. A manager wants to see his dashboard data so he drills down further. USES GRAPHS
Business Presentation
1st comes the CLAIM (AKA thesis)
2nd comes the EVIDENCE
Who created Zen Principles
Garr Reynolds
Signal to Noise Ratio
Inform dont decorate
everything is there for a reason
Means a strong communication SIGNAL to a weak distracting NOISE
Use of Empty Noise
Empty space can be good, but too much makes it look like it is missing info. FIND Balance