Top 41
Prep plan
Updated weekly · Last refresh Oct 17

University of Michigan Data Analyst Interview Questions

The questions to prepare for a University of Michigan Data Analyst interview. Questions from real interview reports rank first. Updated daily.

41questions
~6htotal time
Track your progressSign up free to work through all 41 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 15 questions · ~124 min
Design Row-Level Security PipelineHard

Design a pipeline that enforces client-specific row-level security for shared dashboards without leaking data across accounts.

InfrastructureData ModelingQualityUniversity of Michigan
Patient Data Quality and PrivacyMedium

Approach for protecting sensitive patient data while maintaining high data quality across an analytics pipeline.

ETLData ModelingQualityUniversity of Michigan
More Pipelines questions with a free account
2
Metrics12 questions · ~100 min
Visualize Metrics to Show TrendsEasy

Choose visuals that make trend direction, comparisons, and KPI drivers easy to understand at a glance.

KPIsLeading IndicatorsDiagnosisUniversity of Michigan
Prioritize KPIs for a DashboardEasy

Choose a focused KPI set for a new dashboard by tying metrics to product value, business goals, and leading versus lagging signals.

KPIsLeading IndicatorsDiagnosisUniversity of Michigan
More Metrics questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
SQL & Data Manipulation8 questions + 2 drills · ~86 min
Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_numberUniversity of Michigan
Cleaning Large Research DatasetsEasy

Tests your data cleaning workflow and your ability to handle scale and messy inputs.

Data WranglingCase WhenAggregationsUniversity of Michigan
Flag Discrepant M-Pathways Report TotalsEasy
Practice
Practice drill

Use GROUP BY and aggregation to find M-Pathways departments whose reported totals differ from actual totals by more than $50.

Data WranglingAggregationsQualityUniversity of Michigan
Optimize a Slow SQL QueryHard
Practice
Practice drill

Rewrite a slow PostgreSQL loan payment query to reduce scanned rows while preserving the required aggregated results.

database optimizationJoinsData WranglingAmeripriseEEltro Cyberchrome PrivateEnergyHub
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership4 questions · ~33 min
More Behavioral & Leadership questions with a free account
5
More topics2 questions · ~17 min
Python or R for AnalyticsMedium

Tests your statistical and programming skills for turning messy data into reliable insights.

ExperimentationRegressionHypothesis TestingUniversity of Michigan
SAS Versus R for StatisticsEasy

Tests your statistical programming depth and your ability to choose tools appropriately.

ExperimentationRegressionHypothesis TestingUniversity of Michigan
The finish line: interview-readyComplete all 41 questions plus 2 hands-on drills to finish this plan.