Data Analyst Resume for Freshers (with Sample)

Never written a resume before? Begin with our guide to writing a resume as a fresher in India for the basic layout, then come back here for the analyst-specific parts.

What a data analyst resume for freshers needs to show

Analyst recruiters look for three kinds of evidence, roughly in this order. Can you query data (SQL)? Can you work in a spreadsheet without fumbling (Excel)? Can you present what you found (a dashboard or a short report)? Everything else is a bonus.

So your degree matters less than you'd think. A BSc Statistics student in Pune, a BCom student in Jaipur and a mechanical engineering student in Hosur can all write a strong analyst resume. What none of them can do is list "SQL" in a skills box and hope the recruiter takes it on trust.

Which tools to list on a data analyst resume

Only list a tool you could use in an interview without notes, and make sure each one turns up in action somewhere else on the page.

Name the features, not only the product. "Excel" on its own tells a recruiter nothing; "Excel: pivot tables, SUMIFS, XLOOKUP" tells them you've moved past typing numbers into cells. Unsure whether your SQL or Excel holds up? Work through our SQL interview questions for freshers before you list it, because the interview will test exactly what you claim.

Drop anything you watched one video on. Put Power BI, Tableau, Looker, R, SAS, Python and Spark on a fresher resume and the recruiter assumes none of them is real.

How to present portfolio projects

Your projects are what get a data analyst fresher resume shortlisted. In two or three lines, each one answers four things: what question you asked, what data you used, what tools you used and what you found.

Compare two versions of the same project.

Weak: "Sales analysis project using Excel and Power BI."

Strong: "Analysed 18 months of sales data from a public retail dataset (about 50,000 rows) in SQL and built a Power BI dashboard; found that three product categories drove most of the decline in repeat orders."

The second names the data, its size, the tools and a finding. A recruiter can ask about any part of it, which is exactly what you want: the interview becomes a conversation about your work.

Use public datasets you can explain: Indian government open data, state election results, railway or weather datasets, or a cleaned sales dataset. Choose one that interests you, since you'll talk about it better. Put the code and a one-page write-up in a public GitHub repository, and link the dashboard. Writing the projects section of a resume goes through the wording line by line.

Don't overlook college work. An attendance tracker you built in Excel for your department, or placement data you analysed for your college's training cell, is a real project with a real user.

Keywords from data analyst job postings

Many companies run resumes through an applicant tracking system (ATS), software that stores applications and lets recruiters search them by keyword. A resume that never uses the words the recruiter searches for simply doesn't come up.

Open ten entry level data analyst postings for the cities you're applying to and note the words that repeat. Fresher analyst postings tend to repeat terms like these:

• SQL, Excel, Power BI, Tableau, Python
• data cleaning, data validation, data visualisation
• dashboards, reporting, MIS reports
• KPIs (key performance indicators, the numbers a business tracks)
• stakeholders (the people who use your reports)
• ad hoc analysis (one-off questions from a manager)

Use the ones that match what you actually did, in your project lines and skills section. Never paste a block of keywords at the bottom in white text; recruiters see it, and that ends the application. When a posting says "MIS reports" and you built a weekly report in Excel for your college fest's finance team, call it that.

Data analyst resume sample for a fresher

The sample below is for a fictional BSc Statistics graduate. Copy the structure, not the content.

SNEHA KULKARNI
Pune, Maharashtra | sneha.kulkarni@example.com | +91 98XXX XXXXX
linkedin.com/in/sneha-kulkarni-example | Portfolio: github.com/sneha-k-example

SUMMARY
BSc Statistics graduate who uses SQL, Excel and Power BI to turn raw data
into clear reports. Built three end to end analysis projects on public
datasets. Looking for an entry level data analyst role.

SKILLS
SQL (PostgreSQL): joins, GROUP BY, CTEs, window functions
Excel: XLOOKUP, SUMIFS, pivot tables, data cleaning, charts
Power BI: data modelling, DAX measures, published dashboards
Python: pandas, matplotlib
Statistics: descriptive statistics, regression, hypothesis testing

PROJECTS
Online grocery orders analysis | SQL, Power BI           [link]
- Wrote SQL queries on a public dataset of grocery order lines
  to find reorder patterns by product department and day of week
- Built a 3-page Power BI dashboard; found that weekend orders had a
  noticeably higher reorder rate for dairy and produce

Placement data cleaning and report | Excel                [link]
- Cleaned 4 years of college placement records (1,200 rows): fixed text
  dates, removed duplicates, standardised company names
- Built a pivot-based report used by the training and placement cell
  to compare branches by offers and median package

Rainfall and crop yield study | Python (pandas)            [link]
- Merged state-level rainfall and crop yield data from open government
  sources; ran a regression for three major crops

EDUCATION
BSc Statistics, Deccan Valley College, Pune       2023 to 2026
CGPA 8.4 / 10
Class XII (State Board), 2023: 88%

ACHIEVEMENTS
Completed a national timed data challenge; certificate of completion
Treasurer, college statistics society: kept the event budget in Excel

Look at how the skills section names features, and how every skill appears again in a project. Each project line starts with a verb and ends with a finding. The placement report has a real user in the training and placement cell. And it all fits on one page, as a fresher resume should.

The numbers in the sample are for illustration only. Use your own, and be sure you can explain where each came from.

Mistakes that get analyst resumes rejected

A skills list with no proof anywhere else tops the list. Close behind come project titles with no description, dashboards with no link, and links that ask for a login, because recruiters won't request access.

Claimed accuracy you can't back up is another. "Built a model with 98% accuracy" on a fresher resume invites a hard question about how you measured it. Keep the line only if you can answer; otherwise describe what you did.

And don't send an identical resume to a data analyst role and a business analyst role. Read each posting, then adjust the summary and the order of your projects.

What to do next

This week, rewrite your two strongest projects with the four-part pattern above, then build the page from one of our CV templates, which are laid out to keep a fresher resume to one page. Practise under timed conditions before you apply. At most companies the aptitude round comes first, and Interview Prep lets you sit it against the clock with a score at the end. Every Compete challenge is free, with one counted attempt, an all-India leaderboard and worked solutions for every question, and finishing one gives you a certificate to list under achievements.

Our CV templates get the resume started, and Interview Prep and Compete get you ready for the rounds after it.