What is a data warehouse?

Data Warehousing Concepts

Aaren Stubberfield

Data Scientist

What you will learn

  • What is a data warehouse
  • Warehouse architectures and properties
  • Data warehouse data modeling
  • Data prep and cleaning
Data Warehousing Concepts

What is a data warehouse?

A computer system designed to store and analyze large amounts of data for an organization.

Data Warehousing Concepts

What does a data warehouse do?

  • Gathers data from different areas of an organization
  • Integrates and stores the data
  • Make it available for analysis

Image of computer and data to analyze

People standing in a warehouse

1 Photos from Pexel by Nataliya Vaitkevich and Tiger Lily
Data Warehousing Concepts

Why is a data warehouse valuable?

Organizations implement data warehouses in order to:*

  • Support business intelligence activity
  • Enable effective organizational analysis and decision-making
  • Find ways to innovate based on insights from their data
1 Data Management Book Of Knowledge 2nd Edition
Data Warehousing Concepts

Meet Bravo!

  • Hypothetical publicly traded company
    • Sells home office furniture

Home office with a desk, and chair

1 Photo from Pexel by Pixabay
Data Warehousing Concepts

Common scenarios

  • Product sales forecasting
  • Governance and regulation adherence
  • Insight and growth
Data Warehousing Concepts

Summary

What is a data warehouse?

  • A computer system designed to store and analyze large amounts of data for an organization.

 

What does a data warehouse do?

  • Gathers data from different areas
  • Integrates and stores the data
  • Make it available for analysis

Why is a data warehouse valuable?

  • Support business intelligence activity
  • Enable effective analysis and decision-making
  • Foster data-driven innovation
Data Warehousing Concepts

Let's practice!

Data Warehousing Concepts

Preparing Video For Download...