I make free YouTube courses for data nerds 🤓
| Course | What you'll learn | Repo |
|---|---|---|
 |
• Formulas and functions • Charts and pivot tables • Power Query and Power Pivot • 2 projects: a dashboard and an analysis |
 |
 |
• SELECT, JOIN, and aggregations • CTEs and subqueries • PostgreSQL from scratch • Project: analyzing the data job market |
 |
 |
• Python fundamentals • NumPy, Pandas, and Matplotlib • Cleaning and visualizing data • Project: the most in demand data skills |
 |
 |
• Visualizations and report design • Power Query for ETL • DAX and explicit measures • 2 job market dashboard projects |
 |
 |
• Window functions • Dates, views, and data cleaning • Query optimization with EXPLAIN • Project: Contoso retail analysis |
 |
 |
• Data warehouses and star schemas • ETL pipelines and data marts • DuckDB and MotherDuck • Project: raw CSVs to a warehouse |
 |
 🔜 Coming soon |
• dbt models, tests, and docs • Version controlled pipelines • Automating runs with GitHub Actions • 2 projects: DuckDB then BigQuery |
 |
Every course is free to watch on YouTube. Supporting a course gets you the practice problems, a certificate, and the community.
Don't guess. In my free time I build datanerd.tech, an app that tracks skill demand, salaries, and openings across 4 million data job postings in 171 countries. Check what employers are actually asking for, then pick your course.
