Data Analyst Interview Prep

A complete, self-paced guide for freshers to crack the Data Analyst role — covering SQL, Excel, Python, Statistics, and Data Visualization, with hands-on practice and mock interview rounds.

SQL Excel Python Statistics Power BI / Tableau
▶ Start Learning View All Sessions

What This Book Covers

Every skill a Data Analyst fresher is expected to know — structured as bite-sized sessions with explanations, code examples, practice problems, and solutions.

🗄️
Module A

SQL

Queries, joins, subqueries, CTEs, aggregations, and window functions — with 50+ practice problems.

📗
Module B

Excel

Pivot tables, VLOOKUP/XLOOKUP, INDEX-MATCH, charts, and conditional formatting for real reporting.

🐍
Module C

Python

NumPy, Pandas, Matplotlib & Seaborn — from data cleaning to full exploratory data analysis.

📐
Module D

Statistics

Descriptive statistics, probability, correlation, and regression — explained in plain English.

📊
Module E

Visualization

Build interactive dashboards in Power BI or Tableau and defend your design decisions.

💼
Modules F–J

Business & Interviews

Business problem solving, Group Discussion prep, HR rounds, and mock assessments.

10 Master Modules

Aligned to the standard Data Analyst job description and selection process.

ModuleTopicPriority
ASQL⭐⭐⭐
BMicrosoft Excel⭐⭐⭐
CPython for Data Analysis⭐⭐⭐
DStatistics & Probability⭐⭐
EData Visualization (Power BI / Tableau)⭐⭐
FData Cleaning, Preparation & Database Concepts⭐⭐
GBusiness & Analytical Problem Solving⭐⭐
HGood-to-Have Topics⭐
IGroup Discussion (GD) Preparation⭐
JHR Interview Preparation⭐

36 Sessions · 8 Weeks

One session ≈ 1.5–2 hours of study + practice. Work through them in order.

#SessionPhase
S01Plan Overview, Role Understanding & Tool SetupFoundations & SQL
S02SQL Basics — SELECT, WHERE, ORDER BY, OperatorsFoundations & SQL
S03SQL Functions — String, Date, Numeric, CASEFoundations & SQL
S04SQL Aggregations — GROUP BY, HAVINGFoundations & SQL
S05SQL Joins — All Types, Multi-TableFoundations & SQL
S06SQL Subqueries & CTEsFoundations & SQL
S07SQL Window Functions — Ranking & AnalyticFoundations & SQL
S08SQL Practice Marathon — 30 Mixed ProblemsFoundations & SQL
S09SQL Mini-Assignment — Banking Dataset QueriesFoundations & SQL
S10Excel Fundamentals, Referencing & Data CleaningExcel
S11Excel Lookups — VLOOKUP, XLOOKUP, INDEX-MATCHExcel
S12Excel Conditional & Logical Functions, COUNTIF FamilyExcel
S13Excel Pivot Tables & Calculated FieldsExcel
S14Excel Charts, Conditional Formatting & What-If AnalysisExcel
S15Excel Assignment — End-to-End ReportExcel
S16Python Basics — Types, Loops, FunctionsPython
S17NumPy EssentialsPython
S18Pandas — Series, DataFrame, Reading DataPython
S19Pandas — Filtering & Cleaning Missing/Duplicate DataPython
S20Pandas — groupby, Merge, PivotPython
S21Matplotlib & Seaborn VisualizationPython
S22EDA Workflow End-to-End (Project 1)Python
S23EDA Project 2 — Banking/Customer DatasetPython
S24Python Practice Marathon — Coding ProblemsPython
S25Descriptive Statistics & OutliersStatistics & Viz
S26Probability Fundamentals & DistributionsStatistics & Viz
S27Correlation & Regression BasicsStatistics & Viz
S28Power BI / Tableau — Import, Modeling, DAXStatistics & Viz
S29Dashboard Building — 1 Complete DashboardStatistics & Viz
S30Statistics + Viz Mock TestStatistics & Viz
S31Business Problem-Solving & Banking ScenariosBusiness & Mock
S32Resume, Projects & Certifications FinalizationBusiness & Mock
S33Mock Technical AssessmentBusiness & Mock
S34Mock Technical InterviewBusiness & Mock
S35Group Discussion Preparation + Mock GDBusiness & Mock
S36HR Interview Prep + Industry Awareness + Mock HRBusiness & Mock

How to Use This Book

1️⃣

Follow the Order

Start at S01 and work through sessions sequentially. Each one builds on the previous.

2️⃣

Practice Everything

Every session has practice problems. Don't just read — type the queries and run the code.

3️⃣

Build Projects

Complete the 2–3 portfolio projects. They are what interviewers remember.