How to Get a Data Analyst Job as a Fresher in India

Nov 03, 2026

To get a data analyst job as a fresher in India, learn four tools well (Excel, SQL, Power BI and basic Python), build three or four portfolio projects using real public datasets, and apply for internships and entry level analyst roles at the same time. Most freshers do not get stuck because of their degree. They get stuck because they cannot show that they can take messy data and answer a business question.

This guide walks through the skills recruiters actually ask for, realistic salary figures, how to build a data analyst portfolio and how to handle a data analyst interview. If you prefer structured, mentor-led practice over self-study, a practical data analysis course can shorten the learning curve, but the roadmap below works either way.

What Does an Entry Level Data Analyst Actually Do?

An entry level data analyst collects data from spreadsheets or databases, cleans it, finds patterns and presents the results so a manager can make a decision. The work is less about complex maths and more about asking the right question.

A typical week might look like this: pulling last month's sales from a SQL database, fixing duplicate customer entries in Excel, building a Power BI dashboard for the regional sales head and writing a short note explaining why returns went up in one city. In Surat, for example, a textile trader or a diamond exporter may want to know which product lines move fastest and which buyers pay late. That is data analysis in its everyday form.

Data Analyst Skills for Freshers: What Recruiters Look For

Job descriptions vary, but the same core tools appear again and again. Naukri's own career advice section lists SQL, spreadsheets such as Excel, and visualisation tools such as Power BI and Tableau as the base technical skills, along with communication and business sense.

SkillWhat you should be able to doPriority for freshers
ExcelVLOOKUP/XLOOKUP, pivot tables, conditional formatting, basic charts, data cleaningMust have
SQLSELECT, WHERE, GROUP BY, JOINs, subqueries, window functionsMust have
Power BI or TableauImport data, build relationships, write simple DAX measures, design a clean dashboardMust have
PythonPandas for cleaning and grouping, Matplotlib or Seaborn for chartsStrong advantage
StatisticsMean, median, standard deviation, correlation, basic hypothesis testingImportant
CommunicationExplain a chart in plain language to a non-technical managerMust have

Start with Excel and SQL

Excel and SQL cover a large share of day-to-day fresher work. If you are completely new to computers and spreadsheets, a foundation like the CCC computer course builds basic comfort before you move on to formulas and databases. For SQL, practise on free sample databases and aim to write a five-table JOIN query without looking up syntax.

Add Power BI and Python

Microsoft's study guide for the PL-300 Power BI Data Analyst exam splits the syllabus into four areas: preparing data, modelling data, visualising and analysing data, and managing Power BI, with the first three each weighted 25 to 30 percent (Microsoft Learn, April 2026). Even if you do not take the exam, that list is a good checklist for what to learn.

Python is not mandatory for every fresher role, but it helps you clean large files and automate repetitive reports. A focused Python programming course that covers Pandas is enough to begin with. Those who later want to move into machine learning can look at an AI/ML and data science course.

Data Analyst Fresher Salary in India

Fresher pay varies widely with the city, company type and your skill level. Here is what current salary platforms report:

  • Indeed India: The average data analyst salary is about ₹6.28 lakh per year, with a typical range of roughly ₹3.1 lakh to ₹12.7 lakh across all experience levels. The same page lists an average of about ₹5.15 lakh for entry level data analyst roles (Indeed, updated October 2026).
  • AmbitionBox (company example): At eClerx, a large analytics and process services employer, fresher data analysts report ₹1.8 lakh to ₹5 lakh per year, based on 119 salaries (AmbitionBox, June 2025).

The honest takeaway: first offers vary widely. Company-level data such as the ₹1.8 lakh to ₹5 lakh range reported by eClerx freshers sits well below Indeed's entry-level average, with higher offers going to candidates in metro cities, product companies or those with strong SQL and portfolio work. Bengaluru, Noida, Gurgaon and Hyderabad top Indeed's city list for average data analyst pay. Salary growth after the first two years depends far more on your skills than on your first offer.

How to Build a Data Analyst Portfolio That Gets Interviews

For a fresher with no work experience, the portfolio is the experience. Recruiters want proof that you can take a raw dataset, clean it and tell a clear story. Three to four solid projects beat ten copied tutorials.

  • Sales dashboard: Use a retail or e-commerce dataset and build a Power BI dashboard showing monthly revenue, top products and regional performance.
  • SQL case study: Answer ten business questions on a public database and share the queries on GitHub with short explanations.
  • Python cleaning project: Take a messy government dataset from data.gov.in, clean it with Pandas and write up three findings.
  • Domain project: Pick an industry you understand, such as marketing campaign performance or GST invoice data for a small business.

Domain knowledge gives you an edge. Commerce graduates who understand ledgers and invoices, perhaps through an accounting and taxation course, can build finance-focused projects that stand out. Similarly, anyone with a digital marketing course background can analyse ad spend and conversion data, which many agencies need.

Host your work on GitHub, publish dashboards using Power BI's publish-to-web or Tableau Public, and add a one-line summary of each project to your resume and LinkedIn profile.

Data Analyst Intern Roles: The Fastest Way In

A data analyst intern position is often easier to land than a full-time role, and many companies convert good interns into employees. Search on Internshala, LinkedIn, Naukri and Indeed with terms like "data analyst intern", "MIS intern" and "business analyst intern". MIS executive and reporting analyst roles also build the same skills and are common in Gujarat's manufacturing and trading companies.

Do not ignore small firms and startups. They give you exposure to more of the data pipeline, from collecting data to presenting it, which strengthens your story in later interviews.

Applying for a Data Analyst Job in India: A Practical Plan

  • Tailor your resume: Mirror the tools named in each job description and put your projects above your hobbies.
  • Optimise LinkedIn: Use a headline such as "Aspiring Data Analyst | SQL, Power BI, Excel" and share short posts about your projects.
  • Apply daily, in batches: Ten targeted applications a day is more effective than a hundred random ones.
  • Ask for referrals: Message alumni or seniors working as analysts with a specific, polite request.

How to Prepare for a Data Analyst Interview

Most fresher data analyst interview processes include an aptitude or online test, a SQL or Excel technical round, a case or project discussion and an HR round. Expect questions such as:

  • Write a query to find the second highest salary in a table.
  • What is the difference between INNER JOIN and LEFT JOIN?
  • How would you handle missing values in a dataset?
  • Walk me through one of your projects. What business decision could it support?

The project walkthrough is where many freshers lose marks. Practise explaining the problem, your approach, the result and what you would improve, all in under three minutes. Interviewers are judging your thinking, not just your syntax. A grounding in business basics, like the kind covered in a business administration and commerce course, makes it easier to link numbers to decisions.

Frequently Asked Questions

Can a non-IT graduate get a data analyst job as a fresher?

Yes. Commerce, BBA, science and even arts graduates move into data analysis regularly. Employers care more about your Excel, SQL and dashboard skills and your portfolio than about the name of your degree.

How long does it take to become job-ready as a data analyst?

With consistent daily practice, many learners become ready for internships in four to six months. The timeline depends on your starting point and how many hands-on projects you complete.

Is Python compulsory for an entry level data analyst?

Not always. Many fresher roles ask mainly for Excel, SQL and Power BI. Python becomes important as you handle larger datasets or move towards data science, so it is worth learning early.

What is the starting salary of a data analyst fresher in India?

Salary platforms show a wide spread. Indeed reports an entry level average of about ₹5.15 lakh per year, while AmbitionBox data for individual companies shows fresher ranges starting near ₹1.8 lakh. City, company and skills make the difference.

Do I need a certification to get hired?

A certification such as Microsoft's PL-300 can strengthen your resume, but it does not replace a portfolio. Recruiters usually ask to see what you have built.

Are there data analyst jobs for freshers in Surat and Gujarat?

Yes. Textile, diamond, chemical, e-commerce and IT service companies in Surat and Ahmedabad hire for analyst and MIS roles. Remote and hybrid roles from other cities are also open to Gujarat-based candidates.

Your Next Step Towards a Data Analyst Career

Landing a data analyst job as a fresher comes down to three things you control: solid skills in Excel, SQL and Power BI, a portfolio that solves real business questions, and steady, targeted applications. Pick one dataset this week and build your first project. At RW Skill Education, learners follow this same project-first approach with mentor feedback and career guidance, but whichever path you choose, consistent practice is what gets you hired.