• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/17

Click to flip

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