// For the Community

Your Path to Becoming a
Data Analyst

Everything I wish I had when I started — a clear roadmap, handpicked resources, and a 90-day action plan to land your first DA role. 100% free.

🗺️ DA Roadmap 📚 Resources 🗓️ 90-Day Plan ✅ Checklist

// Step-by-Step

The DA Roadmap

A structured path from zero to job-ready. Each stage builds on the last — don't skip ahead.

01
✓ Foundation
Weeks 1–2
Spreadsheets & Excel Basics
Before touching code, master the tool every analyst uses daily. Learn data entry, sorting, filtering, basic formulas, and pivot tables. This is your data intuition foundation.
ExcelGoogle SheetsPivot TablesVLOOKUPConditional Formatting
02
✓ Query Language
Weeks 3–5
SQL — The Core Analyst Skill
SQL is used in 90%+ of DA job descriptions. Learn SELECT, WHERE, GROUP BY, JOINs, subqueries, and window functions. Practice on real datasets daily.
MySQLPostgreSQLJOINsWindow FunctionsAggregationsCTEs
03
◉ Currently Here
Weeks 6–9
Python for Data Analysis
Python automates what Excel can't. Focus on Pandas for data manipulation, NumPy for calculations, and Matplotlib/Seaborn for visualisation. Don't try to learn everything — focus on data tasks.
PythonPandasNumPyMatplotlibSeabornJupyter
04
○ Visualisation
Weeks 10–12
Power BI / Tableau
Turn data into decisions with interactive dashboards. Learn DAX for calculated measures, data modeling, and how to tell a story through charts. Power BI is free and widely used in India.
Power BIDAXData ModelingTableauGoogle Looker
05
○ Statistics
Weeks 13–14
Statistics & Analytical Thinking
You don't need a statistics degree — but you need to know mean vs median, distributions, correlation vs causation, and how to validate insights. This separates good analysts from great ones.
Descriptive StatsEDAHypothesis TestingCorrelationA/B Testing
06
○ Portfolio
Weeks 15–18
Build 2–3 Real Projects
Projects are your proof of skill. Analyse a real dataset, ask a business question, clean the data, visualise it, and write your findings. Put it on GitHub. This is what gets you interviews.
GitHubCase StudiesData StorytellingEnd-to-End Analysis
07
○ Job Search
Weeks 19–24
Resume, LinkedIn & Job Hunting
Optimise your resume for ATS, write a strong LinkedIn profile, start applying on Naukri/LinkedIn/Internshala, and prepare for SQL and case study interviews. Consistency beats intensity here.
ATS ResumeLinkedInSQL InterviewsCase InterviewsNetworking

// Handpicked

Curated Resources

No fluff. These are the actual resources I used and recommend — organised by skill.

SQL Python Power BI Excel Statistics Career
Free🌐
W3Schools SQL
The best starting point for SQL basics. Interactive exercises, clear syntax examples, instant results.
w3schools.com/sql →
Free📘
Mode SQL Tutorial
Goes beyond basics — covers window functions, subqueries, and analytics-specific SQL. Highly recommended.
mode.com/sql-tutorial →
Platform💻
HackerRank SQL
Best platform to practice SQL interview questions. Start from Easy and work your way up. Employers check this profile.
hackerrank.com →
YouTube▶️
Alex the Analyst — SQL
Practical SQL tutorials built for aspiring data analysts. Great for beginners who prefer video learning.
YouTube →
Platform🧩
LeetCode — Top SQL 50
Interview-focused SQL problems. The Top 50 set covers everything you'll face in DA interviews at top companies.
leetcode.com →
Free🦓
SQLZoo
Interactive SQL learning with real databases. Practice on actual data — much better than reading alone.
sqlzoo.net →
Free🐍
Kaggle Python Course
Best free Python course for analysts. Focused on data tasks, not software engineering. Includes hands-on notebooks.
kaggle.com/learn →
Free🐼
Kaggle Pandas Course
Pandas is the #1 Python library for data analysis. This course teaches it the right way — with real data problems.
kaggle.com/learn →
YouTube▶️
Alex the Analyst — Python
Python for data analysis series. Covers Pandas, Matplotlib and real project walkthroughs — great for beginners.
YouTube →
Platform📗
Real Python
In-depth Python tutorials including data analysis, pandas, and visualisation. Higher quality than most free content.
realpython.com →
Free📊
Microsoft Learn — Power BI
Official Microsoft learning path for Power BI. The most up-to-date and comprehensive free resource available.
learn.microsoft.com →
YouTube▶️
Guy in a Cube
Best Power BI YouTube channel. Covers DAX, data modeling, and advanced report design in a practical, no-fluff style.
YouTube →
Free🔢
DAX.guide
The DAX function reference. Bookmark this immediately. Every DAX function explained with examples and best practices.
dax.guide →
YouTube▶️
Chandoo — Excel & Power BI
Chandoo has been teaching Excel and Power BI for 15+ years. Practical, project-based, excellent for Indian learners.
YouTube →
Free📑
ExcelJet
The best Excel reference site. Every formula explained clearly with examples. Use as a lookup when stuck on a formula.
exceljet.net →
YouTube▶️
Chandoo — Excel Mastery
300+ Excel tutorials covering everything from basics to advanced dashboards. The go-to channel for Excel learners in India.
YouTube →
Platform🗃️
Kaggle Datasets
Download free real-world datasets to practise Excel analysis. Sales data, HR data, ecommerce — all available for free.
kaggle.com/datasets →
Free📐
Khan Academy Statistics
Best place to learn statistics from scratch. Covers mean, median, distributions, probability, and hypothesis testing — all free.
khanacademy.org →
Free📈
Kaggle — Data Visualisation
Learn how to visualise data to surface patterns and communicate findings. Practical Python-based course using real datasets.
kaggle.com/learn →
YouTube▶️
StatQuest with Josh Starmer
Statistics explained with clarity and humour. Best channel for understanding stats concepts visually. Highly recommended.
YouTube →
Platform💼
LinkedIn Jobs
Best platform for DA jobs in India. Optimise your profile first, then apply daily. Set job alerts for "data analyst" + your city.
linkedin.com/jobs →
Platform🇮🇳
Naukri.com
India's largest job portal. Most mid-size and enterprise companies post DA roles here. Upload your resume and apply daily.
naukri.com →
Platform🎓
Internshala — DA Internships
Best platform for freshers and students. Get your first data experience through internships before applying to full-time roles.
internshala.com →
Platform🐙
GitHub — Build Your Portfolio
Every project you do should live on GitHub. Recruiters check it. Even 2–3 clean repos with good README files stand out.
github.com →

// Action Plan

The 90-Day Plan

A week-by-week breakdown to go from beginner to job-ready in 90 days. Be consistent — 1.5–2 hours daily is enough.

Month 01 · Days 1–30
Build the Foundation
Excel + SQL — the two must-haves
Week 1
  • Learn Excel fundamentals — formulas, sorting, filtering
  • Practice pivot tables with a free dataset
  • Set up MySQL or use online SQL editor
Week 2
  • Master VLOOKUP, IF, COUNTIF in Excel
  • Start SQL — SELECT, WHERE, ORDER BY, GROUP BY
  • Solve 5 SQL problems on HackerRank
Week 3–4
  • Learn SQL JOINs (INNER, LEFT, RIGHT)
  • Practice subqueries and aggregation
  • Complete Excel dashboard using pivot charts
  • Solve 20+ SQL problems total
Month GoalComfortable writing SQL queries & building Excel dashboards
Month 02 · Days 31–60
Add Python & Power BI
Automate analysis + visualise it
Week 5–6
  • Python basics — variables, loops, functions
  • Install Jupyter Notebook, explore Pandas
  • Load a CSV, clean it, run basic EDA
Week 7
  • Data visualisation with Matplotlib & Seaborn
  • Replicate your Excel analysis in Python
  • Install Power BI Desktop (free)
Week 8
  • Power BI basics — import data, build charts
  • Learn DAX basics — SUM, CALCULATE, FILTER
  • Build a 3-page interactive Power BI report
Month GoalCompleted one end-to-end project using Python + Power BI
Month 03 · Days 61–90
Build, Apply & Get Hired
Portfolio + resume + active job hunt
Week 9–10
  • Build Project 1 — full SQL + Python analysis
  • Create a GitHub repo with proper README
  • Write a LinkedIn post about your project
Week 11
  • Build Project 2 — Power BI dashboard
  • Write an ATS-optimised resume
  • Optimise your LinkedIn profile fully
Week 12–13
  • Apply to 5+ jobs daily on LinkedIn & Naukri
  • Practice SQL interview questions (LeetCode)
  • Prepare case study answers for interviews
  • Start networking — connect with DAs on LinkedIn
Month GoalResume submitted to 50+ roles, 2–3 interviews secured

// Before You Apply

Job-Ready Checklist

Tick these off before sending your first application. Each one increases your chances significantly.

🛠️ Technical Skills

  • Comfortable writing SQL JOINs & subqueries
  • Solved 30+ SQL problems on HackerRank/LeetCode
  • Built a Pandas analysis project in Python
  • Created an interactive Power BI dashboard
  • Comfortable with Excel pivot tables & VLOOKUP
  • Know the difference between correlation & causation

📂 Portfolio

  • GitHub account created with profile README
  • 2+ projects uploaded with clear README
  • Each project has a business question & findings
  • At least one project uses SQL + Python + visualisation

📄 Resume & LinkedIn

  • Resume is ATS-friendly (no tables, no emojis)
  • All bullet points are action–method–outcome format
  • Skills section has SQL, Python, Power BI, Excel as keywords
  • LinkedIn headline mentions "Data Analyst"
  • LinkedIn About section is filled out clearly
  • GitHub link is on your resume and LinkedIn

🎯 Interview Prep

  • Can explain every project on your resume clearly
  • Practiced "Tell me about yourself" answer
  • Know how to explain a business problem using data
  • Applied to at least 20 jobs
  • Connected with 10+ Data Analysts on LinkedIn