The short answer
A data analyst fresher resume should show three things quickly: the tools you use (Excel, SQL, and Power BI or Tableau, with Python as a bonus), two or three projects on real datasets, and the insight each project produced. Write bullets that end with what you found or what decision it supports, and link to a dashboard or GitHub repository.
Copy the data analyst resume template
[FIRST NAME LAST NAME] [City, State] | [Phone] | [Email] linkedin.com/in/[yourname] | github.com/[username] | [Portfolio / Tableau Public / Power BI link] SUMMARY [Degree] graduate with hands-on skills in Excel, SQL and [Power BI / Tableau]. Completed [N] analysis projects on [type of data], including [one headline result]. Looking for an entry-level Data Analyst role. SKILLS Analysis: MS Excel (pivot tables, XLOOKUP, charts), SQL (joins, aggregations, window functions) Visualisation: [Power BI / Tableau / Looker Studio] Programming: [Python (pandas, matplotlib) / R], if applicable Concepts: Data cleaning, descriptive statistics, A/B testing basics, dashboard design AI tools: [ChatGPT, Claude or Gemini for query drafting and analysis checks] PROJECTS [Sales Performance Dashboard] | [Power BI, Excel] | [link] - Cleaned and modelled [N] rows of [retail sales] data across [N] tables. - Built an interactive dashboard tracking revenue, top products and regional trends. - Found that [insight, e.g. 3 of 12 categories drove 60% of revenue] and recommended [action]. [Customer Churn Analysis] | [SQL, Python] | [link] - Wrote SQL queries to segment [N] customers by tenure, plan and usage. - Identified [key factor] as the strongest signal of churn and presented findings in a 6-slide summary. EDUCATION [Degree, Specialisation] | [College Name], [City] | [Start year] to [End year] CGPA: [X.X / 10] | Relevant coursework: Statistics, [Business Analytics, Economics, DBMS] EXPERIENCE [Data / MIS / Research Intern], [Organisation] | [Month Year] to [Month Year] - [Report or analysis you produced, how often, and who used it]. - [Time saved, errors reduced or decision supported]. CERTIFICATIONS - [Certificate name], [Issuer], [Year]
Write bullets that end with an insight
An analyst is paid for conclusions. A bullet that stops at 'made a dashboard' leaves out the part employers care about.
| Weak | Strong |
|---|---|
| Made a dashboard in Power BI. | Built a Power BI dashboard on 50,000 rows of sales data showing that weekend orders had 22% higher average value. |
| Analysed data using SQL. | Wrote 20+ SQL queries with joins and window functions to rank products by monthly growth across 3 years of orders. |
| Cleaned data in Excel. | Cleaned a 12,000-row survey file in Excel, removing duplicates and fixing formats, which made 8% more responses usable. |
| Did an internship in MIS. | Automated a weekly MIS report using Excel formulas and pivot tables, reducing preparation time from 3 hours to 30 minutes. |
Figures are illustrations of the pattern. Report only what your own data shows.
Project ideas if you have none yet
- Analyse a public dataset on a topic you know: IPL matches, Zomato restaurants, UPI transactions or government open data from data.gov.in.
- Build one Excel project, one SQL project and one dashboard, so each core tool has proof.
- Use real, messy data. Cleaning it is half the job and gives you something to talk about.
- Write a short README or LinkedIn post for each project with the question, the method and the three main findings.
Formatting rules that keep it ATS-friendly
- One page, one column. No tables, text boxes, icons, skill bars or photos.
- Standard headings: Education, Skills, Projects, Experience, Achievements.
- One common font (Arial, Calibri or similar), 10.5 to 11 pt body text, 0.5 to 0.75 inch margins.
- Dates in one format throughout, for example Jun 2026 to Aug 2026.
- Links written out as plain text (linkedin.com/in/yourname), so they survive parsing and printing.
- Saved as a PDF named Firstname-Lastname-Resume.pdf unless the employer asks for Word.
Keywords recruiters search for
Use these only where they are true for you. They are the terms that appear most often in entry-level analyst job descriptions.
- Excel: pivot tables, VLOOKUP or XLOOKUP, conditional formatting, charts
- SQL: joins, GROUP BY, subqueries, window functions
- Power BI: DAX, data modelling, Power Query. Tableau: calculated fields, dashboards
- Data cleaning, data visualisation, reporting, MIS, stakeholder communication
- Python: pandas, NumPy, matplotlib (helpful, rarely essential for a first role)
Frequently asked questions
Can a B.Com, BBA or BA graduate become a data analyst?
Yes. Entry-level analyst and MIS roles hire from commerce, management, economics, science and engineering. What matters is proof that you can work with Excel and SQL and explain what the data shows.
Is Python required for a data analyst fresher resume?
Not always. Many entry-level roles need strong Excel and SQL plus one visualisation tool. Python helps you stand out and matters more as you move towards data science roles.
Where should I host my data analyst projects?
Put code and SQL on GitHub with a README, publish dashboards on Tableau Public or share a Power BI report link or screenshots, and write a short summary on LinkedIn. Link the best ones from your resume.
What is the difference between a data analyst and a business analyst resume?
A data analyst resume leans on tools and analysis output. A business analyst resume gives more weight to requirements, process understanding and communication. At fresher level they overlap heavily, so adjust the wording to each job description.
