5-Month Analyst Roadmap
100 SQL reps, one messy portfolio project, an evidence-backed resume, 40 targeted applications: the complete 5-month analyst roadmap with milestones.
- Months 1–2: SQL daily — JOINs, windows, GROUP BY traps on messy data. 100+ reps before anything else. Start at Topfolio Practice.
- Month 3: One portfolio project with real mess. Document the cleaning, not just the chart.
- Month 4: Resume rewrite — every bullet a number surviving follow-ups. Run Resume Feedback.
- Month 5: 40 targeted applications, referrals requested from builders not HR. Target: 6 interviews, 2 offers.
Milestones: 100 drills → 1 shipped project → verified resume → interviews.
Related: Data Analyst Readiness Check Execution Cohort · Become Data Analyst
Frequently Asked Questions
Can you crack analyst roles without referrals or a tier-1 college?
Yes — finished, verifiable work beats both. Small-town learners who ship beat metro learners who collect certificates.
What matters most in the portfolio project?
Documented mess: missing dates, duplicate keys, inconsistent categories — and how you handled each. Cleaning decisions, not charts.
What is the exit criteria for month 2?
100+ SQL reps on messy data covering JOINs, windows, and GROUP BY traps — before touching anything else.
Written by
Founder at Topfolio with 6+ years in data & analytics across JPMC, Ultrahuman, and high-growth startups. Sat on hiring panels, reviewed 500+ resumes, and writes practical SQL & data guides.
Related Articles
Data Analyst Skills Roadmap: What to Learn in the Age of AI
The modern data analyst skills roadmap for the AI era. Learn why syntax memorization is commoditized, what skills make you irreplaceable, and what to learn first.
Data Analyst Salary in India: 2026 Pay & Career Guide
Explore verified data analyst salary India benchmarks for 2026. Compare entry to senior pay bands, monthly take-home CTC, GCCs, and negotiation tips.
10-Point Resume Scorecard
Grade your analyst resume the way hiring managers do: 10 checks with honest score bands, plus exactly where to start fixing a failing screen first.