Placement rate
95% success
Avg salary jump
+42% after prep
Time to offer
4–8 weeks avg
Free Learning Hub · Updated April 2026
Your Complete
Data Analyst
Learning Path
Everything you need to go from zero to hired — free SQL tutorials, Python guides, case study frameworks, mock interview questions and a 8-week prep roadmap used by 10,000+ learners.
0+
Learners enrolled
0+
Candidates placed
0%
Interview success rate
0+
Expert mentors
🎯 SQL Window Functions ·
🐍 Pandas & NumPy ·
📊 Business Case Studies ·
🏆 RANK() & ROW_NUMBER() ·
🔗 SQL JOINs Mastery ·
📈 A/B Testing & Metrics ·
🤖 Python Interview Qs ·
💼 Resume & Storytelling ·
🏢 Google · Amazon · Flipkart ·
🎯 SQL Window Functions ·
🐍 Pandas & NumPy ·
📊 Business Case Studies ·
🏆 RANK() & ROW_NUMBER() ·
🔗 SQL JOINs Mastery ·
📈 A/B Testing & Metrics ·
🤖 Python Interview Qs ·
💼 Resume & Storytelling ·
🏢 Google · Amazon · Flipkart ·
Learning Tracks
Choose your learning track
Three focused tracks — each with structured content, real interview questions and a clear path to getting hired.
Most Important
SQL for Data Analysts
Required in 90% of analyst job listings
SELECT, WHERE, ORDER BYEasy
GROUP BY & AggregationsEasy
All JOIN TypesMedium
Subqueries & CTEsMedium
Window FunctionsHard
Interview readiness8 topics covered
Start SQL Learning →
High Demand
Python for Analytics
Pandas, NumPy, Matplotlib & more
Python Basics & SetupEasy
Pandas — Complete GuideMedium
NumPy & StatisticsMedium
Matplotlib & SeabornEasy
End-to-End ProjectsHard
Interview readiness20 pages covered
Start Python Learning →
Interview Winning
Business Case Studies
Frameworks, metrics & A/B testing
Case Study FrameworksMedium
Metric Design & KPIsMedium
A/B Testing ConceptsHard
Root Cause AnalysisHard
Funnel & Cohort AnalysisMedium
Interview readiness6 modules covered
Start Case Studies →
Structured Roadmap
Your 8-week roadmap to
a data analyst job
Follow this exact sequence. Each week builds on the previous. 800+ candidates have used this roadmap to land offers.
Week 01 – 02
14 days
SQL Foundations
Master SELECT, WHERE, GROUP BY, HAVING and all JOIN types. Solve 20 practice problems daily.
Week 03 – 04
14 days
Advanced SQL
Window functions, CTEs, subqueries. The topics that separate junior from senior analysts in interviews.
Week 05 – 06
14 days
Python & Pandas
Python basics, Pandas DataFrames, groupby, merge. Complete one end-to-end EDA project using real data.
Week 07 – 08
14 days
Mock Interviews
3 full mock interview sessions, case study prep, resume polish, HR round practice. Interview ready.
Week by Week
Detailed week-by-week breakdown
Exactly what to study, in what order, and what outcome to expect by the end of each week.
📖
Week 1
SQL Basics & Fundamentals
Start with SELECT, FROM, WHERE, ORDER BY and LIMIT. Learn how databases work, what tables are, and how to read and write simple queries. Aim for 10 practice queries per day.
SELECT *WHERE conditionsORDER BYDISTINCTNULL handling
✓ By end of week: Write any basic SELECT query confidently. Filter data by any condition.
📊
Week 2
GROUP BY, Aggregations & JOINs
Master COUNT, SUM, AVG, MIN, MAX with GROUP BY and HAVING. Then learn all 4 JOIN types — INNER, LEFT, RIGHT, FULL OUTER. The anti-join pattern (LEFT JOIN + IS NULL) is essential.
COUNT/SUM/AVGGROUP BYHAVINGINNER JOINLEFT JOIN
✓ By end of week: Answer “revenue per region” and “customers with no orders” questions in SQL.
🧩
Week 3
Subqueries & CTEs
Learn to nest queries inside queries, and write clean multi-step logic using CTEs (WITH clauses). Practice rewriting messy nested subqueries into readable CTEs — interviewers notice this.
SubqueriesWITH clauseMulti-CTE chainsCorrelated subqueries
✓ By end of week: Write any multi-step SQL query cleanly using CTEs. No more deeply nested queries.
🏆
Week 4
Window Functions (Advanced SQL)
The single most tested SQL topic. Master RANK, DENSE_RANK, ROW_NUMBER, LAG, LEAD, SUM OVER, and rolling averages. Solve 15+ window function interview questions from real companies.
RANK()LAG/LEADPARTITION BYRunning totalsRolling avg
✓ By end of week: Solve window function questions from Google, Amazon, Flipkart without hesitation.
🐍
Week 5
Python Basics & Pandas
Set up Python and Jupyter. Learn Pandas DataFrames — read_csv, head, info, describe, filtering, groupby, merge, pivot_table. Complete a sales analysis project using a real dataset.
DataFramesgroupbymergepivot_tableapply + lambda
✓ By end of week: Load, clean and analyse any CSV dataset using Pandas. Create grouped summaries.
📈
Week 6
Visualisation & EDA Project
Matplotlib and Seaborn for charts. Complete an end-to-end EDA project — load, clean, analyse, visualise and present insights. Upload to GitHub for your portfolio.
MatplotlibSeabornEDA workflowGitHub portfolio
✓ By end of week: Portfolio project live on GitHub with charts, insights and a business summary.
📋
Week 7
Case Studies & Business Metrics
Learn the 5 case study frameworks. Practice metric design, A/B test interpretation, funnel analysis and root cause diagnosis. Prepare answers for the 10 most common analyst case questions.
Metric designA/B testingRoot causeFunnel analysis
✓ By end of week: Confidently answer “DAU dropped 20%, why?” and “design metrics for X feature” questions.
🎯
Week 8
Mock Interviews + Final Polish
3 full mock interview sessions covering all rounds. Resume review, LinkedIn optimisation, behavioral prep using STAR framework. Fix any gaps from mock feedback. You’re interview ready.
Mock interviews x3Resume polishSTAR frameworkOffer ready
🎉 Interview ready — apply to target companies with full confidence.
Test Yourself
Quick knowledge check
Answer 5 real interview-style questions. See where you stand right now.
Free Resources
Everything included — 100% free
No paywalls. No email required. All learning content is free forever.
SQL
SQL Hub — Complete Guide
SELECT to window functions. Full theory, examples, live compiler.
8 topics · 50+ examples
Interview Qs
50+ Real SQL Questions
Google, Amazon, Flipkart, Swiggy. Easy to Hard with full answers.
50+ questions · Full solutions
Python
Python Learning Hub
20 pages from beginner to advanced. Pandas, NumPy, Seaborn.
20 pages · Beginner to advanced
Case Studies
Business Case Study Guide
Frameworks, metrics, A/B tests and 20+ worked examples.
6 frameworks · 20+ examples
Dashboards
Dashboards & KPI Design
How to design metrics, KPIs, funnels and A/B test frameworks.
KPIs · Funnels · A/B Testing
Resume
Resume & HR Round Prep
STAR framework, project storytelling, salary negotiation tips.
HR prep · Resume review guide
Projects
10 Portfolio Projects
Real datasets, GitHub-ready projects to impress every recruiter.
10 projects · Real datasets
Career
Salary Guide India 2026
Real salary ranges, top hiring companies, skills that pay more.
₹4L to ₹70L+ ranges
Placement Record
Our candidates get hired at
800+ candidates placed at top companies across India and globally. These are real placements, not estimates.
Google
Amazon
Flipkart
Swiggy
Zomato
Paytm
PhonePe
Meesho
Razorpay
CRED
Walmart
Infosys
TCS
Accenture
Deloitte
EY
Google
Amazon
Flipkart
Swiggy
Zomato
Paytm
PhonePe
Meesho
Razorpay
CRED
Walmart
Infosys
RS
Rahul Sharma
Data Analyst
Flipkart
★★★★★
“The 8-week roadmap was exactly what I needed. Got my offer 6 weeks in. The SQL window functions prep was a game-changer.”
PM
Priya Mehta
Senior Data Analyst
Amazon
★★★★★
“I failed 3 interviews before finding this. 4 weeks of structured prep later, I cracked Amazon’s analytics round. The case study frameworks are gold.”
AK
Aditya Kapoor
Product Analyst
Swiggy
★★★★★
“Coming from a non-tech background, I thought data analytics was out of reach. The beginner roadmap proved me wrong. 8 weeks later — hired at Swiggy.”
Common Questions
Questions before you start?
I have zero coding experience. Can I still learn data analytics?
Absolutely. Many of our most successful candidates started with zero coding background — from marketing, finance, operations and even teaching. SQL and Python are much easier to learn than traditional programming. Our beginner roadmap starts from absolute scratch. Most non-coders are writing their first SQL queries within 3 days.
How long will it realistically take to become interview-ready?
For complete beginners: 8–12 weeks of consistent daily practice (1–2 hours/day). For candidates with some SQL or Excel experience: 4–6 weeks. For those with some Python background: 3–4 weeks for interview-ready SQL + case studies. Consistency matters more than hours — 1 hour every day beats 7 hours on one day.
Is all this content really free? What’s the catch?
All the written content, SQL guides, Python tutorials, practice questions and the SQL compiler are completely free — no account, no email, no credit card. We make money through paid 1-on-1 mentor sessions for candidates who want live mock interviews and personalised feedback. The free content alone is enough to prepare — the paid sessions just accelerate your progress.
Should I learn SQL or Python first?
Always start with SQL. It’s required in 90% of data analyst job listings, it’s faster to learn than Python, and it directly maps to what you’ll do on the job every day. Once you’re comfortable with SQL (usually 3–4 weeks), add Python. The combination of SQL + Python covers 95% of everything data analysts need. Add one BI tool (Power BI or Tableau) after that.
What salary can I expect as a data analyst in India in 2026?
Fresher (0–2 years): ₹4–8 LPA at IT services, e-commerce, startups. Mid-level (2–5 years): ₹8–18 LPA at product companies and funded startups. Senior (5–8 years): ₹18–35 LPA at FAANG, Flipkart, Paytm-level companies. Adding Python + ML can add a 20–40% premium on top of these ranges. See our full salary guide for company-specific data.
Do I need a computer science degree to become a data analyst?
No. Many top companies — including startups and unicorns — hire analysts based on demonstrated skills, not degrees. What matters is your ability to write SQL, analyse data in Python, communicate insights clearly, and tackle business problems. A strong portfolio (2–3 solid projects on GitHub), good SQL and Python scores, and interview preparation matter far more than your degree.
Ready to start your
data analyst journey?
Join 10,000+ learners who’ve used this roadmap to land data analyst jobs at top companies. Everything is free — start today.
✓ 100% Free content
✓ No signup needed
✓ 10,000+ learners
✓ Updated for 2026
✓ Mobile friendly
