Cohort 4Register

Data · Stable

Data Analyst: Skills, Projects & Interview Questions (2026)

Analyze data and build dashboards that answer business questions and drive action.

Demand 8/102026 outlook 7/10Difficulty 4/10High remote

What a Data Analyst actually does

In simple words, a data analyst turns a business question into a number people can act on: why sales dipped last week, which city churns most, whether a new feature changed behaviour.

A typical day mixes SQL queries against the company warehouse, cleaning and checking the result in Excel or Python, and updating dashboards in a tool such as Power BI or Tableau. Before trusting any number, an analyst checks it against a second source, because a wrong figure in a meeting costs more than a late one.

The other half of the job is people: taking vague requests from managers, asking what decision the answer will drive, and explaining the result in two or three plain sentences with one chart. Strong analysts write down their definitions so the same metric means the same thing next month.

Top hiring companies: Amazon, Flipkart, Deloitte, Accenture, Walmart, Swiggy.

Top industries: All industries, Retail, Finance, Tech, Healthcare.

Skills you need to become a Data Analyst

SkillImportance
SQL10/10
Excel9/10
Data Visualization9/10
Power BI / Tableau9/10
Python (Pandas)8/10
Statistics8/10
Data Cleaning8/10
Business Acumen8/10
Dashboarding8/10
Storytelling with Data7/10

Core tools: Excel, Power BI, Tableau, SQL Workbench, Python (Pandas), Google Sheets.

Data Analyst learning roadmap

Beginner · 2-3 months

Foundations & core tooling

Build: Build a SQL + Excel report answering 5 business questions from a raw dataset.

Intermediate · 3-4 months

Applied, real-world builds

Build: Create an interactive Power BI/Tableau dashboard with cleaned data and KPIs.

Advanced · 3-4 months

Production, scale & specialization

Build: Deliver a stakeholder-ready analytics story: cohort/funnel analysis with recommendations.

Get a day-by-day Data Analyst study plan →

10 Data Analyst portfolio projects

SQL Business Report

Beginner

Answer business questions from a raw dataset in SQL.

Skills: SQL, Data Cleaning, Excel

Excel Sales Dashboard

Beginner

Interactive Excel dashboard with PivotTables.

Skills: Excel, Data Visualization

Power BI Sales Dashboard

Beginner

Cleaned data + KPI dashboard in Power BI.

Skills: Power BI, Data Visualization, SQL

Cohort & Funnel Analysis

Intermediate

Analyze retention and conversion with SQL.

Skills: SQL, Statistics, Data Visualization

Tableau Story Dashboard

Intermediate

Stakeholder-ready Tableau storytelling dashboard.

Skills: Tableau, Data Visualization, SQL

Python EDA Report

Intermediate

Exploratory analysis and insights with pandas.

Skills: Python, Data Cleaning, Statistics

KPI Tracking System

Intermediate

Automated KPI report from a live source.

Skills: SQL, Power BI, Data Visualization

Marketing Performance Analysis

Intermediate

Analyze campaign performance and recommend.

Skills: SQL, Excel, Data Visualization

Sales Forecasting (Analyst)

Intermediate

Simple forecast with trend analysis.

Skills: Excel, Statistics, Data Visualization

Customer Behavior Deep-dive

Advanced

End-to-end analysis with segmentation and actions.

Skills: SQL, Statistics, Data Visualization

Common Data Analyst interview questions

Find the second-highest salary in a table.Medium

What they're testing: DENSE_RANK or a correlated subquery / OFFSET

How do you clean messy data in Excel?Medium

What they're testing: Text functions, dedup, validation

How do you visualize for non-technical stakeholders?Medium

What they're testing: Lead with the insight; reduce cognitive load

Difference between deepcopy and shallow copy.Medium

What they're testing: Nested references copied vs shared

Difference between correlation and causation.Easy

What they're testing: Association vs cause; confounders, need experiments

What are window functions? Give a use case.Medium

What they're testing: Compute over a partition without collapsing rows; running totals, ranks

Useful functions for analysts.Medium

What they're testing: SUMIFS, COUNTIFS, IF, TEXT

When is a table better than a chart?Easy

What they're testing: Precise lookups/few values

How does exception handling work? try/except/finally.Easy

What they're testing: Catch specific exceptions; finally always runs

Explain precision and recall and the trade-off.Medium

What they're testing: TP/(TP+FP) vs TP/(TP+FN); threshold tunes balance

Difference between RANK, DENSE_RANK and ROW_NUMBER.Medium

What they're testing: Tie handling: gaps vs no gaps vs always-unique

VLOOKUP vs INDEX-MATCH vs XLOOKUP.Easy

What they're testing: Lookup approaches and their limits

Practice the full Data Analyst question bank →

Certifications for Data Analysts

  • Microsoft Certified: Power BI Data Analyst Associate (PL-300)Microsoft · Very High value
  • Google Data Analytics Professional Certificate (Coursera)Google · High value
  • Tableau Desktop SpecialistTableau (Salesforce) · High value

Data Analyst career path

Data Analyst -> Senior Analyst -> Analytics Manager / Data Scientist

Common moves into this role / from here:

  • → Data Engineer (6-9 months). Skills to add: Python, PySpark/Spark, ETL/ELT, data warehousing, Airflow, cloud platforms
  • → Product Analyst (3-4 months). Skills to add: Product metrics, A/B testing, funnel/cohort analysis, product analytics tools
  • → Data Scientist (6-9 months). Skills to add: Statistics depth, ML algorithms, Python for ML, feature engineering, experimentation
  • → Business Intelligence Developer (3-4 months). Skills to add: Data warehousing, ETL tools, DAX, dimensional modeling, semantic models

Related roles: Product Analyst, Business Analyst, BI Developer

Frequently asked questions

What skills do you need to become a Data Analyst?

Core skills include SQL, Excel, Data Visualization, Power BI / Tableau, Python (Pandas). Turn analysis into a clear recommendation, not just a dashboard.

What projects should a Data Analyst build for a portfolio?

Strong starter projects: SQL Business Report; Excel Sales Dashboard; Power BI Sales Dashboard; Cohort & Funnel Analysis.

How long does it take to become job-ready as a Data Analyst?

A focused plan runs roughly 2-3 months for fundamentals, then applied projects. Difficulty rating: 4/10.

What is the career path for a Data Analyst?

Data Analyst -> Senior Analyst -> Analytics Manager / Data Scientist

Data Analyst interview questions by company

Ready to become a Data Analyst?

PrepNPlaced turns this guide into a plan: a day-by-day roadmap, an ATS-ready resume and interview practice.

Start free →