#1 India's Top IT Training Institute

×

About Uncodemy

Know more about who we are and what we stand for.

About Us

About Us

Discover our mission to equip individuals with essential IT skills and industry expertise.

Read More →
UnCodeMy Gallery

UnCodeMy Gallery

Explore highlights from our IT training sessions and success stories.

Read More →
×

Free Resources

Learn, practice and plan your career — bilkul free.

Tutorials

Tutorials

Step-by-step written tutorials to learn any technology at your own pace.

Read More →
Free Counselling

Free Counselling

Book a free video counselling session and pick the right course for you.

Read More →
Online Compiler

Online Compiler

Write, run and test your code online — no setup required.

Read More →
📊 FREE · TRACK PROGRESS

Data Analyst Roadmap: From Spreadsheets to Your First Analyst Job

Seven stages, 36 topics and a project for each stage, with progress you can tick off.

  • 🧭 7 stages in a sensible order
  • 🛠️ A project for every stage
  • ✅ Saves your ticks

How to use the Data Analyst Roadmap

  1. 1. Set your paceEnter the hours a week you can study; the week estimates adjust.
  2. 2. Work stage by stageTick topics as you learn them and build each stage's project.
  3. 3. Check your progressGet a report of what is done, what is left and what to learn next.

How the roadmap is built

The roadmap has 7 stages: Excel foundations, SQL, statistics, a dashboard tool (Power BI or Tableau), Python for data, business thinking and communication, and portfolio and job search. Each stage lists the topics that matter for entry-level work, such as XLOOKUP and PivotTables, JOINs and window functions, DAX measures, pandas groupby, and A/B tests explained in plain words, plus one project to prove the skill. When you start, the counter reads 0 of 36 topics done and estimates about 24 weeks in total at 10 hours a week.

Change the hours and the estimates scale: at 20 hours a week the same plan is roughly half as long.

Why this order

  • Excel and SQL first: they appear in most analyst job descriptions and are where daily work happens.
  • Statistics before dashboards: so your charts do not mislead.
  • One BI tool, properly: the ideas transfer between Power BI and Tableau.
  • Python after the basics: it automates what you already understand.
  • Projects throughout: employers hire on evidence.

The week figures are a rough planning guide for a beginner, not a promise, and nothing here guarantees a job. Ticks are saved in this browser only, so use Export to keep a copy. Practise SQL with the SQL practice questions, compare with the data science roadmap, and when you are ready, build a fresher resume.

Frequently asked questions

Do I need a degree in maths to become a data analyst?

No. You need comfort with percentages, averages and basic statistics, which the roadmap covers, plus curiosity about business questions.

Power BI or Tableau?

Check job listings in your city. Power BI is very common in Indian companies; Tableau is also widely used. Learn one well first.

Is the Data Analyst Roadmap free?

Yes, the Data Analyst Roadmap is free. The first time you see your first progress report, you are asked for your name and WhatsApp number once. After that, this and every other Uncodemy tool opens straight away without the form.

More free tools

See all free tools