Demo Academy

From raw files to answers with dataframes — the working core of analytical Python.

• 2 lessons
• Beginner
• ~2 h

RANK, LAG, and rolling aggregates — the SQL that turns row-by-row data into answers about change over time.

• 2 lessons
• Intermediate
• ~1 h

Facts, dimensions, and the grain — how to shape tables so every later query gets simpler.

• 2 lessons
• Beginner
• ~45 min

A full transformation pipeline on your laptop: dbt models compiled straight into an in-process DuckDB.

• 2 lessons
• Intermediate
• ~1.5 h

Why analytics engines read Parquet 100× faster than CSV, and how to work with it directly.

• 2 lessons
• Beginner
• ~40 min

From raw files to answers with dataframes — the working core of analytical Python.

• 2 lessons
• Beginner
• ~2 h

Idempotency, backfills, and alerts — what separates a script that ran once from a pipeline you can trust.

• 2 lessons
• Advanced
• ~1.5 h

Structs, lists, and raw JSON columns — how to unnest the messy shapes real APIs hand you.

• 2 lessons
• Intermediate
• ~45 min

Freshness, volume, and validity checks — catch broken data before your stakeholders do.

• 2 lessons
• Intermediate
• ~1 h

The terminal as a data tool: inspect, slice, and convert files before anything heavier gets involved.

• 2 lessons
• Beginner
• ~1 h