Data Analyst Resume for Freshers in India: Format, Skills and Sample

Data analyst is one of the most popular entry-level career paths in India, and recruiters see a lot of similar resumes: the same course certificates, the same Titanic or Iris dataset projects and a long list of tools. To stand out as a fresher, you need a resume that shows you can handle real data, ask a useful question and communicate an answer. This guide explains how to build one.

What recruiters look for in a fresher data analyst

• Core tools: SQL, Excel and at least one visualisation tool (Power BI or Tableau). Python is a strong addition.
• Analytical thinking: can you define a problem, clean data, find patterns and explain what they mean?
• Projects: two or three end-to-end projects with clear business questions.
• Communication: can you present insights to people who are not technical?
• Basics of statistics: averages, distributions, correlation and hypothesis testing.

Because you do not yet have much work experience, your projects section carries a lot of weight.

The right resume structure

1. Header: name, phone, professional email, city, LinkedIn and GitHub or portfolio link.
2. Summary or objective: two or three lines that name the role and your strongest tools.
3. Skills: grouped by category.
4. Projects: the most important section for freshers.
5. Internship or experience: if any.
6. Education: degree, college, year and CGPA.
7. Certifications: only relevant ones such as SQL, Power BI or data analytics programmes.

Keep it to one page, in a clean single-column layout that ATS can read.

Skills to include

Group your skills so recruiters can scan them quickly. Only include tools you can discuss in an interview.

• Query and databases: SQL (joins, subqueries, window functions), MySQL, PostgreSQL
• Spreadsheets: Excel (pivot tables, VLOOKUP/XLOOKUP, Power Query)
• Visualisation: Power BI, Tableau, Looker Studio
• Programming: Python (pandas, NumPy, Matplotlib)
• Statistics: descriptive statistics, correlation, A/B testing basics
• Soft skills: data storytelling, stakeholder communication, attention to detail

How to write strong project descriptions

A fresher analyst's project should answer: What was the question? What data did you use? What did you do? What did you find?

Use this pattern:

Retail Sales Analysis | SQL, Python, Power BI Analysed 120,000 order records to find out why repeat purchases were falling. Cleaned missing values in pandas, wrote SQL queries to segment customers and built a Power BI dashboard with 8 KPIs. Found that customers who received delayed deliveries were far less likely to order again and recommended faster shipping for top customers.

Good project ideas for freshers:

• sales or retail dashboard using real or realistic data,
• customer churn analysis,
• analysis of an open government dataset (for example, public data on education, transport or health),
• an Excel automation that saves time on a recurring report,
• a SQL project solving business questions on a sample database.

Avoid projects that only follow a tutorial exactly. Add your own question or your own dataset and explain what you changed.

Example bullet points

• Cleaned and merged three CSV files (about 50,000 rows) in Python, removing duplicates and standardising date formats.
• Built an interactive Power BI dashboard with filters for region and product category used by a mock management team.
• Wrote 25+ SQL queries using joins and window functions to answer business questions on a sample sales database.
• Automated a weekly Excel report with Power Query, reducing manual work from 2 hours to 15 minutes.
• Presented findings to classmates and mentors, simplifying results into three clear recommendations.

Only use numbers that are real. If your numbers are approximate, say so in an interview.

Sample fresher data analyst resume (text version)

Sneha Iyer Bengaluru | +91 98XXX XXXXX | sneha.iyer@email.com | linkedin.com/in/sneha-iyer | github.com/sneha-iyer

Summary Statistics graduate with hands-on experience in SQL, Excel and Power BI. Built three analytics projects from raw data to dashboard. Seeking a data analyst role to turn data into clear business decisions.

Skills SQL (MySQL, PostgreSQL) | Excel (Pivot, Power Query) | Power BI | Python (pandas, NumPy, Matplotlib) | Statistics | Data storytelling

Projects Retail Sales Analysis | SQL, Python, Power BI: analysed 120,000 orders to identify drivers of repeat purchases; built a dashboard with 8 KPIs and recommended delivery improvements. Customer Churn Study | Python, pandas: cleaned 7,000 records and compared churn across segments; presented three retention ideas.

Internship Data Analyst Intern | Company Name | Jun to Aug 2026: prepared weekly Excel reports and created two Power BI visuals that the team used in reviews.

Education B.Sc Statistics | University Name | 2023 to 2026 | CGPA 8.2

Certifications SQL for Data Analysis (Platform, 2026) | Power BI Fundamentals (Platform, 2026)

Tips to pass ATS screening

• Use clear headings: Skills, Projects, Experience, Education.
• Spell tools the way job posts do: 'Microsoft Excel', 'Power BI', 'SQL'.
• Do not rely on graphics such as skill bars.
• Add keywords from the job description where they honestly apply.
• Save as PDF with selectable text.

Scan your resume with the ATS Resume Checker and compare it with a specific posting using Resume vs Job Description. For a deeper look at the role, read our data analyst resume guide.

Mistakes freshers make

• A long list of tools but no proof. Tie each tool to a project.
• Too many courses and certificates. Quality beats quantity.
• Unclear project outcomes. Always state the finding or decision.
• Dashboards with no business question. A chart is not an insight.
• Copying the same projects as everyone else. Use unique data or a unique angle.

Prepare for interviews too

Be ready to explain every project: where the data came from, how you cleaned it, why you chose a chart and what you would do next. Practise SQL queries and Excel formulas and rehearse a short story about each project. The Interview Question Generator can create role-specific questions from your resume.

Key takeaway

A strong fresher data analyst resume leads with projects, shows a practical toolkit and explains impact in plain language. Build yours in the Resume Builder, run an ATS scan and tailor it for each job.

Frequently asked questions

Do I need Python to become a data analyst?

Not always. SQL, Excel and a visualisation tool cover many entry-level roles. Python helps for automation and deeper analysis, so it is a strong addition if you have time to learn it well.

Are certificates enough without projects?

Certificates show that you studied; projects show that you can apply it. Recruiters usually trust two solid projects more than ten certificates.

What if I do not have an internship?

Build projects with realistic datasets, publish them on GitHub or as dashboards, and describe the business question and result in your resume. Volunteer analysis for a club or a small business can also count as experience.