Data analytics roles are among the fastest-growing in India right now. Companies need people who can take raw data and turn it into decisions. The entry bar is lower than software engineering — you don't need to code for years. But you do need the right tools and the ability to think structurally about problems. This guide is for MBA, BBA, BCA, and B.Com graduates who want to break in.
Excel — You must be proficient. Not just SUM and VLOOKUP. PivotTables, dynamic arrays, dashboards. SQL — The most underrated skill for analytics. Start with SELECT, WHERE, GROUP BY, and JOINs. Power BI or Tableau — Pick one. Power BI is more common in India. ChatGPT / AI Tools — Analysts who use AI do 3x more in half the time. Python — Optional for entry-level, but valuable if you want to grow into a senior role.
You don't need a job to have a portfolio. Pick 3 public datasets (Kaggle, data.gov.in, company annual reports). Build one Excel dashboard, one Power BI report, and one SQL query set. Upload to GitHub or Google Drive. Share the links on LinkedIn. A portfolio shows you can do the work — which is what hiring managers actually care about.
LinkedIn is the best channel for analyst roles in India. Search: "Business Analyst", "Data Analyst", "MIS Analyst", "Reporting Analyst". Naukri works for traditional companies. Look for roles at mid-size companies (200–1000 employees) — they give more responsibility than large MNCs. Freshers: target BPOs, analytics firms, and consulting companies. They hire in volume and train well.
Excel round: VLOOKUP/INDEX-MATCH, PivotTables, IF/IFS/SUMIF. Case round: "How would you measure X?" — practice structured thinking. SQL round (for some companies): basic queries, aggregations, JOINs. Communication: Can you explain a chart to a non-technical manager? Practice every one of these. Not just reading about them — actually doing them.
Week 1: Master Excel PivotTables and VLOOKUP. Week 2: Learn SQL basics (free: SQLZoo, Mode Analytics). Week 3: Build your first Power BI dashboard on a public dataset. Week 4: Update LinkedIn, apply to 10 jobs, reach out to 5 people at target companies. The key is consistent execution, not perfection. An imperfect portfolio you finish beats a perfect one you never start.
Skip the 80-hour YouTube rabbit hole. Join a 3-hour live workshop and walk away job-ready on Day 1.
Seats are limited. Join Batch 1 and walk into your first job ready to contribute from Day 1.
Browse Workshops →