Six months is enough to go from spreadsheet basics to a job-ready analyst portfolio — if you learn the tools in the right order. Most data analyst roadmap guides hand you a random list of ten tools and wish you luck. This one follows one deliberate arc — Excel → SQL → Power BI → Python basics — and tells you what to learn each month, what to build with it, and how to know when you’re done with each one. It assumes roughly 2–4 focused hours a day, and is honest about what six months cannot do. Still deciding whether the field fits you? Read our take on whether data analytics is a good career, then come back here.
Why This Order Works: Excel First, Power BI Before Deep Python
Excel comes first because it is where analyst work — and analyst interviews — actually start. Almost every company in India still runs reports on spreadsheets, and Excel teaches you data thinking (rows, columns, logic, summaries) with zero setup. SQL comes second because real company data does not live in files someone emails you; it lives in databases, and analysts are expected to pull it themselves. Power BI comes before serious Python because Indian entry-level roles are dashboard-heavy: a polished, shareable dashboard is visible proof of skill you can show in an interview within four months. Python is a growth skill, not a gatekeeper — it makes you faster and opens better roles later, but no fresher should delay applying until their Python is “ready”.
Month 1: Excel — Learn to Think in Data
Your only goal this month is fluency: clean, summarise and chart any raw table without hesitation.
- Core formulas: SUMIFS, COUNTIFS, AVERAGEIFS, IF and nested IFs
- Lookups: XLOOKUP, VLOOKUP, INDEX + MATCH
- Pivot tables and pivot charts — the single most-used analyst feature
- Conditional formatting, data validation, filters, text and date functions
- Power Query basics: importing and cleaning a messy file
Project: Download a messy sales dataset from Kaggle, clean it in Excel, and build a monthly sales report with pivot tables and charts — totals by region, product and month.
Free practice: Microsoft Learn’s free Excel modules, Kaggle datasets for raw material, and YouTube walkthroughs for pivot tables and XLOOKUP.
Done looks like: You can take an unfamiliar spreadsheet and produce a correct summary table and chart in under 30 minutes.
Month 2: SQL — Pull Your Own Data
SQL separates analysts from report-formatters. Learn it in this sequence, typing every query yourself:
- SELECT, FROM, WHERE, ORDER BY, LIMIT — reading data
- COUNT, SUM, AVG with GROUP BY and HAVING — summarising data
- Joins: INNER, LEFT, RIGHT — combining tables (the most-tested interview topic)
- Subqueries and CTEs (WITH clauses) — structuring bigger questions
- Window functions: ROW_NUMBER, RANK, running totals
- CASE statements and basic date/string functions
Project: Take an e-commerce dataset, load it into MySQL or PostgreSQL, and write 10+ queries answering real business questions — top customers, monthly revenue trend, repeat-purchase rate, best-selling categories.
Free practice: SQLZoo’s interactive tutorials, HackerRank’s free SQL track, and LeetCode’s database problems once basics are solid.
Done looks like: You can write a join with a GROUP BY and a CASE statement from memory, and explain what each line does.
Month 3: Data Cleaning, Statistics Basics, and Level-2 Skills
Real data is dirty, and this month teaches you to handle it — plus the small set of statistics analysts actually use every week.
- Cleaning: duplicates, missing values, inconsistent formats, outliers, typos in categories
- Statistics that matter: mean vs median, percentages and percentage change, standard deviation in plain words, correlation vs causation, percentiles
- Level-2 Excel/SQL: combining sources, cleaning directly inside SQL queries, documenting your steps
Project: Pick a deliberately messy public dataset, clean it end to end, and write a one-page findings note: what was wrong with the data, what you fixed, and three insights the cleaned data reveals.
Free practice: Kaggle datasets (many are intentionally messy), and Khan Academy’s free introductory statistics lessons for the concepts above.
Done looks like: You can explain correlation vs causation with a real example, and your cleaning steps are documented well enough for someone else to repeat them.
Month 4: Power BI — Build Dashboards That Get You Interviewed
Power BI now gets its own full month, because this is the skill your portfolio will be judged on. Work through it in layers: Power Query for cleaning inside Power BI, data modelling (table relationships, the idea of a star schema), charts and slicers, then DAX basics — measures with SUM, AVERAGE and CALCULATE — and finally publishing to the Power BI Service so you can share a link.
Power BI or Tableau first? For beginners in India, Power BI is the pragmatic first choice: it is free to learn, built on Excel-like logic, and asked for constantly in entry-level postings. Our Power BI vs Tableau guide compares the two in depth.
Project: Build an interactive sales dashboard on real data — KPI cards, a trend chart, slicers for region and category, and a drill-down page. Publish it and keep the shareable link.
Free practice: Microsoft Learn’s free Power BI learning path, the free Power BI Desktop app, and sample datasets from Kaggle.
Done looks like: A published dashboard link you can open in an interview, with at least ten DAX measures you wrote yourself.
Month 5: Python Basics for Analysts — Plus Bigger Projects
Now Python, kept strictly to what analysts use: Jupyter notebooks, loading CSVs with pandas, filtering, merging and grouping data, handling missing values, and charting with matplotlib or seaborn. Deliberately skip machine-learning frameworks and web-scraping deep-dives this month — they are later skills, and chasing them now is the most common way beginners stall.
Project: An exploratory analysis notebook on a Kaggle dataset: clean it in pandas, produce five or six charts, and write the insight under each chart in plain language. Then redo one of your Month 1 Excel analyses in pandas to feel the difference.
Free practice: Kaggle Learn’s free pandas and data-visualisation micro-courses, and the official pandas documentation’s beginner tutorials.
Done looks like: You can load, clean, group and chart a new dataset in a notebook without copying old code line by line.
Month 6: Portfolio Polish, Applications and Interview Prep
The learning phase ends; the proving phase begins. Polish your best three or four projects — not ten half-finished ones — and give each a short write-up: the business question, the data source, your cleaning steps, the findings and your recommendation. Put the SQL project, the Power BI dashboard and the Python notebook where recruiters can see them, update your resume and LinkedIn around them, and start applying — on Naukri and LinkedIn, and to internships and MIS/reporting-analyst titles as well as “data analyst” ones, since those are common first steps in Delhi NCR. Our breakdown of data analyst jobs in Delhi shows what local employers actually ask for. Spend the remaining time on interview practice: timed SQL problems, Excel tests, and explaining your own projects out loud.
Done looks like: A live portfolio with at least three complete projects, weekly applications going out, and the ability to solve medium-level SQL problems under time pressure.
The 6-Month Data Analyst Roadmap at a Glance
| Month | Focus | Key Skills | Project |
|---|---|---|---|
| 1 | Excel | Formulas, lookups, pivot tables, Power Query | Monthly sales report from a messy Kaggle dataset |
| 2 | SQL | Joins, GROUP BY, CTEs, window functions | 10+ queries answering e-commerce business questions |
| 3 | Cleaning + Statistics | Messy-data handling, mean/median, correlation, outliers | End-to-end cleaning with a one-page findings note |
| 4 | Power BI | Modelling, DAX basics, slicers, publishing | Interactive sales dashboard with a shareable link |
| 5 | Python Basics | pandas, Jupyter, matplotlib/seaborn | Exploratory analysis notebook with written insights |
| 6 | Portfolio + Job Prep | Project write-ups, resume, interview practice | Polished portfolio of 3–4 complete projects |
DSSD Value Pick: The Same Roadmap, With a Mentor Watching
Everything above can be self-learned for free — and we mean that. What the free route cannot give you is feedback. Most self-learners stall in Month 2 or Month 4: an SQL join that almost works, a Power BI model giving wrong totals, and nobody to show them why. If you would rather follow this exact Excel → SQL → Power BI arc in a classroom, DSSD’s Data Analytics course in Rohini is built on the same sequence, with live projects, mentor review and job assistance at the end — see our Data Analytics course in Delhi page for what the program covers, and contact DSSD for the current fee and batch schedule. Whichever route you choose — self-study, a structured platform such as CUET Academy, or a classroom course — the roadmap itself stays the same.
An Honest Note: What 6 Months Can and Cannot Do
Six months will not make you a senior analyst, a machine-learning engineer or a data scientist, and any roadmap promising that is selling, not teaching. What six months can do — with daily, hands-on practice — is take you from zero to a portfolio that credibly qualifies you for entry-level analyst, MIS analyst and reporting roles, and to interviews where you can defend your work with confidence. If you are starting with zero Excel experience, aim for closer to eight months rather than six; if you already use spreadsheets daily, you may finish the tool arc in four and spend two on projects. The roadmap is a pace, not a deadline, and a slower finish with solid projects beats a fast finish with none.
Bottom Line
Follow the order — Excel first, then SQL, then Power BI, with Python basics at the end — build one project per month, and finish with a small, polished portfolio. That is the whole plan. The hardest part is not choosing tools; it is sitting down every day and doing the work.
Frequently Asked Questions
Yes — for entry-level roles, with consistent daily practice and a portfolio of complete projects. Six months will not make you senior, but it is enough to qualify for fresher and junior analyst positions.
Two to four focused hours a day is realistic for most learners. What matters more than the number is consistency — daily practice beats weekend marathons.
Excel first. It teaches data thinking with no setup, and it is still the tool most companies use for reporting. SQL follows naturally once you understand tables, filtering and summarising.
Not for entry-level roles. Excel, SQL and Power BI are enough to start. Python is a growth skill that opens better roles later, so learn the basics after your dashboard skills are solid.
Power BI, for most beginners in India: it is free to learn, builds on Excel logic, and is asked for constantly in entry-level postings. Tableau is worth adding later if target roles ask for it.
No advanced maths. You need percentages, averages, medians, percentage change and a plain-language understanding of correlation and variation — all covered in Month 3 of this roadmap.
Microsoft Learn (Excel and Power BI), Kaggle Learn (SQL and pandas), SQLZoo and HackerRank for SQL practice, and Kaggle datasets for every project. All are free.
A cleaned Excel sales report, ten or more SQL queries on an e-commerce dataset, a published Power BI dashboard, and a Python exploratory-analysis notebook — three or four complete projects beat ten half-finished ones.
Yes — it is written for 2–4 hours a day, so most working professionals can follow it. Expect it to take closer to eight months if your weekdays are tight; the order of tools does not change.
No. Employers hire on portfolio and interview performance: a dashboard link, SQL answers and a project you can explain matter far more than a certificate. Certificates help structure learning, but they do not replace projects.
MIS analyst, reporting analyst, business analyst (junior), data associate and operations analyst. These roles overlap heavily with entry-level data analysis and are common first steps.
Yes. Starting in college or right after Class 12 is an advantage — you graduate with a portfolio. Just make sure your projects are complete and documented, since you will not yet have work experience to lean on.
