Top 19
Prep plan
Updated weekly · Last refresh Aug 30

NORC at the University of Chicago Business Analyst Interview Questions

The questions to prepare for a NORC at the University of Chicago Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
Statistics & ProbabilityStart here. 5 questions · ~40 min
Statistical Analysis ProjectMedium

Tests your experience applying statistics to produce defensible insights.

RegressionCausal InferenceStatistical SignificanceNORC at the University of Chicago
Survey Methodologies ExperienceMedium

Tests your understanding of survey design and implementation for credible findings.

ExperimentationHypothesis TestingSample SizeNORC at the University of Chicago
Statistical Methods for SurveysMedium

Tests your knowledge of appropriate methods for survey inference and interpretation.

Confidence IntervalsRegressionHypothesis TestingNORC at the University of Chicago
More Statistics & Probability questions with a free account
2
SQL & Data Manipulation3 questions + 3 drills · ~54 min
Cleaning and Preparing DataMedium

Tests your ability to clean, transform, and prepare data for reliable analysis.

JoinsData WranglingAggregationsNORC at the University of Chicago
Cleaning a Messy DatasetEasy

Tests your hands-on skills for resolving data quality issues.

JoinsData WranglingCase WhenNORC at the University of Chicago
Tools for Data AnalysisEasy

Tests your practical toolkit for analyzing data and supporting evidence-based decisions.

SubqueriesData WranglingCTEsNORC at the University of Chicago
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Unify CRM and Google Analytics ViewHard
Practice
Practice drill

Merge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.

SubqueriesJoinsData WranglingArtefact
Deduplicate Out-of-Order Replication EventsMedium
Practice
Practice drill

Use ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.

Window FunctionsSubqueriesJoinsReplitQuantcast
3
Behavioral & Leadership9 questions · ~72 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~16 min
Survey Project Success MetricsMedium

Tests your ability to define and measure outcomes for survey work.

KPIsLeading IndicatorsDiagnosisNORC at the University of Chicago
Data Work ExperienceEasy

Tests breadth of hands-on data work and how you approach analysis end to end.

Success CriteriaScope ManagementNORC at the University of Chicago

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 19 questions plus 3 hands-on drills to finish this plan.