Data Analyst Resume Format: Section Order, Skills, and a Full Example

The data analyst resume format that gets shortlisted in India puts a categorized Skills section — SQL, Excel, a BI tool, and one programming language — right after Education, followed by 2-3 projects that show you can clean data, build something visual, and draw a conclusion from it. Recruiters at IT services and GCC analytics teams check SQL and Excel basics plus CGPA; analytics-focused firms and product companies look for case-study thinking, dashboarding, and statistics fundamentals. Fresher data analyst pay in India clusters around ₹3-6 LPA, with roughly ₹4.5 LPA as a commonly cited midpoint for 2026, based on salary trackers such as Guvi's compensation guide. Below is the exact section order, what to put in Skills and Projects, a full worked resume example, and the mistakes specific to data analyst resumes.

What Indian recruiters actually screen a data analyst resume for

Recruiter type	What they check first	Typical test
IT services / GCC analytics teams (TCS, Infosys BPM, Accenture, Genpact)	SQL and Excel basics, CGPA cutoff, domain (stats/commerce/engineering all accepted)	Aptitude round plus a SQL/Excel skills test
Analytics-focused firms (Fractal, Tredence, Mu Sigma, LatentView)	Statistics fundamentals, business-context thinking, tool depth	Case-study round plus a technical screen on SQL/Python
Product/e-commerce companies (Flipkart, Swiggy, Myntra-type roles)	Dashboarding, data storytelling, ability to size a business problem	Take-home case study or a live SQL and metrics round

Pay follows the same split. Fresher data analyst salaries in India run roughly ₹3-6 LPA overall, with ₹4.5 LPA as a frequently cited 2026 midpoint; specialized analytics firms and product companies tend to sit toward the higher end of that band or above it, while pure back-office analytics roles inside IT services sit toward the lower end. These are directional figures from salary-tracking sites, not a guarantee for any specific offer.

The exact section order for a data analyst resume

1. Header — name, phone, email, city, LinkedIn, portfolio link (Tableau Public/GitHub) if you have one
2. Resume headline — role + degree + top tools; see our resume headline guide for freshers for the exact formula
3. Education — degree, college, CGPA, year (stats, economics, commerce, and engineering backgrounds are all common and accepted)
4. Skills — grouped: query/data tools, BI/visualization, programming, statistics
5. Projects — 2-3, each naming the dataset size, tools used, and one concrete finding
6. Internship (if any) — company, duration, a concrete line on what changed because of your work
7. Certifications & Portfolio — relevant certs and published dashboards, not generic ones

Skills section: what to actually list

• Query & data tools: SQL — specifically joins, window functions, and CTEs, not just "SELECT statements" — and Excel with Pivot Tables, VLOOKUP/XLOOKUP, and Power Query, since these are still what most Indian analytics teams run day-to-day work in.
• BI & visualization: Power BI or Tableau — pick one to go deep on rather than listing both at a surface level; mention DAX or calculated fields if you've actually used them.
• Programming: Python with pandas, numpy, and matplotlib, or R if that's what your coursework used — this is what separates a "reporting" analyst resume from an "analysis" one.
• Statistics: hypothesis testing, regression, A/B testing fundamentals — even a course-level understanding, named specifically, reads better than "strong analytical skills."
• Other: Google Sheets, basic Google Analytics, or domain-specific tools (e-commerce funnels, finance ratios) if relevant to the roles you're targeting.

Projects section: real examples, not "did some analysis"

"Analyzed a dataset in Excel" is forgettable. Naming the dataset size, the tools, and the actual finding is not.

Weak version	Rewritten with tools + finding
Made a sales dashboard	Cleaned and modeled a 50,000-row retail transactions dataset in SQL; built a Power BI dashboard tracking revenue, regional performance, and top SKUs using DAX for month-over-month growth
Did a churn analysis project	Analyzed a 7,000-row telecom churn dataset (Python, pandas, scikit-learn) to identify the top 5 factors correlated with churn using logistic regression; visualized findings in seaborn
Learned A/B testing	Simulated an A/B test on 10,000 website sessions, ran a two-proportion z-test at 95% confidence, and presented the rollout recommendation in a one-page summary

Full worked example: a data analyst fresher resume

This is a complete, realistic resume using the format above. Copy the structure, not the specific projects — yours should reflect what you actually built.

Ananya Iyer

Pune, Maharashtra | ananya.iyer@email.com | +91-98xxxxxx45 | linkedin.com/in/ananyaiyer | github.com/ananyaiyer

Data Analyst Fresher | B.Sc Statistics | SQL, Excel, Power BI, Python | Google Data Analytics Certified

Education

• B.Sc, Statistics — ABC College, Pune (University of Pune) | CGPA: 8.1/10 | 2023-2026
• Class XII (Maharashtra Board) — 86% | Class X (Maharashtra Board) — 90%

Skills

• Query & Data: SQL (joins, window functions, CTEs), Excel (Pivot Tables, VLOOKUP/XLOOKUP, Power Query)
• BI & Visualization: Power BI, Tableau (basic)
• Programming: Python (pandas, numpy, matplotlib)
• Statistics: Hypothesis testing, regression, A/B testing fundamentals
• Other: Google Sheets, basic Google Analytics

Projects

• Retail Sales Dashboard (SQL, Power BI) — Cleaned and modeled a 50,000-row retail transactions dataset in SQL; built a Power BI dashboard tracking revenue, regional performance, and top SKUs; used DAX to calculate month-over-month growth. (Dashboard link in portfolio)
• Customer Churn Analysis (Python, pandas, scikit-learn) — Analyzed a public telecom churn dataset (7,000+ rows) to identify the top 5 factors correlated with churn using logistic regression; visualized findings in matplotlib/seaborn; wrote up recommendations in a 2-page summary.
• A/B Test Analysis (Excel, Python, statistics) — Simulated an A/B test on website conversion data (10,000 sessions), ran a two-proportion z-test to check statistical significance at 95% confidence, and presented results in a slide summarizing the recommended rollout decision.

Internship

Data Analyst Intern, [Company Name], Pune — May 2025 to July 2025. Automated a weekly sales report using Excel macros and Power Query, cutting preparation time from 3 hours to 20 minutes; built 2 Power BI dashboards used by the regional sales team.

Certifications & Achievements

Google Data Analytics Professional Certificate (Coursera) | SQL (Advanced) certification, HackerRank | Published 2 dashboards on Tableau Public | College-level statistics quiz, 2nd place, 2024

Certifications and portfolio links that actually matter

• Certifications worth listing: Google Data Analytics Professional Certificate, an advanced SQL certification (HackerRank, Mode, or similar), a Power BI/Tableau specialization — these map directly to what a screening test checks.
• Certifications to skip: generic "MS Excel Basics" or "Computer Fundamentals" certificates next to a stats degree — they read as filler and dilute the specific tools you actually want noticed.
• Portfolio: a Tableau Public profile or a GitHub repo with 2-3 clean, documented projects is worth more than a paragraph describing your "analytical mindset." Recruiters at analytics-focused firms in particular will click through if the link is right there in your header.

Common mistakes specific to data analyst resumes

1. Listing "Excel" with no specifics. Everyone claims Excel. Naming Pivot Tables, XLOOKUP, and Power Query specifically is what separates a real claim from a default one.
2. No dataset size or scale mentioned. "Analyzed sales data" versus "analyzed a 50,000-row retail dataset" — the second is verifiable and specific, the first is not.
3. Dashboards described but not linked. If you built something in Power BI or Tableau, publish it (Tableau Public is free) and link it — a described-but-unseen dashboard asks the recruiter to trust you on faith.
4. Confusing a reporting task with an analysis project. Pulling a weekly report is real work, but frame it by the decision or time saved it enabled, not just the act of pulling it.
5. Overloading Skills with tools you've only watched a tutorial on. If a live SQL round is part of the process — and for analyst roles, it usually is — a skill listed but not actually usable gets caught fast.

What happens after your resume gets shortlisted

Analyst interviews tend to include a live SQL or Excel test, a case-study discussion, and sometimes a take-home dataset to analyze within a day or two — expect to explain your reasoning out loud, not just deliver a final number. If you're preparing for the HR or fit round that usually follows, our guide on answering "tell me about yourself" and general HR interview questions covers what comes after the technical screen. And if you're still deciding between a pure analyst track and a software-adjacent one, it's worth comparing this format against a software engineer resume format before you commit your projects and skills section to one direction.

Frequently Asked Questions

What is the ideal resume format for a data analyst fresher? One page, with Education followed by a categorized Skills section (SQL, Excel, a BI tool, one programming language) and 2-3 projects that each name dataset size, tools, and a concrete finding.

Do I need a stats or CS degree to become a data analyst in India? No. Statistics, economics, commerce, and engineering backgrounds are all common among Indian data analysts — what matters more on the resume is demonstrated SQL/Excel/BI proficiency through projects, not the degree name.

Is SQL more important than Excel for a fresher data analyst resume? Both matter, but SQL is increasingly the harder filter — many screening tests include a live SQL round, while Excel proficiency is often assumed and checked less formally.

Should I learn Python or R for a data analyst role in India? Python is more commonly asked for in Indian job postings and has a larger community and library ecosystem (pandas, numpy); R shows up more in academic and specific analytics-research contexts. Either is acceptable if it's used in an actual project, not just listed.

What's a realistic fresher salary for a data analyst in India? Roughly ₹3-6 LPA, with about ₹4.5 LPA as a commonly cited 2026 midpoint, though this varies significantly by company type, city, and whether the role is analytics-focused or a general back-office function.

Should I include a portfolio link like Tableau Public or GitHub? Yes, if you have 2-3 genuinely clean, documented projects. A live, clickable dashboard is more convincing than a resume bullet describing one.