Skip to content
Deadline to Die

Data Storage & Modeling Hub

💾 Data Storage & Modeling Hub

Where you store your data and how you model it determines how easy it is to query, how much it costs, and how fast your dashboards will be.

🔍 Section Overview

Explore the different “homes” for data and the mathematical models used to organize them.

1. Warehouse vs. Lake vs. Lakehouse

Understand the evolution of data storage. From structured Data Warehouses (BigQuery/Snowflake) to raw Data Lakes (S3) and the modern Data Lakehouse (Databricks).

2. Dimensional Modeling (Star Schema)

Learn how to build Fact and Dimension tables. Master the art of optimizing for read-heavy analytical workloads.

🎯 Key Learning Goals

  • Choose the right storage technology based on data structure and velocity.
  • Design a Star Schema that balances performance and usability.
  • Understand the “Medallion Architecture” (Bronze, Silver, Gold).