DE by DL.AI - C4 W1 - Data Modeling & Transformations for Analytics

Anh-Thi Dinh

draft

DeepLearning.AI mooc-de Data Science Data Engineering MOOC AWS API & Services

⚠️

This is a quick & dirty draft, for me only!

👉 List of notes for this specialization

👉 Lecture notes & Repositoty.

Introduction to Data Modeling for Analytics

Course 4 overview

Conceptual, logical and physical data modeling

Normalization

Lab 1 — Data normalization

Dimensional modeling - Star schema

Data Modeling Techniques

Inmon vs Kimball Data modeling approaches for Data Warehouses

Exercise — from normalized model to star schema

Another modeling example

Conversation about DVT with Brew Banin

Data Vault

One big table

Transforming data with dbt

Exercise — Transforming a normalized model into a star schema

Lab 2 — Data modeling with DBT