🎬 BI Video Playlist¶
How to use
Every video maps to a skill in our Skills Matrix. Follow the 30-60-90 path below, or jump straight to your gap area. 🌱 Beginner · 🌿 Intermediate · 🌳 Advanced
Start here — the language of everything we do. 🗄️
1. 🗄️ SQL & Databases¶
| # | Video / Resource | Source | Level | Why at Marathon |
|---|---|---|---|---|
| 1 | SQL Tutorial – Full Database Course (4 h) | freeCodeCamp · Mike Dane | 🌱 | Foundation for every das-db query |
| 2 | MySQL Tutorial for Beginners (3 h) | Programming with Mosh | 🌱 | Our warehouse engine is MySQL 8 on DigitalOcean |
| 3 | ▶ SQL Window Functions (best current) | YouTube search | 🌿 | ROW_NUMBER() golden-record logic in Pipeline A |
| 4 | ▶ Query Optimization & Indexes | YouTube search | 🌳 | Explains Epic 1 anti-pattern findings |
2. 🐍 Python for Data¶
| # | Video / Resource | Source | Level | Why at Marathon |
|---|---|---|---|---|
| 1 | Learn Python – Full Course | freeCodeCamp | 🌱 | Base language of PY-01/PY-02 crons |
| 2 | Data Analysis with Python (pandas/NumPy) | freeCodeCamp | 🌿 | Product categorization & cleansing scripts |
| 3 | ▶ Build an ETL Pipeline (Python + MySQL) | YouTube search | 🌿 | Mirrors our daily fact_saless sync |
| 4 | ▶ Matplotlib / Seaborn / Plotly crash course | YouTube search | 🌿 | Ad-hoc analytics visuals |
3. 📊 BI & Visualization Tools¶
| # | Video / Resource | Source | Level | Why at Marathon |
|---|---|---|---|---|
| 1 | Data Analyst Full Courses playlist (Power BI · Excel · pandas) | YouTube playlist | 🌱→🌿 | One playlist covers 4 of our tools |
| 2 | ▶ Power BI Full Course (best current) | YouTube search | 🌱 | Executive dashboards |
| 3 | Learn DAX basics + ▶ DAX videos | Microsoft · YouTube | 🌿 | Measures for KR boards |
| 4 | Tableau Official Training Videos + ▶ Tableau course | Tableau · YouTube | 🌱 | Secondary BI tool |
| 5 | Looker Studio Quick-start + ▶ Looker Studio course | Google · YouTube | 🌱 | Our SLA ↔ KRs board platform |
| 6 | Excel Basics for Data Analysis (IBM) + ▶ Excel full course | Coursera · YouTube | 🌱 | Advanced Excel deliverables |
4. 🏗️ Data Modeling & Warehousing¶
| # | Video / Resource | Source | Level | Why at Marathon |
|---|---|---|---|---|
| 1 | ▶ Star Schema explained (best current) + Microsoft guide | YouTube · Microsoft | 🌿 | fact_saless + dim_* design |
| 2 | What is Master Data Management? (video) + ▶ MDM videos | Informatica · YouTube | 🌿 | Epic 3 golden records |
| 3 | Best ETL Tutorials on YouTube (curated list) | SolutionsReview | 🌿 | Pipeline design patterns |
5. ⚙️ Automation & Engineering¶
| # | Video / Resource | Source | Level | Why at Marathon |
|---|---|---|---|---|
| 1 | Apps Script Fundamentals (codelab) + ▶ GAS full course | Google · YouTube | 🌱 | GAS-01…04 weekly automations |
| 2 | Git Tutorial for Beginners (1 h) | Programming with Mosh | 🌱 | Docs CI/CD & version control |
| 3 | ▶ MkDocs Material tutorial | YouTube search | 🌿 | This documentation site itself |
6. 🏛️ Business, Governance & Storytelling¶
| # | Video / Resource | Source | Level | Why at Marathon |
|---|---|---|---|---|
| 1 | 7 short YouTube videos to learn OKRs + OKR vs KPI | Curated list | 🌱 | Epic 4 framework |
| 2 | ▶ Data Visualization principles | YouTube search | 🌿 | "Clear visual stories" mandate |
| 3 | ▶ ESG metrics explained | YouTube search | 🌿 | Sustainability dashboard |
🧭 30-60-90 Learning Path¶
| Phase | Focus | Watch |
|---|---|---|
| Days 1–30 | Language basics | SQL #1-2 · Python #1 · Excel #6 |
| Days 31–60 | BI tooling | Playlist #3-1 · Power BI #3-2 · Looker #3-5 |
| Days 61–90 | Engineering | Window fns #1-3 · Star schema #4-1 · ETL #2-3 · GAS #5-1 |
| Ongoing | Governance | OKR #6-1 · Data-viz #6-2 · ESG #6-3 |