Data Warehouse Implementation

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.

Data Warehouse Implementation In Progress Overview

Now it is time to put code to computer and setup your Data Warehouse. We will walk through a simple example of a schema with typical Data Lake issues and ETL/ELT to get it into a Data Warehouse.

Outline + Learning Objectives

Move from Data Lake to Data Warehouse

  • Describe the most common methods for moving from a Data Lake to a Data Warehouse

dbt

  • Describe how to use dbt to create your Data Warehouse

Airflow

  • Describe how to use Airflow to create your Data Warehouse

SQL

  • Describe how to use SQL to create your Data Warehouse

Custom Scripts

  • Describe how to use custom scripts to create your Data Warehouse

Written by:
Reviewed by:

Next – Defining a Data Govenor

Get new data chapters sent right to your Inbox