Data Analyst Resume: Sample, Format and Skills for India (2026)
Data analyst is one of the most applied-for titles on Naukri and LinkedIn, and most of the resumes look identical: a skills line that says SQL, Python, Power BI, Excel, then bullets about "creating dashboards" and "analysing data". This guide shows how to be specific about each tool, how to put a number on analytics work when you did not own the revenue, how a fresher substitutes projects and Kaggle for experience, and what a complete two-year e-commerce analyst resume looks like.
The skills matrix: what SQL, Excel, Power BI and Python should mean on your resume
Every data analyst resume lists the same four tools; what separates candidates is whether the resume shows the level. A recruiter cannot interview you on "SQL"; they can interview you on window functions. Use this matrix to decide what to write, and be accurate about which column you belong in.
| Tool | Basic (say this only if it is all you have) | Working (most 1–3 year analysts) | Strong (what senior analyst JDs ask for) |
|---|---|---|---|
| SQL | SELECT, WHERE, GROUP BY, simple joins | CTEs, window functions (ROW_NUMBER, LAG, running totals), subqueries, date handling, query tuning with EXPLAIN | Designing reporting tables and views, incremental loads, dbt or stored procedures, working across Postgres/MySQL/BigQuery/Snowflake |
| Excel | Formulas, sorting, filtering, basic charts | Pivot tables, XLOOKUP/INDEX-MATCH, Power Query, data validation, conditional formatting, what-if analysis | Power Pivot and DAX in Excel, VBA automation, building models other teams use |
| Power BI / Tableau | Connecting a file, dragging fields onto a chart | Data modelling (star schema, relationships), DAX measures or Tableau calculated fields, row-level security, scheduled refresh, publishing to a workspace | Performance tuning large models, dataflows, deployment pipelines, governance and usage tracking |
| Python | Read a CSV into pandas, plot with matplotlib | Cleaning and joining with pandas, groupby and merge, basic statistics with scipy, automating a report with a script, Jupyter notebooks | Scheduled pipelines, API pulls, regression or forecasting with statsmodels or scikit-learn, packaging reusable code |
Write your skills block in that language: "SQL (CTEs, window functions, query optimisation)" and "Power BI (data modelling, DAX, RLS)" tell a hiring manager exactly where you sit. Our ATS resume guide explains how to structure the block so both a parser and a human can read it.
How to quantify analytics impact when you did not own the number
Sales and marketing people own a revenue figure. Analysts usually do not; someone else took the decision on the basis of your work. Your bullets should still carry numbers: quantify the scope, the speed and the decision, and attribute the outcome carefully.
| Weak bullet | Rewritten bullet | What changed |
|---|---|---|
| Created dashboards in Power BI for the sales team. | Built a Power BI sales dashboard used weekly by 22 regional managers, replacing a manual Excel report that took a shared analyst 6 hours every Monday. | Who used it, how often, what it replaced, time saved |
| Wrote SQL queries for reporting. | Rewrote 14 scheduled reporting queries on BigQuery, cutting daily processing cost by roughly a third and moving the morning report from 9:40 to 8:15. | Count, cost direction, time result |
| Cleaned data. | Built a Python validation script that caught duplicate order IDs and missing pincodes before they reached the warehouse dashboard, reducing weekly data-quality tickets from around 30 to under 5. | Mechanism, what it caught, ticket count before and after |
Useful proxies when you have no revenue figure: hours saved per week, reports automated, dashboard users, records processed, pipelines owned, tickets reduced, decisions influenced, and time from question to answer. Use "contributed to" or "informed" where you were one input among many; hiring managers can smell a borrowed number.
The fresher path: projects, Kaggle and certifications instead of experience
A fresher data analyst resume has no experience section to lean on, so projects carry it. One Coursera certificate plus a Titanic notebook does not survive a screen, because everyone has it. What works is two or three projects on messy, Indian, real-world data with a question, a method and a written finding.
- Pick datasets with a question attached. Government open data (data.gov.in), mutual fund data, restaurant listings scraped for a city, IPL ball-by-ball data, or a business you can get real data from (a relative's shop, a college fest). Start from a question, not a dataset.
- Do the whole pipeline. Pull the data, clean it in SQL or pandas, build one dashboard in Power BI or Tableau Public, and write a one-page findings note. The note is what interviewers read.
- Write the project entry like a work bullet. Title, tools in brackets, dataset size, method, finding: "Analysed 3 years of Hyderabad Metro ridership (Python, SQL, Power BI): built a station-level demand dashboard and found weekend Blue Line ridership grew faster than weekday ridership after the 2024 fare change."
- Add Kaggle only where it shows original thinking. One notebook with a clear write-up and a good rank beats ten forks.
- Use certifications as a supporting line. Google Data Analytics, Microsoft PL-300 and IBM Data Analyst are recognised; list them after projects, with the year.
- Include internships even if unpaid or short. Two months cleaning Excel sheets at a small firm is experience; write what it fed into.
The layout is covered in our fresher resume format. If a placement cell asks for a "biodata", read biodata format for job first; analytics recruiters want a one-page resume, not a personal-details form.
Portfolio links that help (and the ones that hurt)
- GitHub with two or three repositories, each holding the notebook, the SQL, a README with the question and the finding, and a dashboard screenshot. Notebooks with no markdown cells look like homework.
- Tableau Public or a published Power BI report so an interviewer can click through. One well-built dashboard is enough.
- Kaggle if the profile shows original notebooks or a competition result; a profile of forked starter notebooks is better left off.
- LinkedIn with a custom URL and a literal headline: recruiters searching "data analyst Hyderabad SQL Power BI" find you through it. The same logic applies to your Naukri headline.
- A personal site only if it is current and holds the same three projects.
Put the links in the header as readable text, and test every one in an incognito window before you apply.
Sample data analyst resume (Hyderabad, 2 years, e-commerce)
An analyst two years out of a Hyderabad engineering college, at a grocery-delivery company after a six-month internship. The internship is written with the same discipline as the full-time role, and each bullet names the tool, the scale and the decision.
Sneha Bollineni
Summary
Data analyst with 2 years in quick-commerce and retail analytics. Own weekly category and fulfilment reporting for a grocery-delivery platform, working in SQL (BigQuery), Python and Power BI. Known on the team for turning vague stakeholder questions into a defined metric, a query and a one-page answer.
Experience
- Built and maintain the category performance dashboard in Power BI (star-schema model, 30+ DAX measures) used weekly by 22 category managers across 6 cities; it replaced a manual Excel pack that took an analyst most of every Monday.
- Ran a cohort analysis of 1.8 lakh first-time customers in BigQuery and found that buyers who ordered from two or more categories in month one retained at roughly twice the rate; the growth team used the finding to design the cross-category nudge launched in Q3 2025.
- Rewrote 14 scheduled reporting queries to use partitioned tables and incremental loads, cutting daily query cost by about a third and moving the morning KPI mail from 9:40 to 8:15.
- Designed the readout template for 9 checkout experiments (sample size, significance, guardrail metrics); flagged a delivery-fee variant that lifted conversion but breached the cancellation guardrail, and it was rolled back.
- Cleaned and merged 3 years of point-of-sale data (about 4 million rows) from 38 apparel stores using pandas; built the store-level sell-through report the merchandising team now runs monthly.
- Wrote a Python validation script that caught duplicate bill numbers and missing store codes before load, reducing weekly data-quality tickets from around 30 to fewer than 5.
- Produced a two-page analysis of size-curve mismatch by region that led the client to change the size allocation for two product lines in the next season.
Projects
- Scraped and cleaned 3 years of station-level ridership; built a demand dashboard and documented that weekend Blue Line ridership grew faster than weekday ridership after the 2024 fare change.
Skills
SQL: BigQuery, PostgreSQL (CTEs, window functions, partitioning, query tuning) · BI: Power BI (data modelling, DAX, RLS, scheduled refresh), Tableau · Python: pandas, NumPy, matplotlib, scipy · Excel: pivot tables, Power Query, XLOOKUP · Statistics: A/B testing, cohort analysis, hypothesis testing · Other: Git, Jupyter, Google Sheets, Jira
Education
Certifications
Microsoft Certified: Power BI Data Analyst Associate (PL-300), 2025 · Google Data Analytics Professional Certificate, 2023
For a profile with more engineering weight, see the software engineer resume; for analyst roles that come through B-school placements, the MBA resume.
Data analyst keyword table
Recruiters search Naukri and LinkedIn with literal terms, and applicant tracking systems rank on matches against the job description. Each term below that is true of you should appear once in the skills block and once inside a bullet.
| Area | Keywords to include where true |
|---|---|
| SQL and databases | SQL, MySQL, PostgreSQL, SQL Server, BigQuery, Snowflake, Redshift, joins, CTEs, window functions, stored procedures, query optimisation, data modelling, star schema |
| BI and visualisation | Power BI, DAX, Power Query, Tableau, Looker, Looker Studio, dashboards, KPI reporting, data storytelling, row-level security, scheduled refresh |
| Python and R | Python, pandas, NumPy, matplotlib, seaborn, Jupyter, scikit-learn (if used), statsmodels, R, tidyverse (if used) |
| Excel and Sheets | Advanced Excel, pivot tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Power Pivot, VBA, macros, Google Sheets, App Script |
| Statistics and experimentation | A/B testing, hypothesis testing, regression, cohort analysis, funnel analysis, forecasting, statistical significance, sampling |
| Data handling | data cleaning, data validation, ETL, data pipelines, data quality, Airflow (if used), dbt (if used), APIs, web scraping |
| Domain terms | e-commerce, retail, fintech, BFSI, SaaS, supply chain, marketing analytics, product analytics, customer segmentation, churn, LTV, unit economics |
Paste the job description and your draft to check your resume's ATS score free; it lists the missing terms so you can add the ones that are true.
Mistakes that get data analyst resumes rejected
- Tools without evidence. Nine tools in the skills line and no bullet that uses any of them; a reader assumes the list is aspirational.
- Title inflation. Calling a reporting role "Data Scientist" invites a modelling interview you will not enjoy.
- Dashboards with no audience. "Created 15 dashboards" says nothing. Who used them, and what did they replace?
- Machine-learning buzzwords on a fresher analyst resume. Deep learning and NLP on a resume for a Power BI role signal that you did not read the job description.
- Screenshots of charts pasted into the resume. They break parsing. Link to the dashboard instead.
- Ignoring the JD's named BI tool. If the role says Tableau and you only say Power BI, add a line on transferable modelling skills and one Tableau Public project.
- Two-column templates with icons. They parse badly. Use a clean single-column design from our templates.
- A vague objective instead of a headline. The top line should say what you are ("Data Analyst | SQL, Power BI, Python | E-commerce"), not what you seek; see resume headline examples.
For a section-by-section walkthrough, use how to write a resume; when an application asks for a note, the cover letter page has analyst examples.
Frequently asked questions
Do I need Python to get a data analyst job in India?
Not for every role, but it widens your options a lot. Many analyst jobs at consulting firms, banks and retail companies run on SQL, Excel and a BI tool. Product companies and startups increasingly expect pandas for cleaning and a bit of scripting for automation. If you are choosing what to learn next, SQL first, then a BI tool, then Python.
Is a certification enough to get a data analyst job as a fresher?
A certification proves you completed a course; a project proves you can do the work. Recruiters see the same Google, IBM and Coursera certificates on thousands of fresher resumes. Pair each certificate with a project that used those skills on real, messy data, and the certificate becomes supporting evidence instead of the whole story.
Should I call myself a data analyst, business analyst or data scientist?
Use the title that matches the work and the job you are applying for. Data analyst means SQL, dashboards, reporting and ad hoc analysis. Business analyst in India often means requirements and process work with some reporting. Data scientist implies modelling and statistics at a level most analyst roles do not need. Inflating the title gets you interviews you will not pass.
How do I show impact if all I did was build dashboards?
Describe who used the dashboard, what decision it supported and what it replaced. A dashboard that replaced a weekly manual Excel report saved someone hours; a dashboard that surfaced a stock-out problem led to an action. Say how many people used it, how often, and what changed once they had it.
Is it worth listing Excel on a data analyst resume?
Yes, but be specific. Excel is still the most-used analysis tool in Indian companies, and many job descriptions ask for it by name. Write what you can actually do: pivot tables, Power Query, XLOOKUP and INDEX-MATCH, data validation, VBA macros if you have written them. Do not write MS Office.
Related guides & tools
- Free ATS score checker
- Resume format for freshers
- How to make an ATS-friendly resume
- Resume headline examples
- ATS-friendly resume templates
- Software engineer resume sample
- MBA resume sample
- How to write a resume
- Cover letter examples