Diwali Offer!Flat 20% OFF
Enroll Now
PrakalpanaLive online tech training
Career⏱️ 12 min readπŸ“… Nov 22

How to Become a Data Analyst in India With No Experience (2026 Guide)

SK
Sneha Kulkarniβ€’Analytics Career Mentor
πŸ“‘ Contents (32 sections)

πŸ“ŒYes, You Can Start With No Experience

Data analyst is one of the most accessible tech roles in India. You do not need a computer science degree or a coding background. Companies hire freshers, commerce and arts graduates, and people switching from sales, operations, finance, support or teaching, because the job is about asking good business questions and answering them with data.

What employers do need is proof. With no work experience, your proof is skills you can demonstrate and projects you can explain. This guide shows how to build both. For the detailed skill order, also read the data analyst roadmap.

πŸ“ŒWho This Path Works For

  • Freshers and final-year students from any stream.
  • BCom, BBA and MBA graduates, whose business understanding is a real advantage.
  • Non IT graduates (BSc, BA, engineering branches outside CS) comfortable with numbers.
  • Career switchers from operations, sales, finance, HR or support, who already understand a business domain.
  • Your background is not a weakness. A BCom graduate who understands margins and receivables, or an operations person who knows why deliveries are late, can ask better questions than someone who only knows tools.

    πŸ“ŒThe Skills to Learn, In Order

    1. Excel

    Cleaning data, XLOOKUP, SUMIFS, pivot tables and simple charts. Our Excel for data analysis guide covers exactly what to learn.

    2. SQL

    The most tested skill in data analyst interviews. Learn SELECT, WHERE, GROUP BY, HAVING, joins, subqueries, CTEs and window functions. Practise daily on real datasets.

    3. Statistics basics

    Averages and medians, spread, distributions, percentages and growth rates, correlation, and the idea behind A/B testing. You need practical understanding, not heavy maths.

    4. A BI tool

    Power BI is most common in Indian companies, Tableau is also widely used. Learn one properly: data modelling, measures and a clean dashboard.

    5. Python basics (after the above)

    pandas for cleaning and analysis gives you an edge and opens a path towards data science later. Start with the Python course or our pandas tutorial.

    6. Business communication

    Presenting a finding in three sentences with one chart is a skill interviewers test directly. Practise it from day one.

    πŸ“ŒA Realistic Self-Study Plan

    This is a self-study plan for someone giving 10 to 15 hours a week. Go faster or slower as your schedule allows.

  • Month 1: Excel fundamentals and SQL basics.
  • Month 2: SQL joins, window functions and daily practice problems.
  • Month 3: Statistics basics and your first project in Excel and SQL.
  • Month 4: Power BI or Tableau, and your second project as a dashboard.
  • Month 5: Python and pandas basics, resume, LinkedIn and portfolio polish.
  • Month 6: Applications, mock interviews and steady SQL practice.
  • Consistency matters more than speed. An hour every day beats a long session once a week.

    πŸ“ŒTwo Portfolio Projects That Work

    Project 1: Sales or business performance analysis

    Take a public retail or e-commerce dataset. Clean it, write SQL queries to answer questions such as which regions and products drive revenue and where returns are high, and summarise three findings with recommendations.

    Project 2: An interactive dashboard

    Build a Power BI or Tableau dashboard on a dataset close to the domain you want to work in: HR attrition, loan defaults for finance, delivery times for logistics, or student performance for edtech. Include KPIs, trends, filters and a short written summary.

    For each project, write a short README: the business question, the data, your steps, the results and what you would do next. Publish the dashboard (Tableau Public or a Power BI screenshot set) and put the SQL and files on GitHub.

    πŸ“ŒResume Tips for Freshers and Switchers

  • Put a Skills section at the top: Excel, SQL, Power BI or Tableau, Python, statistics.
  • List projects as experience, each with one line on the result: "Identified the three categories behind 70 percent of returns."
  • Switchers should reframe past work in data terms: reports you built, metrics you tracked, decisions you supported.
  • Keep it to one page and tailor keywords to each job description.
  • Add links to your GitHub and dashboard portfolio.
  • πŸ“ŒMake LinkedIn Work for You

  • Headline: "Aspiring Data Analyst | SQL, Power BI, Excel, Python".
  • Share each project as a short post with a screenshot and one insight.
  • Connect with analysts and recruiters at companies you want to join, and comment on their posts thoughtfully.
  • Turn on "Open to work" with data analyst and business analyst roles selected.
  • πŸ“ŒWhere to Apply

  • Job portals: LinkedIn, Naukri, Indeed, Instahyre and Foundit.
  • Company career pages of GCCs, product companies and consultancies in Bangalore, Hyderabad, Pune, Chennai, Gurugram and Mumbai.
  • Internships and trainee roles, often the fastest route in for freshers.
  • Adjacent titles: MIS analyst, reporting analyst, business analyst, operations analyst and junior BI developer.
  • Referrals: a referral from someone you have engaged with on LinkedIn dramatically improves response rates.
  • πŸ“ŒWhat the Interview Process Looks Like

  • 1An online test or screening call with SQL and Excel questions.
  • 2A technical round on SQL, statistics and your BI tool.
  • 3A case or project discussion where you walk through your work.
  • 4An HR or manager round about motivation and communication.
  • Prepare with our data analyst interview questions and SQL interview questions.

    πŸ“ŒWhat Salary to Expect

    Freshers typically start around β‚Ή3.5 to 6 LPA, with higher offers at product companies and GCCs, and growth is quick once you have a year or two of experience. Our data analyst salary guide has city and company detail. These are indicative ranges, not guarantees.

    πŸ“ŒTips by Background

    Freshers and final-year students

    Use your college projects, internships and any club or event data you have handled. Apply for trainee and internship roles early, and practise aptitude and SQL tests, because many fresher hiring drives start with an online assessment.

    BCom, BBA and MBA graduates

    Lean into finance, sales and marketing datasets. A dashboard on receivables, budget versus actuals or campaign performance shows you understand the business side as well as the tools. Business analyst and MIS analyst roles are natural first steps.

    Non IT graduates

    Start with Excel, because it builds confidence, then move to SQL. Explain in interviews how your subject trained you to reason with evidence, whether that is lab data in science or surveys in social science.

    Career switchers

    Your domain is your edge. An operations professional analysing delivery delays, or an HR professional analysing attrition, brings context that pure tool learners lack. Look for analyst openings inside your current company first, internal moves are often the easiest.

    πŸ“ŒA Week in the Life of a Junior Analyst

    Knowing what the job looks like helps you prepare for it. A typical week includes refreshing weekly sales or operations reports, answering a few ad hoc questions from managers ("why did returns rise in the South?"), writing SQL to pull data for a new request, cleaning a messy file someone sent over email, updating a Power BI dashboard, and presenting a short summary in a team meeting. Most of the work is careful, repeatable data handling, with a few moments of insight that make the role rewarding.

    πŸ“ŒCommon Mistakes to Avoid

  • Collecting certificates without building projects.
  • Learning five tools shallowly instead of SQL and one BI tool deeply.
  • Applying with a generic resume to hundreds of jobs.
  • Skipping communication practice.
  • Giving up after the first few rejections. Most people need many applications before the first offer.
  • πŸ“ŒFAQ

    Can a BCom or BBA graduate become a data analyst?

    Yes, and many do. Commerce graduates understand business metrics well. Add Excel, SQL and a BI tool, build two projects, and you are a strong candidate.

    Do I need to learn Python to get my first analyst job?

    Not always. Many entry roles ask only for Excel, SQL and Power BI or Tableau. Python helps you stand out and is needed if you later move towards data science, see data analyst vs data scientist.

    Is a certificate necessary?

    A certificate helps with screening, but projects and SQL skill decide interviews. Treat certificates as a supplement, not the goal.

    How many applications does it usually take?

    It varies, but dozens of tailored applications before the first offer is normal for freshers. Track each application, follow up politely, and treat every interview as practice that improves the next one.

    Is age or a career gap a problem?

    Not if you can show current skills. Explain the gap briefly and focus on what you have built recently.

    πŸ“ŒLearn It Live

    If you want structure and feedback, Prakalpana's Data Analytics course is taught live online with an optional 1-on-1 track, two portfolio projects, resume reviews and mock interviews. See the data analytics path, then WhatsApp or call +91 9180377502 for a free demo.

    SK

    Written by

    Sneha Kulkarni

    Analytics Career Mentor

    πŸš€ Master Career

    Join 5000+ developers

    Not sure what to do? Book career counselling (β‚Ή200 / 30 min)

    Not sure what to learn next?

    A 1-on-1 session with an industry mentor and a roadmap built for you. How it works

    1. 1Discuss your goals
    2. 2Get a personal plan
    3. 3Start learning
    Book for β‚Ή200/ 30 min