Data analyst resume template (ATS-friendly)

A data analyst resume with 3 years of experience that shows the business result of every dashboard, report and analysis, not just the tools used. Replace the metrics, datasets and BI stack with your own and keep the same structure.

Use this template

What this template includes

Bullets tie dashboards and analyses to decisions, hours saved and revenue
Skills grouped into analysis, BI and data, and practices for keyword matching
Certifications (PL-300, Google Data Analytics) listed in their own section
A public project that proves the skills before the interview

Sample data analyst resume

Riya Kulkarni

Data Analyst · SQL, Power BI & Python

Summary

Data analyst with 3 years of experience turning sales and operations data into dashboards and insights that leaders act on. Strong in SQL, Power BI and Python, with a track record of automating manual reporting and sizing business opportunities.

Experience

Data Analyst, Kirana Direct (Aug 2023 – Present)

Built 12 Power BI dashboards on sales, returns and delivery SLAs, used weekly by 80+ managers across 9 cities
Automated 6 Excel reports with SQL and Python, saving the finance team 25 hours a month
Identified a 14% repeat-order drop in tier-2 cities through cohort analysis, leading to a loyalty offer worth ₹1.8 Cr in revenue
Designed and analysed 15 A/B tests on checkout, lifting conversion by 6% on 2M monthly sessions

Junior Data Analyst, Saffron Analytics (Jul 2022 – Jul 2023)

Cleaned and merged 5 data sources into one BigQuery model, cutting client report errors by 40%
Presented monthly insight decks to 4 retail clients, 2 of whom renewed contracts worth ₹60 lakh

Skills

Analysis: SQL, Python (pandas, NumPy), Excel (pivot tables, Power Query), statistics, A/B testing
BI & data: Power BI, Tableau, Looker Studio, BigQuery, MySQL, Google Analytics 4
Practices: Data cleaning, cohort analysis, KPI design, data storytelling

Projects

India Air Quality Tracker

Analysed 4 years of AQI data for 30 cities in Python and published a Tableau Public dashboard with 5K+ views

Education

B.Sc., Statistics, Fergusson College, Savitribai Phule Pune University (2019 – 2022)

CGPA 8.6/10

Certifications

Microsoft Certified: Power BI Data Analyst Associate (PL-300), 2024
Google Data Analytics Professional Certificate, 2022

Top skills for data analysts

SQL
Excel (pivot tables, Power Query)
Power BI
Tableau
Python (pandas, NumPy)
Data cleaning
Data visualisation
Statistics
A/B testing
Cohort analysis
KPI dashboards
BigQuery
Google Analytics 4
Data storytelling

Data Analyst resume summary examples

Statistics graduate with internship experience in SQL, Excel and Power BI. Built dashboards and cleaned datasets for 2 college projects and a 3-month analytics internship, and looking for an entry-level data analyst role.

Data analyst with 3 years of experience in e-commerce and retail analytics. Builds Power BI dashboards and SQL pipelines that replace manual reporting, and turns analysis into clear recommendations for business teams.

Operations executive moving into data analytics after 4 years of running MIS reports. Skilled in Excel, SQL and Tableau, with a track record of using data to cut costs and fix process bottlenecks.

Data Analyst resume bullet point examples

Wrote 40+ SQL queries and views that became the single source of truth for monthly sales reporting across 5 regions
Replaced a 2-day manual Excel MIS with a Power BI dashboard refreshed daily, used by 35 regional managers
Analysed 18 months of customer churn data and found 3 drivers that shaped a retention plan, cutting churn by 8%
Built a demand forecast in Python that improved inventory planning accuracy from 72% to 86%
Cleaned and de-duplicated 1.2M CRM records, raising campaign email deliverability by 15%

Frequently asked questions

What skills should a data analyst put on a resume?

SQL and Excel are expected almost everywhere, followed by a BI tool (Power BI or Tableau) and Python or R. Add statistics, A/B testing and data cleaning, and use the exact tool names from the job description.

How do I write a data analyst resume with no experience?

Lead with projects built on public datasets (Kaggle, data.gov.in), internships and certifications such as the Google Data Analytics certificate or PL-300. Describe each project like a job: the question, the tools and what you found.

Should I add a portfolio link?

Yes. A GitHub repo or Tableau Public profile with 2–3 finished analyses lets recruiters check your work. Put the link in the header as plain text so ATS software keeps it.

How do I quantify data analyst work?

Measure what your work changed: hours of manual reporting saved, number of users of a dashboard, revenue or cost tied to a recommendation, or error rates reduced.

More Data & AI resume templates

See all 24 resume templates