Data Analyst fresher requirements (2026)

These are the published requirements FresherHub scores a Data Analyst against (role version 1). The weights are fixed in the role definition; AI never changes them.

The short answer

FresherHub checks a fresher Data Analyst against 14 requirements in 5 areas. The 4 must-haves: SQL for analysis, Python & pandas for data manipulation, BI tool proficiency (Power BI / Tableau / Looker) and End-to-end case-study project. Analytics carries the most weight, at 30% of the readiness score.

A requirement counts fully only when there is proof you can point to, such as a repository, a deployed project or a notebook. A skill you only list counts for much less.

How the score is weighted

Data Analyst score weights
Area	Share of your score	Requirements
Fundamentals	15%	3 (1 must-have)
Analytics	30%	3 (1 must-have)
Visualization	20%	2 (1 must-have)
Portfolio	20%	3 (1 must-have)
Professional	15%	3

Within an area, each requirement has its own weight. Your readiness is the weighted sum, so the share shown on each requirement below is how much of the overall score it carries. How scoring works explains the formula.

Requirements, area by area

Fundamentals · 15% of your score

SQL for analysis

Must-have

8.3% of the overall score

Writes SQL for real analysis — joins, aggregations, window functions, CTEs — not only SELECT/WHERE.

What counts as proof

Resume lists SQL under skills or experience.
Public repositories contain meaningful SQL (queries, migrations, analysis scripts).

How to close the gap

Solve 10+ SQL problems using window functions, CTEs, and joins

Spreadsheet analysis (Excel)

3.8% of the overall score

Comfortable with pivot tables, lookups, and formulas for ad-hoc analysis — a common fresher DA expectation alongside SQL/BI.

What counts as proof

Resume lists Excel/spreadsheet analysis under skills or experience.

How to close the gap

Build a pivot-table and formula-driven summary on a sample sales dataset

Git & version control

3% of the overall score

Analysis code/notebooks tracked in Git with regular, incremental commits.

What counts as proof

Consistent recent contributions (not a single bulk dump).

How to close the gap

Keep small, descriptive commits on your analysis/portfolio repo

Analytics · 30% of your score

Python & pandas for data manipulation

Must-have

13.5% of the overall score

Uses Python with pandas/numpy to clean, reshape, and analyze tabular data beyond spreadsheet limits.

What counts as proof

Resume claims Python and pandas with analysis context.
Repositories depend on pandas/numpy for data work.

How to close the gap

Publish a pandas-based analysis notebook on a real public dataset

Statistics & probability fundamentals

9% of the overall score

Applies core statistics (distributions, hypothesis testing, confidence intervals) to business questions, not just definitions.

What counts as proof

Resume lists statistics/statistical analysis under skills.
A project applies hypothesis testing, A/B testing, or confidence intervals to a real question.

How to close the gap

Run and write up an A/B test or hypothesis test on a public dataset

Applied SQL analysis depth

7.5% of the overall score

A real project shows advanced SQL (window functions, CTEs, multi-table joins) applied to answer a question, not resume claims alone.

What counts as proof

Project uses window functions, CTEs, or multi-table joins for analysis.

How to close the gap

Publish a SQL-driven analysis (query files + findings) for a public dataset

Visualization · 20% of your score

BI tool proficiency (Power BI / Tableau / Looker)

Must-have

11% of the overall score

Builds dashboards in at least one BI tool — Power BI, Tableau, or Looker all satisfy this.

What counts as proof

Resume lists Power BI, Tableau, or Looker under skills or experience.

How to close the gap

Publish a Power BI or Tableau dashboard on a public dataset and link it

Data visualization & storytelling (Python)

9% of the overall score

Builds clear charts (matplotlib/seaborn/plotly) that support a specific finding, not default plots.

What counts as proof

Resume lists data visualization under skills.
Repositories depend on matplotlib, seaborn, or plotly.

How to close the gap

Add 2-3 annotated charts to your strongest notebook that each answer one question

Portfolio · 20% of your score

End-to-end case-study project

Must-have

8% of the overall score

At least one public project covers a full analysis arc — business question, data prep, analysis, and a recommendation — on a real dataset.

What counts as proof

Project shows question framing, analysis, and a stated recommendation/conclusion.
Case study or dashboard is reachable via a live link (BI publish, hosted notebook, or site).

How to close the gap

Publish one end-to-end case study: question, method, findings, recommendation

Reproducible notebooks

5% of the overall score

Jupyter notebooks run top-to-bottom, with markdown narrative between cells — not an unlabeled code dump.

What counts as proof

Repository contains Jupyter notebooks as the primary analysis artifact.

How to close the gap

Add markdown narrative and restart-and-run-all your primary analysis notebook

GitHub / portfolio project presentation

7% of the overall score

Strongest analysis repo is evaluable quickly: README with the question, approach, and results.

What counts as proof

Primary analysis repo README covers the question, approach, and results.

How to close the gap

Rewrite your strongest analysis repo README for recruiters

Professional · 15% of your score

Resume project positioning (business impact)

6% of the overall score

Project bullets convey the business question and impact/metrics, not only tools used.

What counts as proof

Resume project section names the question, method, and a measurable outcome.

How to close the gap

Rewrite analysis project bullets around business impact, not just tools

LinkedIn role positioning

4.5% of the overall score

Headline/About and featured work signal Data Analyst, not a generic student profile.

What counts as proof

Headline or About names the analytics stack and target role.

How to close the gap

Update LinkedIn headline to Data Analyst + tools (SQL, Power BI/Tableau)

Business communication / stakeholder storytelling

4.5% of the overall score

Explains analysis and recommendations in plain business language — the skill most fresher portfolios skip.

What counts as proof

Case study includes a plain-language summary aimed at a non-technical stakeholder.

How to close the gap

Add a one-paragraph, non-technical summary to your case study

Listing a skill vs proving it

Each requirement is scored by the best piece of evidence for it. A skill named in your resume's skills list is a claim and counts for 25%. Work we can see counts for more: observed 60%, demonstrated 80% and strong 100%. Read Am I job-ready? for a self-check you can do today.

A sensible order to work in

Analytics Fundamentals
SQL, spreadsheets, and version control — the daily tools of a Data Analyst.
Applied Analysis
Python/pandas, statistics, and SQL analysis depth beyond resume claims.
Visualization & Dashboards
A BI tool plus Python charting to turn analysis into a readable story.
Portfolio Case Study
One end-to-end case study, reproducible notebooks, and a README recruiters can skim.
Job Ready
Tailored resume, LinkedIn positioning, and stakeholder-ready communication.

Frequently asked questions

What does a fresher Data Analyst need to know?

Which requirement counts most for a Data Analyst?

Python & pandas for data manipulation, worth 13.5% of the overall readiness score, and it is a must-have. Uses Python with pandas/numpy to clean, reshape, and analyze tabular data beyond spreadsheet limits.

Does listing a skill on my resume count?

Only as a claim. A skill that appears only in your resume's skills list counts for 25% of a requirement. Proof we can see in your work, such as a public repository with tests or a deployed project, counts for 60% to 100%.

How do I check if I am ready for a Data Analyst job?

Run the free FresherHub readiness check: pick Data Analyst, add your resume and connect GitHub. In about 3 minutes you get a readiness score, your top blockers and your next best action, checked against the requirements on this page. It does not guarantee a job; it shows what to fix first.

Is the Data Analyst readiness check free?

Yes. The readiness score, top blockers, top 3 next actions and a public portfolio page are free. Placement Sprint is a ₹299 one-time payment for 30 days of access, with no auto-renewal.

Check your Data Analyst readiness

Pick Data Analyst, add your resume and connect GitHub. You get your readiness score against these requirements, your top blockers and the one thing to do next.

Check my Data Analyst readiness — free See an example report