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;
17 Cards in this Set
- Front
- Back
A data management system designed tonallow and assist business intelligence operations, particularly analysis |
DATA WAREHOUSE |
|
What kind of data does DATA WAREHOUSES store huge quantities of? |
HISTORICAL DATA |
|
Its analysis extracts valuable business insights from data |
DATA WAREHOUSE |
|
For whom do data warehouses build historical data for? |
Data Scientists and Business Analysts |
|
A data warehouse is an organization’s __________ |
Single Source of Truth |
|
As an unformation system architecture, what does data warehouses offer for consumers? |
Current and Historical Decision Support Information |
|
Wht are the 5 elements of data warehouses? |
1. Relationa Database 2. Extraction, Loading, Transformation (ELT) solution 3. Statistical Analysus, Reporting and Dara Mining capabilities 4. Client Analysis Tools 5. Applications for actionable information through data science and artificial intelligence |
|
Data Warehouses were created in the late 1980s to do what? |
Assist data flow from operational systems to data-support sustems |
|
Data Warehouses were created in the late 1980s to do what? |
Assist data flow from operational systems to data-support systems |
|
A step in data warehouse where it provides relational information to create snapshots of business performance |
Transactional reporting |
|
The 2nd step in data warehouse that expands capabilities for deeper insights and more robust analysis |
Slice and dice, ad hoc query, BI tools |
|
A capability of data warehouse where it can develop visualization and forward-looking business intelligence |
Predicting future performance (data minign) |
|
A capability of data warehouse where it can develop visualization and forward-looking business intelligence |
Predicting future performance (data minign) |
|
The capability of data warehouse where it offers “what-if” scenarios to inform practical decisions based on more comprehensive analysis |
Tactical Analysis (sptial, statistics) |
|
A capability of data warehouse where it can develop visualization and forward-looking business intelligence |
Predicting future performance (data minign) |
|
The capability of data warehouse where it offers “what-if” scenarios to inform practical decisions based on more comprehensive analysis |
Tactical Analysis (sptial, statistics) |
|
Capability of data warehouse where it stores data for only weeks or months |
Stores many months or years of data |