Skip to content

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.

38 questions

Excel Interview Questions

Excel rounds test lookups (XLOOKUP, INDEX-MATCH), PivotTables, SUMIFS, dynamic arrays like FILTER and UNIQUE, data validation, Power Query and the…

15 Easy20 Medium3 Hard
40 questions

Power BI Interview Questions

Power BI questions cover data modelling, star schemas, relationships, DAX measures and filter context, time intelligence, Power Query, refresh,…

5 Easy26 Medium9 Hard
38 questions

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…

13 Easy21 Medium4 Hard
51 questions

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…

12 Easy32 Medium7 Hard
37 questions

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…

9 Easy20 Medium8 Hard
32 questions

Tableau Interview Questions

Tableau questions test dimensions and measures, discrete and continuous fields, extracts versus live connections, relationships and blending,…

10 Easy16 Medium6 Hard
33 questions

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…

8 Easy18 Medium7 Hard
35 questions

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,…

9 Easy18 Medium8 Hard
26 questions

Data Storytelling Interview Questions

Data storytelling questions test how you turn analysis into decisions: choosing the right chart, decluttering, action titles, structuring a…

9 Easy11 Medium6 Hard
28 questions

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…

8 Easy11 Medium9 Hard
28 questions

A/B Testing & Experiments Interview Questions

This topic covers designing and analysing controlled experiments: hypotheses, primary and guardrail metrics, sample size and power, significance…

9 Easy9 Medium10 Hard
28 questions

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…

8 Easy12 Medium8 Hard

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.