Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
13 Cards in this Set
- Front
- Back
P-Value |
The probability of the result due to change |
|
KPI |
Key Performance Indicator is a data point on a dashboard |
|
ETL |
Extract Transform and Load A process that extracts info from internal and external databases A process that transforms info using a common set of enterprise definitions A process that loads information into a DW |
|
R^2 |
The % of variance that you are expecting |
|
Hypothesis |
A reasonable explanation that you can test. |
|
Business Intelligence |
The process and technology tools used to transform raw data into meaningful and useful information that support business decision making. |
|
Business Analytics |
A subset of BI, the statistical analyses performed to help predict the future. |
|
Operational Databases |
Used to store transactional information What you learned about in ERD/Access Module SarbOx required companies keep all trans records for 3 years Used for daily business process, accounting, reports Must be "always on" or else business shuts down |
|
Analytical Databases |
It's a condense/summarized copy of all operation DBs Includes data from outside sources as well Not based on ERDs, uses Star Scheme or others Updated occasionally through ETL Used for data mining (Predicting the future) This is your data "playground" This is where your BI is born |
|
Data Marts |
Focuses on a subset of information for a given business unit such as finance (Role-based portions of the DW) |
|
Data Warehouse |
Has an enterprise wide organizational focus (Analytical DB) |
|
Data Cubes |
Common term for the representation of multidimensional information Allows managers to "drill" down and up through data and view recent trends Pivot Tables are a small scale of them |
|
Data Dashboards |
Allow users -typically managers- to get high level overview of the organization's "health" or current status Data points included are KPIs |