Two-line summary. You can become a job-ready data analyst in India without paying a rupee. Learn SQL first, then a BI tool (Tableau or Power BI), build 3-4 portfolio dashboards, and practise the interview questions. This post gives you the exact order.
Why data analytics is a smart 2026 bet
Data analyst is one of the highest demand-to-difficulty roles in the Indian job market. Unlike a full SDE path, you don't need to grind 300 LeetCode problems. You need a focused, practical skill set — and almost all of it can be learned free, in your browser, on whatever laptop (or even phone) you have.
The roadmap, in order
Step 1 — SQL (the non-negotiable skill)
SQL is the single most-asked skill in Indian data interviews. Every company stores its data in tables, and SQL is how you ask those tables questions. Start here, because everything else builds on it.
What to learn: SELECT, WHERE, ORDER BY; aggregation with GROUP BY and HAVING; JOINs; subqueries and CTEs; and window functions (ROW_NUMBER, RANK, running totals). Then drill the classic interview questions: second highest salary, find duplicates, top-N per group, WHERE vs HAVING, INNER vs LEFT JOIN.
Our free SQL course runs every query live in your browser (no install) — you write and run real SQL in all 36 lessons.
Step 2 — A BI / visualization tool
Once you can query data, you need to show it. Pick one of two industry-standard, free-to-use tools:
- Tableau — Tableau Public is free and runs on Windows and Mac. Great first choice, and you can publish dashboards to a public URL for your résumé.
- Power BI — Power BI Desktop is free but Windows-only. It's the most-requested BI tool in Indian job listings, and its DAX language is a strong interview differentiator.
If you're on a Mac or only have a phone, start with Tableau. On Windows, learn both — they're complementary and together make your résumé stronger.
Step 3 — Excel (don't skip it)
Plenty of "data analyst" jobs in Tier 2/3 India are really advanced-Excel jobs. VLOOKUP/XLOOKUP, pivot tables, and basic charts are quick to learn and show up in interviews and day-one tasks.
Step 4 — Build a portfolio (this is what gets you hired)
Knowledge without proof is invisible to recruiters. As you learn, ship 3-4 public dashboards: one in Tableau Public, one Power BI report, and a SQL analysis you can talk through. Put the links on your résumé and LinkedIn. In interviews, "here's a dashboard I built — let me walk you through it" beats any certificate.
A realistic 8-week plan
- Weeks 1-2: SQL — SELECT to JOINs, plus the interview patterns.
- Weeks 3-4: SQL window functions + your first Tableau or Power BI dashboard.
- Weeks 5-6: Finish the BI tool; publish 2 dashboards.
- Weeks 7-8: Excel essentials, polish your portfolio, drill interview questions.
Do you need a paid course or certificate?
No. A verifiable free certificate plus a public portfolio is enough for entry-level roles. Recruiters care far more about whether you can write a query and read a dashboard than about which platform issued your certificate. Spend your money on nothing; spend your time on building.
Start today
The whole path is free on Techwave Academy: SQL → Tableau → Power BI. Every course is hands-on, Hinglish-friendly, and unlocks on signup with no credit card. Pick SQL and write your first query in the next five minutes.