KaabilGet the app

Resume example

Data analyst resume for freshers

A data analyst resume for freshers is a one-page resume that proves you can query, clean and present data. Lead with SQL, Excel and Power BI or Tableau, then show two analysis projects with the question you answered and what you found. Add your degree, any internship and one or two relevant certificates.

  • Updated
  • One-page sample
  • Copy any section

Kaabil AI builds and scores your resume, and its Career Agent emails recruiters for jobs you approve. 7 days free, no card.Start free trial

Sample data analyst resume for freshers

Sneha Kulkarni is a fictional fresher. Copy the whole resume or one section, then replace every detail with your own.

Sample · one page

Sneha Kulkarni

Data Analyst (Fresher) | SQL, Excel, Power BI, Python

Pune, Maharashtra | +91 98xxx xxxxx | sneha.kulkarni@example.com | linkedin.com/in/your-name | github.com/your-name

Career objective

Statistics graduate skilled in SQL, Excel and Power BI, with a three-month analytics internship and two projects on public data. Looking for an entry-level data analyst role where I can turn sales and operations data into clear weekly reports and dashboards.

Education

B.Sc Statistics, Savitribai Phule Pune University2022 – 2025 | CGPA 8.4/10

Class 12 (HSC, Science), Maharashtra State Board2022 | 84.2%

Class 10 (SSC), Maharashtra State Board2020 | 90.6%

Skills

Analysis:
SQL (joins, CTEs, window functions), Excel (pivot tables, XLOOKUP, Power Query), descriptive statistics, hypothesis testing
Visualisation:
Power BI (DAX basics), Tableau Public
Programming:
Python (pandas, matplotlib)
Soft skills:
Presenting findings to non-technical teams, attention to detail
Languages:
English, Hindi, Marathi

Internship

Data Analytics Intern, Retail chain with 14 stores, PuneJan 2025 – Mar 2025

  • Merged weekly sales files from 14 stores into one MySQL table and wrote the SQL that refreshes it.
  • Built a Power BI dashboard of sales by store and category, used by the regional manager in Monday reviews.
  • Found 300+ duplicate product codes while cleaning the data and wrote a naming rule the team adopted.

Projects

Rainfall and Crop Yield Analysis, Maharashtra, Python, pandas, Power BICapstone project, 2025

  • Combined ten years of district-wise rainfall data from data.gov.in with crop yield data for 36 districts.
  • Built a dashboard comparing rainfall deviation with yield, and presented three findings to the department.

Food Delivery Orders Analysis, SQL, ExcelPersonal project, 2024

  • Wrote 20 SQL queries on a public Kaggle dataset of 1 lakh orders to find peak hours, top cuisines and repeat customers.
  • Summarised five findings in a one-page note with charts; code and queries on GitHub.

Certifications

  • Google Data Analytics Professional Certificate, Google (Coursera), 2025
  • SQL (Intermediate), HackerRank, 2024

Achievements and activities

  • Treasurer, Statistics Association (2024–25): tracked the association’s annual budget in Excel and shared monthly reports.
  • Second place, inter-college data visualisation contest, 2024.

Why this data analyst resume works

  1. Headline and contact

    The headline names the role and the four tools data analyst posts ask for most, so a recruiter knows the fit in one line. The GitHub link matters here: it lets a recruiter open your SQL and dashboards. See resume headline for more formats.

  2. Career objective

    Two lines: degree, tools, proof (an internship and two projects) and the role she wants. It names the kind of work, weekly reports and dashboards, instead of "a challenging position". More in career objective for resume.

  3. Education

    A statistics degree is a strong signal for analytics, so it sits high. Marks are written exactly as the marksheets show them, latest first.

  4. Skills

    Skills are grouped as analysis, visualisation and programming, with the specific features in brackets (joins, pivot tables, DAX). That reads as real use, not a list of logos. No stars or percentages. See skills in resume.

  5. Internship

    Each bullet covers one step of an analyst’s work: getting the data, building the dashboard, cleaning. Every number is something she counted herself. See internship in resume.

  6. Projects

    For a fresher analyst, projects are the work experience. Each one names the data source, the tools and the finding, on data a recruiter recognises. See project in resume.

  7. Certifications and activities

    Two certificates that match the job, with issuer and year, are enough. The treasurer role quietly proves Excel and responsibility. See certifications in resume.

Skills to list on a data analyst resume

Core tools

  • SQL (MySQL or PostgreSQL)
  • Excel
  • Power BI
  • Tableau
  • Google Sheets

Programming

  • Python
  • pandas
  • NumPy
  • matplotlib or seaborn
  • Jupyter

Concepts

  • Data cleaning
  • Descriptive statistics
  • KPI reporting
  • Cohort and funnel analysis
  • A/B test basics

Soft skills

  • Explaining data simply
  • Asking the business question
  • Attention to detail
  • Documentation

ATS tips for a data analyst resume

  • Write tool names the way job posts do: "Power BI", "SQL", "Excel". Use the same spelling everywhere on the page.
  • Mention your main tools twice: once in Skills and once in the internship or project where you used them.
  • Keep the layout in one column with standard headings (Education, Skills, Projects, Internship). Leave charts, skill bars and icons for your portfolio, not the resume.
  • Save it as a text-based PDF (made in Word or Google Docs, not a scanned image) named like "Sneha-Kulkarni-Data-Analyst.pdf".
  • Paste links as plain text, such as github.com/your-name, so they still read if the file is converted.

How do you make a data analyst resume with no experience?

Make projects your experience. Pick two or three datasets a recruiter can relate to (sales, delivery orders, rainfall, cricket) from data.gov.in or Kaggle, write the business question for each, and show the SQL, the dashboard and the finding.

Then add the tools to your skills section, any internship (even a short or virtual one), and certificates that match the job. A commerce, economics or arts graduate can use exactly the same layout: lead with the projects so your skills make the first impression.

Kaabil App

Build your resume in the Kaabil App.

Kaabil AI builds your resume, scores it with the Kaabil Score and shows you what to improve before recruiters see it.

What the Kaabil Score checks
Start free trialGet it on Google PlayDownload on the App Store

7 days free · No card

Questions freshers ask

A two-line objective naming SQL, Excel and a BI tool, your education with marks, a grouped skills section, two or three analysis projects with the question and finding, any internship, and relevant certificates. Keep it to one page with a GitHub or dashboard link.

Most fresher data analyst posts ask for SQL, Excel and a BI tool such as Power BI or Tableau, and many also ask for Python. Show each one in a project or internship bullet, not only in the skills list.

Yes. A GitHub repository with your queries, or a public Power BI or Tableau dashboard, lets a recruiter see your work in a minute. Keep each project tidy, with a short readme.

Yes. Statistics, commerce, economics and arts graduates move into analyst roles with SQL, Excel and a BI tool plus projects. Put the projects high on the resume so the skills, not the degree, make the first impression.