Why Build a Data Warehouse

Last modified: August 07, 2019

Contribute to Data School

We are actively working on this chapter. We are looking for two types of contributions:

  1. Help writing this chapter
  2. Share your story about working through this problem at work

Please reach out to @Matt David on our slack to discuss what you want to contribute.

Why Build a Data Warehouse In Progress Overview

We work with hundreds of companies who are trying to get valuable insights out of their data. We see companies struggling to get insights out of their data lakes and want to show them a path forward.

Creating a Data Warehouse is a great way to get much more value out of your data. We hope to explain the many benefits of structuring and simplifying your data.

Outline + Learning Objectives

The problem with data in a Data Lake

  • Describe why Data Lake data can be challenging to use

Data in a Data Warehouse

  • Describe what data looks like in a Data Warehouse

Benefits of a Data Warehouse

  • Describe the different ways a Data Warehouse will impact an organization

Problem with Data Lake

  • Complicated Schema
  • Confusing Table and column names

Data in a Data Warehouse

  • Clear
  • Simple

Benefits of a Data Warehouse:

  • Easier to understand and query
  • Faster to work with
  • Approachable
  • Trusted, consistent source of answers

Written by:
Reviewed by:

Next – Single Source of Truth Architecture

Get new data chapters sent right to your Inbox