A data analyst resume is read by someone who looks at numbers all day, so it gets judged the way a dashboard does: is it clear, is it accurate, and does it answer the question quickly? For a fresher, that question is simple: can this person take a messy dataset, clean it, query it and explain what it means? This guide shows you how to answer it on one page. If you want the general fresher layout first, read our fresher resume format with sample; everything below is specific to analyst roles.
The section order that works for fresher analysts
Recruiters hiring for data analyst internships and entry-level roles want proof of skill before anything else. Since you do not yet have years of work history, lead with what you can do and what you have built.
- Header – name, city, [your email], phone, and links to your GitHub and a portfolio or public dashboard page.
- Summary – two or three lines naming your tools and the kind of analysis you enjoy. Our fresher resume summary examples help if you are stuck.
- Skills – grouped by category (see the table below).
- Projects – two to four, each with three or four bullets. This is the heart of the resume.
- Internships or work experience – even a non-analyst internship counts if you touched data.
- Education – degree, college, year, and CGPA if it helps you.
- Certifications – only the ones you can talk about in an interview.
If you already have a relevant internship, swap sections 4 and 5. Everything else stays the same.
The skills block: what to list and how to group it
A long comma-separated list of tools tells the reader nothing. Group your skills so a reviewer can see your depth in a few seconds, and only include what you have actually used in a project.
| Category | What to list (if true) | How to show depth |
|---|---|---|
| Spreadsheets | Excel or Google Sheets: XLOOKUP/VLOOKUP, pivot tables, conditional formatting, data validation | Name one project where pivots or lookups did the heavy lifting |
| SQL | MySQL or PostgreSQL: joins, GROUP BY, subqueries, CTEs, window functions | Mention the size of the data as a placeholder you fill in honestly |
| BI tools | Power BI (DAX basics, Power Query) or Tableau (calculated fields, dashboards) | Link a published dashboard |
| Python basics | pandas, NumPy, Matplotlib or Seaborn, Jupyter | Link a notebook on GitHub |
| Statistics | Descriptive stats, distributions, correlation, hypothesis testing basics, A/B test logic | Show it inside a project bullet, not as a standalone claim |
If a skill is weak, build it before you list it. Our free Excel lessons, SQL course and Python course cover what most fresher analyst roles expect. You can also check where you stand with the skills assessment.
Writing project bullets: method, tool, outcome
Most fresher analyst resumes fail at the project section because the bullets describe the topic rather than the work. "Did a project on sales data" says nothing. A strong bullet follows a simple pattern: what you did (method) + what you used (tool) + what it produced (outcome).
Never invent numbers. If you do not know the exact figure, go back to your notebook and count it. The samples below use square-bracket placeholders like [X] so you can fill in your own real values.
Sample bullets you can adapt
- Cleaned a public retail dataset of [X] rows in Python (pandas), handling missing values and duplicate order IDs, which cut the usable-row loss from [A]% to [B]%.
- Wrote SQL queries with joins across [N] tables and window functions to rank products by monthly revenue per region.
- Built a Power BI dashboard with [N] pages tracking sales, returns and customer repeat rate; used Power Query to merge monthly files automatically.
- Used Excel pivot tables and XLOOKUP to reconcile [X] records from two survey exports and flagged [Y] mismatches for review.
- Ran a basic A/B comparison on [X] sessions of a sample website dataset and explained why the difference was or was not meaningful.
- Presented findings to [audience, e.g. faculty panel or internship manager] and recommended [one concrete action].
Notice that every bullet starts with a verb, names the tool, and ends with a result or a decision. If your project did not lead to a decision, say what question it answered.
Choosing projects that recruiters actually read
Pick projects that look like the job. A company hiring through SQL internships wants to see queries; a team hiring via Power BI internships or a Tableau internship for freshers wants a dashboard it can click. Good fresher projects usually:
- Use a realistic business dataset (sales, HR attrition, e-commerce orders, loan applications, public government data).
- Start from a business question, not a tool ("Which cities have the highest return rate and why?").
- Include at least one messy step, such as cleaning, merging or fixing data types.
- End with a short written insight, not only a chart.
Avoid putting the same two tutorial datasets everyone uses at the top of your resume. If you must use a well-known dataset, ask a question the tutorials do not ask.
Tailoring the resume to the role
"Data analyst" covers several jobs. Read the listing and shift the emphasis accordingly:
| Role variant | Lead with | Useful links |
|---|---|---|
| SQL-heavy analyst | Query projects, joins, window functions | SQL intern roles |
| BI / reporting analyst | Dashboards, DAX, data modelling | Power BI intern roles, BI analyst intern roles |
| Business analyst | Requirement notes, process maps, Excel models | business analyst internships for freshers |
| Excel / MIS analyst | Pivots, lookups, automated reports | Excel internships |
If you are aiming at business analysis more than pure data work, the business analyst resume template may suit you better.
Common mistakes on fresher analyst resumes
- Skill ratings with stars or bars. "SQL 4/5" means nothing and ATS software cannot read graphics.
- Listing every tool you have heard of. If you list R, SAS, Spark and Snowflake, expect questions on all four.
- Made-up impact numbers. "Improved sales by 30%" on a college project is a red flag, not a strength.
- No links. A dashboard or notebook the reviewer can open is worth more than any adjective.
- Two-column designs with icons. They often break in ATS parsing. See our ATS-friendly resume template guide.
- Coursework as projects. A lab assignment is fine, but say what you did beyond the brief.
Build it, check it, then apply
Start from the data analyst resume template or build from scratch in the resume builder. Before you apply, run the file through the resume ATS checker to catch parsing problems. Then prepare for the questions your resume will trigger: practise with our SQL interview questions and Python interview questions, and read our companion guide to data analyst interview questions for freshers.
When you are ready, browse the data analyst internships for freshers, explore data analyst intern roles by city, or look at city pages such as data analyst internships in Pune and Hyderabad.
Frequently asked questions
Should a fresher data analyst resume be one page?
Yes. One page is enough for almost every fresher. Use the space for two to four strong projects with links rather than long descriptions of coursework.
Can I put a data analytics certificate on my resume?
You can, as long as you can explain what you learned and ideally show a project that used it. A certificate without a matching project adds little, so put the project first.
What if my projects do not have impressive numbers?
Use real, honest numbers such as dataset size, number of tables joined or number of dashboard pages. Where there was no measurable result, describe the question you answered and the decision it would support.
Do I need Python for a fresher data analyst role?
Many entry-level roles care most about Excel, SQL and one BI tool. Basic Python with pandas is a useful extra, but list it only if you have used it in at least one project you can walk through.
Related career guides
- Internships for first-year students
- Part-time jobs for college students
- "Why should we hire you?" for freshers
- Group discussion tips for freshers
Ready to apply? Browse all internships and fresher jobs, or read more career guides.