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
DAY 1-7
Excel
- Cleaning, TRIM, text functions
- XLOOKUP, SUMIFS, COUNTIFS
- Pivot tables and charts
- Build 1 sales dashboard
DAY 8-18
SQL
- SELECT, WHERE, GROUP BY, HAVING
- All JOINs + subqueries + CTEs
- Window functions
- Solve 50 interview problems
Phase 2: Analysis
DAY 19-26
Power BI
- Power Query cleaning
- Star schema modeling
- CALCULATE + time intelligence
- Publish 1 dashboard
DAY 27-35
Python
- Basics: lists, loops, functions
- pandas: filter, groupby, merge
- Charts with matplotlib/seaborn
- 1 end-to-end EDA project
Phase 3: Get hired
DAY 36-40
Statistics
- Mean, median, spread
- Distributions + sampling
- Hypothesis testing, A/B tests
- Correlation vs causation
DAY 41-45
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