45 days. One clear order. No course hopping.
Excel, SQL, Power BI, Python, stats, then job hunting. Each block has one thing you must build before moving on.
The biggest mistake is waiting to feel ready. Start applying on day 35.
Phase 1: Tools
Excel
- Cleaning, TRIM, text functions
- XLOOKUP, SUMIFS, COUNTIFS
- Pivot tables and charts
- Build 1 sales dashboard
SQL
- SELECT, WHERE, GROUP BY, HAVING
- All JOINs + subqueries + CTEs
- Window functions
- Solve 50 interview problems
Phase 2: Analysis
Power BI
- Power Query cleaning
- Star schema modeling
- CALCULATE + time intelligence
- Publish 1 dashboard
Python
- Basics: lists, loops, functions
- pandas: filter, groupby, merge
- Charts with matplotlib/seaborn
- 1 end-to-end EDA project
Phase 3: Get hired
Statistics
- Mean, median, spread
- Distributions + sampling
- Hypothesis testing, A/B tests
- Correlation vs causation
Get hired
- 2 projects live on GitHub
- Resume with numbers, 1 page
- 5 applications + 2 referral asks daily
- 3 mock interviews
Your daily split
| Block | Time | Output |
|---|---|---|
| Learn | 60 min | Notes, 1 page |
| Practice | 90 min | Problems solved |
| Build | 30 min | Project commit |
| Apply (D35+) | 30 min | 5 applications |
Practice gets the most time. Watching is not learning.
Rules for 45 days
Don't
- 3 courses at once
- Notes without practice
- Wait to feel ready
Do
- 3 focused hours daily
- Build while you learn
- Apply from day 35