Powered by Mastria

Demo Academy

All With labs analytics data-engineering duckdb sql

1. 01What a window is
2. 02Ranking and offsets
Window Functions in Depth
RANK, LAG, and rolling aggregates — the SQL that turns row-by-row data into answers about change over time.
- 2 lessons
- Intermediate
- ~1 h
1. 01The grain
2. 02Facts and dimensions
Data Modeling Essentials
Facts, dimensions, and the grain — how to shape tables so every later query gets simpler.
- 2 lessons
- Beginner
- ~45 min
1. 01Why local-first analytics
2. 02Your first model
dbt + DuckDB: Local Analytics
A full transformation pipeline on your laptop: dbt models compiled straight into an in-process DuckDB.
- 2 lessons
- Intermediate
- ~1.5 h
1. 01Loading and looking
2. 02Filter, group, aggregate
Python for Data Analysis
From raw files to answers with dataframes — the working core of analytical Python.
- 2 lessons
- Beginner
- ~2 h
1. 01The three questions
2. 02Asserting validity
Data Quality Essentials
Freshness, volume, and validity checks — catch broken data before your stakeholders do.
- 2 lessons
- Intermediate
- ~1 h