Data Analyst Career Roadmap — Skills, Role Progression, Salary & 90-Day Learning Plan
The data analyst career path is one of the most accessible routes into tech — but only if you build the right skills in the right order. This chapter gives you a clear, stage-by-stage roadmap: what to learn, what roles to target, what salary to expect at each stage, and a concrete 90-day plan you can start today.
⏱ 20 min read📅 September 2026✍ EVIKA ACADEMY, Noida
The 4 Stages of a Data Analyst Career
Most data analysts move through four career stages. Each stage has a distinct skill profile, typical responsibilities, and salary range. Understanding this progression helps you know exactly where you are now and what you need to reach the next level — rather than learning randomly and hoping for the best.
Stage 1
Junior / Trainee Data Analyst0–1 year · ₹3–5 LPA
Excel (VLOOKUP, pivot tables), basic SQL (SELECT, WHERE, GROUP BY), data cleaning, simple charts and dashboards. Focus: understand the data, follow instructions, document your work.
Stage 2
Data Analyst1–3 years · ₹5–10 LPA
Advanced SQL (JOINs, window functions, CTEs), Python or Power BI, storytelling with data, working independently on end-to-end analyses. Focus: own your analysis pipeline from raw data to stakeholder presentation.
Stage 3
Senior Data Analyst3–6 years · ₹10–18 LPA
Statistical analysis (hypothesis testing, A/B testing), Python for automation, mentoring juniors, defining metrics frameworks. Focus: influence decisions, not just report on them.
Stage 4
Lead / Principal Analyst or Manager6+ years · ₹18–35 LPA
Data strategy, stakeholder management at director level, team building, cross-functional project ownership. Focus: build the analytics function, not just do the analysis.
The Core Data Analyst Skill Stack
Every data analyst role, across every industry and company size, is built on the same foundational skill stack. The tools may vary — Oracle vs MySQL, Power BI vs Tableau — but the underlying competencies are universal.
🏗 Foundation (must-have)
SQL
The non-negotiable. Every data analyst job requires it. Master SELECT through window functions.
Excel / Google Sheets
Still used at 90%+ of companies for ad hoc analysis, reports, and communication.
Data cleaning
Handling nulls, duplicates, type mismatches, outliers — real datasets are always messy.
Basic statistics
Mean, median, distribution, correlation — covered in Chapter 69 of this series.
📊 Visualisation (high-impact)
Power BI or Tableau
Power BI dominates in India; Tableau is strong in MNCs and startups. Learn at least one well.
Dashboard design
Covered in Chapter 68. A well-designed dashboard is a career accelerator.
Storytelling with data
Translating charts into decisions is what separates good analysts from great ones.
🐍 Automation & Depth
Python (pandas, matplotlib)
Automate repetitive reporting, handle large datasets, and perform EDA faster than Excel.
Hypothesis testing & A/B
Makes you credible in product and growth analytics roles.
Git / version control
Increasingly expected even for analysts — keeps analysis reproducible and shareable.
90-Day Beginner-to-Job-Ready Learning Plan
If you have no prior data background, this 90-day plan takes you from zero to interview-ready. It is structured around the minimum viable skill set that gets you your first junior analyst offer — not the maximum possible learning.
Create a GitHub profile with your SQL queries and a README for each project
Optimise LinkedIn: headline "Data Analyst | SQL | Power BI | Excel", add skills, 2-line About
Prepare for interviews: 15 SQL questions, 10 scenario questions (see this series Chapter 66 for communication)
Apply to 5 jobs per day. Target: junior analyst, MIS analyst, business analyst, data operations analyst
Portfolio Strategy — What Projects Actually Get You Hired
A portfolio is not a collection of everything you learned. It is a curated set of projects that answer the question every hiring manager asks silently: "Can this person solve my actual business problems?" Here is how to build one that answers yes.
Project type
What it demonstrates
Example
Tools
Sales / Revenue Analysis
SQL + business context + dashboard
Monthly sales by region, product, and channel with trend and YoY comparison
SQL + Power BI
Customer Segmentation
Data manipulation + insight generation
Segment customers by recency, frequency, monetary value (RFM). Describe each segment.
Python/Excel + Power BI
Data Cleaning Project
Handling messy real-world data
Clean a raw Kaggle dataset: fix nulls, remove duplicates, standardise categories, document findings
Python (pandas) or Excel
Operational Dashboard
Dashboard design (Chapter 68)
HR attrition dashboard or supply chain delay tracker with KPI cards, trend and drill-through
Every project README must open with: "What problem does this solve?" Not "I used pandas to..."
✅ Show your process
Include a data quality section: what was messy, what you fixed, what you chose to ignore and why.
✅ Add a shareable output
A GitHub repo alone is not enough. Include a Power BI publish-to-web link, a PDF report, or a Google Data Studio link.
Salary Progression — What Drives Pay at Each Stage
Data analyst salaries vary significantly by city, company type, and specialisation. These ranges reflect the market across metro cities; Tier 2 cities are typically 20–30% lower. Note: these are approximate market ranges, not guaranteed outcomes.
₹3–5 LPA
Junior / Trainee Data Analyst
SQL proficiency + Excel + any dashboard tool
₹5–10 LPA
Data Analyst (2+ years)
Advanced SQL + Python or Power BI + portfolio of delivered projects
Team leadership + data strategy + executive stakeholder management
Salary accelerators: product analytics companies, fintech/SaaS pay 20–40% above market. Domain depth (fintech, healthcare, ecom) adds ₹1–3 LPA vs generalist roles. Certifications (Microsoft PL-300, Google Data Analytics) add credibility at junior level.
6 Career Mistakes That Slow Data Analysts Down
✗
Learning everything before applying
What to do instead: Most analysts get their first job with SQL + Excel + one BI tool. The rest is learned on the job. Apply when you have the basics — not after you feel "ready."
✗
No portfolio — just certificates
What to do instead: Certificates prove you watched videos. Projects prove you can analyse data. Every hiring manager will ask: "Show me something you built." Have an answer.
✗
Skipping the communication skills
What to do instead: Chapter 66 covered this. An analyst who delivers a clear, actionable insight in 3 sentences is worth more than one who writes a technically perfect but unreadable report.
✗
Specialising too early
What to do instead: In your first two years, work across domains: fintech, ecom, ops. See where your instincts are sharpest. Domain specialisation pays at Stage 3 and above, not before.
✗
Staying in one tool forever
What to do instead: If you only know Power BI, you are invisible to companies that use Tableau or Looker. Learn the concepts deeply, then the tool is just syntax. A second BI tool takes weeks, not months.
✗
Not tracking and quantifying your impact
What to do instead: Every analysis you run should have a documented outcome: "My dashboard reduced monthly reporting time by 4 hours" or "My retention analysis informed a campaign that recovered 200 users." Keep these for your resume and performance reviews.
Which Industry Should You Target First?
Your first data analyst role shapes the next 3–4 years. Different industries have different data maturity levels, tooling cultures, and growth trajectories. Choose strategically.
E-commerce / Retail
High data volume, fast feedback loops, clear business metrics (GMV, conversion, churn). Great for building strong SQL and BI skills.
₹4–9 LPA⭐⭐⭐⭐⭐
Fintech / Banking
Premium pay, structured data, strong SQL culture. Risk, fraud, and credit analytics are highly valued. More compliance — slower to ship.
₹5–12 LPA⭐⭐⭐⭐⭐
IT Services / Consulting
Exposure to multiple clients and domains. Good for generalists. Can feel repetitive (MIS-heavy). Training programs for freshers.
₹3.5–7 LPA⭐⭐⭐
SaaS / Product
Highest analyst growth ceiling. Data-driven culture, product analytics, A/B testing. Competitive to enter without experience.
Accessible for freshers, high learning pace. User engagement, cohort analysis, funnel optimisation. Lower pay at small companies.
₹3–7 LPA⭐⭐⭐
Start Your Data Analyst Career with EVIKA ACADEMY
Our data analytics course in Noida Sector 51 is designed to take you from zero to job-ready — with SQL, Excel, Power BI, Python, statistics, dashboard design, communication skills and interview prep all in one programme. Online & offline classes available.
With focused learning, most people can become interview-ready for junior data analyst roles in 3–6 months. The key is learning in the right order: Excel and SQL first, then a BI tool (Power BI or Tableau), then building 2–3 portfolio projects. Time varies based on your starting point and hours per day invested.
What skills are required to become a data analyst?
The core skills are: SQL (the most important and universally required skill), Excel or Google Sheets, at least one BI tool (Power BI, Tableau, or Looker), basic statistics (mean, median, distributions, correlation), and the ability to communicate insights clearly to non-technical stakeholders. Python is a valuable addition but is not required for most junior roles.
What is the salary of a data analyst?
In Indian metro cities, junior analysts typically earn ₹3–5 LPA, mid-level analysts with 2–4 years earn ₹5–10 LPA, and senior analysts earn ₹10–18 LPA. Fintech, SaaS, and product analytics companies typically pay 20–40% above market. These are approximate market ranges that vary by company and individual.
Can I become a data analyst without a computer science degree?
Yes. Many successful data analysts have non-CS backgrounds — maths, statistics, economics, commerce, engineering. What matters is: can you write SQL, can you build dashboards, can you communicate insights? A strong portfolio of projects often outweighs degree requirements at most companies.
Where can I learn data analytics in Noida?
EVIKA ACADEMY in Noida Sector 51 offers a comprehensive data analytics training programme covering SQL, Excel, Power BI, Python, statistics, dashboard design, and interview preparation. Online and offline classes are available. WhatsApp +91-8081035456 to book a free demo.