Dataford
Top 2
Prep plan
Updated weekly · Last refresh Sep 25

NORC at the University of Chicago Data Analyst Interview Questions

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

2questions
~1htotal time
Track your progressSign up free to work through all 2 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 1 question + 3 drills · ~38 min
NORC and Data CleaningMedium

Assesses your understanding of NORC and your approach to reliable data cleaning.

data cleaningProject ManagementNORC at the University of Chicago
SQL for Running AverageMedium
Practice
Practice drill

Calculate five-day rolling service averages using daily aggregation, a calendar join, and PostgreSQL window functions.

queriessqlExlEXL ServicevvConstruct
Handling Missing DataEasy
Practice
Practice drill

Replace missing sales fields with defined defaults and return a consistently ordered dataset.

missing valuesdata cleaningnull handlingUniversity of MinnesotaThe Home DepotNationwide
Handling Missing DataMedium
Practice
Practice drill

Standardize missing observation fields with fallback values, missingness flags, and ordered output.

Window Functionsmissing valuesdata cleaningEversource EnergyCincinnati Children's HospitalAdtalem Global Education
2
Behavioral & Leadership1 question · ~8 min
GIS Tools ExperienceMedium

Evaluates your ability to work with geospatial data and tools relevant to NORC research.

experienceNORC 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 2 questions plus 3 hands-on drills to finish this plan.