compendium

11 Lessons

Where Spreadsheets Still Beat SQL, Python and Dashboards

12 Lessons

Event Tracking & Instrumentation: Clean Data at Source

12 Lessons

Design a Warehouse Model for a Delivery Business - Interview Framework, Metrics and Case Study

12 Lessons

The Semantic Layer & Metrics Store: One Definition of Truth

12 Lessons

Data Quality Testing, Freshness & Pipeline Monitoring

12 Lessons

Analytics Engineering: Transformation, Testing & Documented Models

12 Lessons

The Modern Data Stack: Ingestion, Storage, Transformation & Serving

12 Lessons

Slowly Changing Dimensions & Keeping History

12 Lessons

Extract-Transform-Load versus Extract-Load-Transform Pipelines

12 Lessons

Star Schema versus Snowflake Schema: Choosing a Design

12 Lessons

Dimensional Modelling: Facts, Dimensions & Choosing the Grain

12 Lessons

How Analytics Data Is Stored: Databases, Warehouses & Lakes

14 Lessons

Case Study: Answering a Business Question End to End in SQL

14 Lessons

Ten SQL Patterns That Cover Most Interview Questions

14 Lessons

Query Performance: Indexes, Scans & Writing Efficient SQL

14 Lessons

Date, Time & Cohort Queries That Interviews Reuse

14 Lessons

Window Functions: Ranking, Running Totals, Lag & Lead

14 Lessons

Subqueries, Common Table Expressions & Readable SQL