Data Analytics Question Sheets
Topic-wise Data Analytics question sheets — 414 questions across 12 topics. Open each sheet online and tick questions as you solve them.
Excel Interview Questions
Excel rounds test lookups (XLOOKUP, INDEX-MATCH), PivotTables, SUMIFS, dynamic arrays like FILTER and UNIQUE, data validation, Power Query and the…
Power BI Interview Questions
Power BI questions cover data modelling, star schemas, relationships, DAX measures and filter context, time intelligence, Power Query, refresh,…
Python for Analysis Interview Questions
Python rounds focus on pandas: reading files, filtering with loc, groupby, merge, pivot tables, dates, missing values and vectorised operations, plus…
SQL Interview Questions
SQL is tested in nearly every data analyst interview, often as a live coding round. Expect joins, GROUP BY and HAVING, subqueries and CTEs, window…
Statistics and Case Studies Interview Questions
This topic covers descriptive statistics, distributions, sampling, hypothesis testing, p-values, confidence intervals and A/B tests, along with…
Tableau Interview Questions
Tableau questions test dimensions and measures, discrete and continuous fields, extracts versus live connections, relationships and blending,…
Data Cleaning Interview Questions
Data cleaning questions ask how you handle missing values, duplicates, inconsistent labels, wrong data types, mixed date formats, outliers and broken…
Dashboards and KPIs Interview Questions
This topic covers choosing and defining KPIs, leading and lagging indicators, dashboard types, layout, targets and RAG status, refresh frequency,…
Data Storytelling Interview Questions
Data storytelling questions test how you turn analysis into decisions: choosing the right chart, decluttering, action titles, structuring a…
Data Modelling & Warehousing Interview Questions
This topic covers how analytical data is organised: fact and dimension tables, grain, keys, slowly changing dimensions, ETL and ELT, and warehouse…
A/B Testing & Experiments Interview Questions
This topic covers designing and analysing controlled experiments: hypotheses, primary and guardrail metrics, sample size and power, significance…
Web & Marketing Analytics Interview Questions
This topic covers measuring websites, apps and campaigns: sessions and events in GA4, engagement, UTM tagging, attribution models, marketing metrics…
Frequently asked questions
What are question sheets?
Topic-wise lists of Data Analytics interview questions with answers — 414 questions across 12 topics. Tick questions as you solve them; progress is saved in your browser.
Which sheet should I start with?
Start with Excel, then Power BI. Use the role-wise pages to see which topics matter most for the job you want.