HireToolX
Build your resume

Resume exampleFresher

Data Analyst Fresher Resume Example & Format

Freshers enter data analytics in India through roles such as junior data analyst, analyst trainee, MIS executive, reporting analyst, business analyst trainee and operations analyst, at analytics services firms, KPOs, global capability centres, e-commerce and fintech startups, and the analytics teams of banks and retailers. Many people come from B.Sc, B.Com, BCA, B.Tech and economics backgrounds, and a degree in a specific subject matters less than demonstrated skills.

Recruiters screening fresher analyst resumes look for SQL, Excel and one BI tool such as Power BI or Tableau, with Python as a plus. Because many applicants list the same tools and certificates, the deciding factors are usually projects with a clear business question, a portfolio or GitHub link with clean work, and any internship where you worked with real data. Expect an SQL or Excel test and a short case discussion in most hiring processes.

The sample below is for a recent B.Sc Mathematics graduate breaking into analytics through a short internship, three portfolio projects and two recognised certificates.

Build this resumeCheck your ATS score

Sample Data Analyst Fresher resume

Fictional candidate. Names, employers, colleges and figures are illustrative; replace every line with your own work.

Rahul Example

Data Analyst (Fresher) · SQL, Excel, Power BI, Python · B.Sc Mathematics 2026

  • Hyderabad, Telangana
  • rahul.example@example.com
  • +91 9XXXX XXXXX
  • linkedin.com/in/rahul-example
  • github.com/rahul-example
  • rahul-example-portfolio.example.com

Summary

B.Sc Mathematics graduate with a data analyst internship and three portfolio projects analysing sales, funnel and public data. Strong in SQL (joins, CTEs, window functions), Excel and Power BI, with Python (pandas) for cleaning and analysis. Looking for a junior data analyst or analyst trainee role.

Experience

Data Analyst Intern

Jan 2026 – Apr 2026

Northwind Analytics Pvt. Ltd. · Hyderabad (hybrid)

  • Wrote SQL queries on a client's order and returns tables to build a weekly returns report, which highlighted two product categories driving most return costs.
  • Built a Power BI dashboard with drill-downs by region and category for the client's operations team, reviewed and published by the senior analyst.
  • Cleaned and standardised 80,000 customer records in Python (pandas), removing duplicates and fixing inconsistent city and pin code values.

Maths & Statistics Tutor (part-time)

Jul 2024 – Dec 2025

Self-employed · Hyderabad

  • Taught statistics and probability to Class XI–XII students, and tracked each student's test scores in a Google Sheets progress dashboard shared with parents.

Projects

E-commerce Funnel Analysis

SQL (PostgreSQL), Power BI

  • Analysed a public sample e-commerce dataset to measure drop-off from product view to purchase by device and traffic source.
  • Found that mobile checkout had the largest drop-off and summarised three recommendations in a one-page write-up linked from GitHub.

Retail Sales and Inventory Dashboard

Excel (Power Query), Power BI

  • Built a monthly sales, margin and stock-cover dashboard on a public retail dataset, with DAX measures for year-on-year growth.

City Air Quality Trends

Python (pandas, Matplotlib)

  • Cleaned five years of public government air quality data for four cities and compared seasonal pollution patterns, published as a notebook.

Skills

  • Analysis: SQL (joins, CTEs, window functions), Python (pandas, NumPy, Matplotlib), Excel (pivot tables, XLOOKUP, Power Query)
  • BI & visualisation: Power BI (DAX basics, data modelling), Tableau Public, Looker Studio
  • Statistics: Descriptive statistics, Hypothesis testing, Correlation and regression, A/B testing basics
  • Databases & tools: MySQL, PostgreSQL, Git, GitHub, Jupyter

Education

B.Sc, Mathematics (Statistics and Computer Science)

2023 – 2026

Example Degree College · Hyderabad · CGPA 8.3 / 10

Class XII (State Board, MPC)

2023

Sample Junior College · Hyderabad · 91%

Certifications

  • Google Data Analytics Professional Certificate
  • Microsoft Certified: Power BI Data Analyst Associate (PL-300)
  • HackerRank SQL (Intermediate) skill certificate

Achievements

  • Top 5, college data visualisation challenge, 2025
Build this resumeCheck your ATS score

What makes this resume work

  • Projects start with a business question and end with a finding or recommendation, not just "performed EDA".
  • The internship shows work on real client data, SQL reports, a dashboard and data cleaning, which most fresher resumes lack.
  • SQL skills are described at a level of detail that prepares the reader for the SQL test, such as CTEs and window functions.
  • Certificates are recognised and tied to the tools listed, but projects and the internship carry the resume.
  • Portfolio, GitHub and LinkedIn links let reviewers check the work quickly.
  • Tutoring is reframed briefly around data tracking and statistics, so a non-analyst job still adds relevant signal.

Data Analyst Fresher resume keywords for ATS

Recruiters and applicant tracking systems search for these terms. Use the ones that genuinely match your experience, in your bullets as well as your skills section, and mirror the wording of each job description.

  • Data Analyst Fresher
  • Junior Data Analyst
  • Analyst Trainee
  • SQL
  • MySQL
  • PostgreSQL
  • Excel
  • Pivot Tables
  • Power Query
  • Power BI
  • DAX
  • Tableau
  • Python
  • pandas
  • Data Cleaning
  • Data Visualisation
  • Dashboards
  • Exploratory Data Analysis
  • Statistics
  • Hypothesis Testing
  • A/B Testing
  • KPI Reporting
  • MIS Reporting
  • Business Insights

Data Analyst Fresher resume mistakes to avoid

  • Listing five certificates and no projects. Certificates help you pass filters, but projects show you can analyse data.
  • Using the Titanic, Iris or the same superstore dashboard without a new question or insight of your own.
  • Writing "Python, R, SAS, Tableau, Power BI, Qlik" when you have only used one or two in real work.
  • Describing projects by tools only. Say what question you asked, what you found and what you would recommend.
  • Leaving out GitHub or portfolio links, which most analytics recruiters expect from freshers.

Frequently asked questions

How can a fresher get a data analyst job without experience?

Build strong SQL and Excel skills, learn one BI tool, and complete two or three projects using public data with a clear business question and a written conclusion. Publish them on GitHub or a portfolio. Look for analytics internships, MIS or reporting roles, and analyst trainee programmes. On the resume, put projects and any internship high up, because they are your experience.

What should a data analyst fresher write in the career objective?

Replace the objective with a two- or three-line summary: your degree and year, the role you want, your main tools and your strongest proof. For example: a B.Sc Mathematics graduate with a data analyst internship and three SQL and Power BI projects, looking for a junior data analyst role. Mention a domain if you have one, such as retail or finance.

Are certifications enough to get a data analyst job?

Usually not on their own. Recognised certificates like the Google Data Analytics certificate or Microsoft PL-300 can help you clear resume filters and show commitment, but interviewers test SQL, Excel and case thinking directly. Use certificates as support and spend more effort on projects, practice problems and a clean portfolio that shows how you approach real questions.

Is CGPA needed on a data analyst fresher resume?

Yes, include it with your degree and year, plus Class XII marks if you graduated recently. Analytics services firms and campus drives often screen on academic cut-offs. Beyond that, your SQL test performance and projects matter far more. If your CGPA is average, keep it and make sure your projects and skills section are strong.

Should a data analyst fresher resume be 1 page or 2?

One page. Education, an internship if you have one, two or three strong projects, skills and certifications fit easily. Link GitHub and a portfolio for more detail instead of adding pages. Recruiters spend little time on each fresher resume, so a focused single page with clear business outcomes reads better than two pages of tool lists.

Which projects should a data analyst fresher include?

Pick two or three projects that show different skills: an SQL analysis that answers a business question, a dashboard in Power BI or Tableau, and a Python cleaning or exploration notebook. Use public datasets from areas like retail, e-commerce, finance or public services. For each, state the question, the method and one clear finding, and link the work.

Make your Data Analyst Fresher resume

Start from a clean ATS-friendly template, fill in your own experience, then check it against the job description.

Build this resumeCheck your ATS score

All resume examples