📈

Data Analyst

Transform Data into Business Insights

Salary Expectations (₹ INR, per annum)

Fresher

₹4 – ₹7 LPA

Mid-Level

₹8 – ₹14 LPA

Senior

₹15 – ₹25+ LPA

Detailed Learning Path

Spreadsheet Mastery (Excel)

3–4 Weeks

Excel is the most fundamental tool in business analytics. Mastering it is a non-negotiable first step.

Key Topics to Cover

Formulas & Functions — VLOOKUP, INDEX/MATCH, IF statements, and text/date functions.

PivotTables — Summarize large datasets quickly to find insights without writing any formulas.

Data Cleaning — "Text to Columns", "Remove Duplicates", and Power Query to clean messy data.

Dashboarding — Basic interactive dashboards using Charts, Slicers, and Timelines.

Recommended Resources

Codebasics YouTube

Real-world data analytics projects using Excel, SQL and Power BI.

ExcelIsFun YouTube

Arguably the most comprehensive Excel channel on the planet.

SQL for Data Extraction

4–6 Weeks

SQL is how you "talk" to databases. It is the single most important technical skill for a data analyst.

Key Topics to Cover

Core Statements — SELECT, FROM, WHERE, ORDER BY, and LIMIT for basic data retrieval.

JOINs — INNER, LEFT, RIGHT, and FULL JOINs to combine data from multiple tables.

Aggregations — GROUP BY with COUNT(), SUM(), AVG() to summarize data.

Advanced SQL — Subqueries, Common Table Expressions (CTEs), and Window Functions for complex analysis.

Recommended Resources

Ankit Bansal YouTube

High-quality SQL interview questions and tutorials.

Mode's SQL Tutorial Free Tutorial

A fantastic, interactive tutorial from beginners to advanced.

Data Visualization (Power BI)

5–8 Weeks

Learn BI tools to create clear, compelling dashboards and reports that tell a story.

Key Topics to Cover

Power BI Fundamentals — Connect to data sources, use Power Query for transformation, and build data models.

DAX — Write powerful calculations and measures — like Excel formulas but much more powerful.

Visualizations — Master chart types, formatting, and how to create interactive reports.

Data Storytelling — Present data in a clear, concise, and compelling narrative.

Recommended Resources

Maven Analytics Paid Courses

Excellent project-based courses for Power BI and Tableau.

Storytelling with Data Book/Blog

The definitive guide on communicating data insights effectively.

All Roadmaps