Module 04 of 10

Data Modeling & Warehousing

Lessons

About This Module

A pipeline is only as useful as the place it delivers data to. Before you load anything, you have to decide how the data will be organized so analysts and dashboards can query it quickly and get the right answers. That is the job of data modeling and data warehousing.

You'll start by separating the systems that run an application from the systems built for analysis, which is the difference between OLTP and OLAP, and by comparing data warehouses, data lakes, and the newer lakehouse idea. Then you'll learn dimensional modeling: splitting data into fact tables and dimension tables, and arranging them into star and snowflake schemas.

Finally, you'll see these ideas on real platforms. Snowflake and Google BigQuery are two of the most widely used cloud data warehouses, and working through each shows how a modern warehouse stores, scales, and queries data. Note that the Snowflake data platform and the snowflake schema are different things that happen to share a name.

With a target in mind, you'll be ready for the next module, ETL & ELT Pipelines, where you build the pipelines that fill it.

Lessons

5 videos
01

Data Warehouse vs Data Lake vs Data Lakehouse

A simple explanation of how warehouses, lakes, and lakehouses differ, with a look at ETL and the difference between OLAP and OLTP systems.

02

Dimensional Modeling: The Kimball Method

A tutorial on the concepts and practice of dimensional modeling using the Kimball method, the standard approach to designing a data warehouse.

03

Star Schema vs Snowflake Schema Explained

A clear comparison of the two schema designs you'll meet most often, and how to explain the difference, which is also one of the most common data warehouse interview questions.

04

Snowflake Tutorial for Beginners

An end-to-end introduction to the Snowflake cloud data warehouse, from the basics of warehouses, schemas, and databases through to more advanced features.

05

Google BigQuery Tutorial (Beginner to Advanced)

A fast crash course on Google BigQuery: what it is, how to get started, and how to work up to more advanced use.