The Data Analyst Resume Guide (with Examples)

A data analyst role in Bengaluru or Gurugram can attract 300+ applicants. A recruiter spends roughly six seconds on the first scan, and an ATS (Applicant Tracking System) has already parsed and ranked your resume before that. Most capable Indian candidates get rejected not for lack of skills but for a resume that hides them. This guide fixes that, with examples you can copy.

The two readers you must satisfy

1. The ATS — software that scans for keywords (SQL, Power BI, Python) and clean structure. If it can't parse your resume, a human never sees it.
2. The human recruiter — skims for tools, impact and relevance in seconds.

Design for both: keyword-rich content in a simple, parseable layout.

Structure: the section order that works

For freshers and analysts with under 5 years' experience:

1. Header — name, phone, email, LinkedIn, GitHub/portfolio link.
2. Professional summary — 2-3 lines, tailored to the role.
3. Technical skills — tools-first, the most important section.
4. Projects — especially critical for freshers.
5. Work experience — quantified bullets.
6. Education & certifications (e.g., PL-300).

Keep it to one page (two only if you have 5+ years).

Skills section: lead with tools

Recruiters and ATS both scan here first. Group logically and use the exact terms from the job description:

Languages & Querying : SQL, Python (pandas, NumPy)
BI & Visualization   : Power BI (DAX, Power Query), Tableau, Excel (PivotTables, XLOOKUP)
Databases            : MySQL, PostgreSQL
Other                : Statistics, Data Cleaning, ETL, Git

Avoid vague soft-skill clutter ("hardworking, team player") at the top — that's resume real estate wasted.

Bullet points: quantify everything

The single biggest upgrade you can make is turning duties into quantified achievements. Use the formula: action verb + what you did + tool + measurable result.

Before vs. after

Weak (duty-based):

Responsible for making reports in Power BI for the sales team.

Strong (impact-based):

Built 4 automated Power BI dashboards tracking ₹2 Cr monthly sales across 18 kirana outlets, cutting manual reporting time by 70%.

Weak:

Worked on SQL queries for data.

Strong:

Wrote optimized SQL queries on a 5M-row UPI transactions table to surface top-merchant trends, reducing query runtime from 40s to 6s.

Weak:

Did data cleaning in Excel.

Strong:

Cleaned and standardized 50K+ customer records in Excel/Power Query, improving data accuracy from 82% to 99%.

No real numbers yet? Estimate honestly: rows processed, % time saved, number of dashboards, stakeholders served.

Projects: your proof as a fresher

If you lack work experience, projects carry your resume. For each, write 2-3 lines:

UPI Spending Analysis (SQL + Power BI) — Analyzed 100K simulated UPI transactions; built a dashboard revealing peak spend hours and top merchant categories; identified a 22% weekend surge in food-delivery payments.
GitHub: github.com/yourname/upi-analysis

Strong India-relevant project ideas: kirana sales analysis, cab-demand forecasting, UPI transaction trends, e-commerce returns analysis. Always link the code/dashboard.

ATS-friendly formatting rules

• Use a simple single-column layout. Two-column "designer" templates often break ATS parsing.
• No tables, text boxes, images, or icons for critical content — many ATS skip them.
• Standard section headings: "Work Experience," "Skills," "Education."
• Save and submit as PDF (unless the portal specifically asks for .docx).
• Use a standard font (Calibri, Arial, Helvetica), 10-12pt.
• Mirror keywords from the job description — if it says "Power BI," don't only write "BI tools."

A copy-ready template skeleton

RAHUL SHARMA
Bengaluru | +91-9XXXXXXXXX | [email protected]
linkedin.com/in/rahulsharma | github.com/rahulsharma

SUMMARY
Data analyst with strong SQL and Power BI skills and 3 portfolio
projects on Indian datasets. Seeking an analyst role to drive
data-backed decisions.

TECHNICAL SKILLS
SQL | Python (pandas) | Power BI (DAX) | Excel | MySQL | Statistics

PROJECTS
- Kirana Sales Dashboard (Power BI) — ...quantified result...
- UPI Trends Analysis (SQL) — ...quantified result...

EXPERIENCE
Junior Analyst, ABC Pvt Ltd, Pune (2024-2026)
- Quantified bullet...
- Quantified bullet...

EDUCATION & CERTIFICATIONS
B.Com, XYZ University (2024) | Microsoft PL-300 (2026)

Final checks before you apply

• Does every experience bullet have a number?
• Is the skills section tool-first and keyword-matched to the JD?
• Are your GitHub/portfolio links live and clickable?
• One page, single column, PDF, no typos?
• Did you tailor the summary and keywords to this job, not a generic version?

A tailored, quantified, ATS-clean resume routinely turns a 2% callback rate into 15%+. Your skills are real — make sure the resume proves it before anyone meets you.

Related: Power BI Portfolio Projects That Get You Hired · Build your skill score

Don't just read. Prove your skill on DevWithData.