Month 5–6 — Interview Prep + Applications
Solve 100+ LeetCode SQL problems. Practice:
- SQL live coding (interviewer shares screen, you write queries).
- Statistics case studies (e.g., "campaign conversion dropped 20% — what do you investigate?").
- Dashboard walkthroughs.
- Behavioural questions (Tell me about a time…).
Apply to 100+ roles. Target product companies, GCCs, and BFSI. Expect 3–5 offers at ₹5–12 LPA fresher.
Frequently Asked Questions
How long to become a data analyst?
6 months of focused study to be job-ready.
Do I need a degree?
Helpful but not required. Portfolio + skills matter more.
Which tool — Power BI or Tableau?
Power BI for Microsoft shops. Tableau for analytics-first firms.
Is Python needed?
Not mandatory, but a plus. Learn pandas basics.
Salary for fresher data analyst?
₹5–12 LPA. Senior: ₹25–50 LPA.
What's the biggest mistake?
Learning too many tools. Pick one stack and master it.
Common Pitfalls in the DA Roadmap
Most learners waste 3–6 months on these avoidable mistakes:
- Tutorial hell. Watching 80 hours of video and building nothing. Fix: build 3 projects, even if imperfect.
- Tool obsession. Switching between Power BI, Tableau, Looker, Metabase every week. Fix: pick one and stick with it for 6 months.
- Skipping SQL. "I'll learn SQL after I finish the course." Fix: SQL is 80% of the interviews — start week 1.
- Statistics avoidance. "Statistics is hard, I'll skip it." Fix: dedicate 2 hours/week to stats. It's the differentiator.
- No portfolio. Applying without GitHub projects. Fix: build 3 projects in months 3–6.
- Low application volume. Sending 10 applications. Fix: 100+ applications in the active search phase.
Frequently Asked Questions (Deep Dive)
Is data analyst a good career in 2026?
Yes — strong demand across industries. Indian fresher salaries are ₹5–12 LPA, mid-level ₹12–25 LPA, senior ₹25–50 LPA. Demand is growing 15–20% year-on-year. The role is also a strong stepping stone to data scientist, product analyst, or business analyst roles.
Can I become a data analyst without a degree?
Yes — roughly 30% of working data analysts in India don't have a degree. What matters is portfolio (3 projects on GitHub), SQL mastery, and interview performance. Some employers still filter by degree, but the trend is toward skills-based hiring.
How long does this roadmap take?
6 months of focused study (15–20 hours/week) to be job-ready. Faster is possible if you already know SQL or Excel. Slower is fine — many learners take 9–12 months while working full-time.
Which is harder — SQL or statistics?
SQL is easier to learn but harder to master. Basic SQL takes 2–4 weeks; advanced SQL (window functions, CTEs, query optimisation) takes 3–6 months. Statistics basics (mean, median, distributions) take 4–6 weeks; advanced (hypothesis testing, regression, A/B testing) takes 3–6 months. Both are essential.
DA Roadmap Decision Points
- Excel vs SQL first: SQL — it's tested in 80% of interviews and used daily.
- Power BI vs Tableau: Power BI for Microsoft shops. Tableau for analytics-first firms.
- Python or no Python: Yes — basic pandas lifts your candidacy 20%.
DA Career Ladder — From Fresher to Director
Realistic career progression in India:
| Level | Years | Title | Salary (LPA) |
|---|
| Entry | 0–2 | Junior Data Analyst | ₹5–12 |
| Mid | 2–5 | Data Analyst | ₹12–25 |
| Senior | 5–8 | Senior Data Analyst | ₹25–45 |
| Lead | 8–12 | Lead Data Analyst / Analytics Manager | ₹45–75 |
| Director | 12+ | Director of Analytics / VP Analytics | ₹75–150+ |
The DA → Senior DA jump (year 5) is the biggest inflection — that's where salaries double and work shifts from execution to strategy. Most learners hit this wall without focused development, so invest in stakeholder management and business thinking from year 3 onwards.
Photo: NASA/JPL-Caltech, Public Domain (NASA), via NASA Image and Video Library (https://images.nasa.gov/details/PIA25150)
Fazlur Rahman
