Interview & exam prep
Get the Excel, Power BI or Fabric job
389 interview and certification questions, each with the answer and the reason behind it. Free to read, free to practise as timed tests.
Microsoft certification practice 84 questions
Practice questions for the Microsoft data exams — with the answer and the reason behind it.
PL-300 practice questions
Power BI Data Analyst
12 questions →
DP-600 practice questions
Fabric Analytics Engineer
12 questions →
DP-700 practice questions
Fabric Data Engineer
12 questions →
MO-201 Excel Expert practice questions
Microsoft Excel Expert
12 questions →
MO-200 Excel Associate practice questions
Microsoft Excel Associate
12 questions →
PL-900 practice questions
Power Platform Fundamentals
12 questions →
DP-900 practice questions
Azure Data Fundamentals
12 questions →
Technical interview questions 185 questions
The questions hiring managers ask Excel, Power BI and Fabric candidates, from basics to advanced.
DAX interview questions
Measures, context, time intelligence.
32 questions →
Excel interview questions
Formulas, dynamic arrays, lookups.
29 questions →
Power BI interview questions
Workspaces, refresh, security, sharing.
17 questions →
Power Query interview questions
ETL, folding, the M language.
18 questions →
Data modeling interview questions
Star schemas, relationships, granularity.
13 questions →
Microsoft Fabric interview questions
OneLake, Direct Lake, Lakehouse.
15 questions →
SQL interview questions for data analysts
Joins, aggregation, window functions.
13 questions →
Python interview questions for data analysts
Python in Excel, pandas and notebooks.
22 questions →
VBA interview questions
Automating Excel with the object model.
13 questions →
Data visualization interview questions
Chart choice and report design.
13 questions →
Analyst interview questions 120 questions
Stakeholders, statistics, metrics and storytelling — the non-tool half of a data analyst interview.
Behavioral interview questions for data analysts
STAR, teamwork, feedback.
12 questions →
Stakeholder & client-work interview questions
Requirements, stakeholders and delivery.
24 questions →
Statistics interview questions for data analysts
Averages, spread, correlation.
12 questions →
Business metrics & KPI interview questions
KPIs, margin, churn, LTV.
12 questions →
Problem-solving interview questions for analysts
Decomposition, root cause, estimation.
12 questions →
Data storytelling interview questions
Narrative, audience, takeaways.
12 questions →
Data system design interview questions
Pipelines, warehouse vs lake, scaling.
12 questions →
Agile interview questions for data teams
Scrum, Kanban, delivery.
12 questions →
Data ethics & privacy interview questions
PII, GDPR, responsible data.
12 questions →