Data analyst fresher resume format

Entry-level analyst hiring screens for three things in order: SQL, Excel, and evidence you have handled a messy real dataset. Visualisation tools matter, but they are the fourth check, not the first.

The single highest-return item on a fresher analyst resume is one project using a public dataset that you actually cleaned, with the row count, the problems you found and the decision the analysis supported.

Say what the analysis concluded. A project that ends at 'built a dashboard' is a tooling demonstration; one that ends at a finding is analysis.

Section order

Top to bottom. The order matters more than the styling, because it decides what a reader sees in the first few seconds.

HeaderName, phone, email, LinkedIn, GitHub or portfolio with the notebooks.
Technical skillsSQL, Excel, Python or R, a BI tool. In that order.
ProjectsTwo, at least one on a genuinely messy public dataset.
InternshipsAny analytical work, even if the title was not analyst.
CertificationsGoogle Data Analytics, Microsoft PL-300, or equivalent, with the year.
EducationDegree, marks, and any statistics or mathematics coursework worth naming.

What has to be on the page

SQL named explicitly, with the operations you can write: joins, window functions, CTEs, aggregations.
Excel described by capability: pivot tables, VLOOKUP or XLOOKUP, Power Query if you use it.
One project with the row count, the cleaning problems and the conclusion.
A BI tool named: Power BI, Tableau, Looker Studio.
A link to the notebook or dashboard, live wherever possible.

Bullets in the right shape

Bracketed values are placeholders. Substitute your own real figures, and leave a line out entirely rather than inventing a number for it.

Analysed [3 years] of [public transport ridership] data ([1.2 M] rows) in [Python and SQL], cleaning [~40,000] malformed timestamps to identify [two] route pairs carrying [31%] of total delay minutes.

Built a [Power BI] dashboard tracking [7] retail KPIs across [12] stores, replacing a weekly [4-hour] manual Excel consolidation.

Wrote [SQL] queries using [window functions] to calculate rolling [30-day] retention across a [50,000-user] cohort, surfacing a [drop at day 9] that the product team acted on.

Mistakes that cost this profile interviews

Instead ofListing Excel, SQL, Python, Tableau, Power BI, R, SAS, SPSS as though all are working knowledge.

Do thisKeep the four you can be tested on. A live SQL test is a standard part of analyst interviews.

Instead ofProjects on clean, famous teaching datasets like Titanic or Iris.

Do thisUse something messy and preferably Indian: data.gov.in, RBI, census, a Kaggle set nobody has done to death. The cleaning is the demonstrated skill.

Instead ofEnding a project description at 'created visualisations'.

Do thisEnd at the finding and what it implied. Analysis is the conclusion, not the chart.

Free template for this format

Data Analyst — Purpose-built for this profile: a skills matrix that separates languages from BI tools, and a project block with room for a result line. Hand-designed, and the PDF and Word exports are free with no watermark and no card.

Use the Data Analyst template Score a resume you already have

Questions

Can I get a data analyst job as a fresher with no experience?

Yes. The realistic entry route is a demonstrable SQL and Excel standard plus one or two portfolio projects on real datasets. Fresher analyst hiring commonly includes a live SQL test, which is where the shortlist is actually decided.

Is a data analytics certification worth putting on a resume?

As supporting evidence, yes, with the issuer and year. It does not substitute for a project. Recruiters have seen enough certificates without accompanying work to discount them on their own.

SQL or Python first for a fresher analyst?

SQL. Almost every analyst role tests it and many use it daily; Python is common but more often optional at entry level.