🏥Healthcare Analytics Path

The hospital just failed its quality review.
The board meets Wednesday.

Query a hospital operations database with planted EHR data quality issues, build CMS-ready reports, and learn to think like a healthcare data analyst who never ships a wrong metric.

See All Missions

25 missions · runs entirely in your browser · no account needed

How It Works

1

Read the briefing

A Slack message from your manager

2

Explore the schema

5 tables in a star schema

3

Write your query

Full SQL editor with autocomplete

4

Get expert feedback

Graduated hints, not just pass/fail

Why This Path

Real Hospital Scenarios

Answer questions from the CMO, VP of Operations, and CEO about readmissions, wait times, and patient outcomes.

EHR Data Quality Issues

Duplicate patients, inconsistent department names, mixed date formats, and bad values that silently break your analysis.

Healthcare-Specific Skills

Readmission rates, length of stay, ED throughput, utilization, CMS methodology, and age bucketing from DOB.

Portfolio-Ready Skills

Every mission maps to a real healthcare analyst task — quality scorecards, CMS dashboards, and provider performance reports you’ll see on the job.

The Missions

Each mission is a real request from someone at the company. Difficulty increases as you go.

Starter5 missions
1
Meet the patientsFrom: Chief Quality Officer
How many departments do we have?From: Chief Quality Officer
Total encounter volumeFrom: VP of Operations
Encounters by departmentFrom: Chief Quality Officer
Insurance mixFrom: Chief Quality Officer
Easy5 missions
Who’s currently admitted?From: VP of Operations
Top 10 diagnosesFrom: Chief Medical Officer
ED wait time overviewFrom: Director of Patient Experience
Departments with no encountersFrom: Director of Patient Experience
Provider roster with red flagsFrom: Chief Medical Officer
Medium5 missions
Average length of stay by departmentFrom: VP of Operations
ED throughput — the real numbersFrom: Director of Patient Experience
Readmission rate by insurance typeFrom: Chief Quality Officer
Duplicate patient auditFrom: Chief Quality Officer
Patient age at admissionFrom: Chief Medical Officer
Hard5 missions
Rank specialties by encounter volumeFrom: Chief Medical Officer
ED wait times by day of weekFrom: VP of Operations
Month-over-month encounter trendFrom: Chief Quality Officer
Department utilization ratesFrom: VP of Operations
Provider complication ratesFrom: Chief Medical Officer
Expert5 missions
Readmission cohort deep diveFrom: Chief Quality Officer
Patient satisfaction trend with moving averageFrom: Director of Patient Experience
Top diagnoses year-over-yearFrom: Chief Medical Officer
Department scorecardFrom: CEO
The CMS Quality DashboardFrom: CEO

The Database

A hospital operations star schema with 5 tables, 5,300+ rows, and 12 planted data quality issues. Duplicate patients that inflate readmission rates, ED department name variants that split your metrics, mixed date formats, and satisfaction scores that include impossible values.

dim_patients (800)dim_departments (12)dim_providers (60)fact_encounters (3,000)fact_quality_metrics (1,500)

●dimension tables  ● fact tables

The board meets Wednesday

The CMS quality report is due and the numbers aren’t ready.

Looking for something different?

|