One Course
Every lesson, project and mock exam in Healthcare data analytics.
Billed monthly. Cancel any time.
Level 1: Newcomer
0 points
Sign in to save your progress across devices.
A healthcare data analyst course built on the records of Cedar Ridge Health, a fictional health system. Read patient charts, learn where clinical and claims data come from and what HIPAA lets an analyst do with them, then answer the questions analysts get, in SQL and Python: length of stay, readmissions, no-shows, emergency department waits, denials and quality measures.
Unit 1, The patient chart: 6 lessons and 32 checked exercises, with no account or card.
Start the free unitThe rest of the course opens with a One Course or All Access plan. See plans and prices
Choose access here. Your course is already selected.
Audit three raw extracts with one query per check, then decide what to fix first and why.
7 steps · 35 minProject · AdvancedThe half-year readmissions reportBuild Cedar Ridge's half-year readmissions report: index stays, readmissions and the rate with planned readmissions excluded, by department, payer type and month, and what the figures can say.
7 steps · 21 minCase study · AdvancedWhere denials come fromFind out how high Cedar Ridge's denials really are, which reasons, payers and encounter types drive them, the dollars at stake for each team, and where to start.
6 steps · 35 minCase study · ExpertTwo reports, two lengths of stayTwo departments report different average lengths of stay for the same half-year: reproduce both, find the convention that splits them, and recommend one definition.
6 steps · 25 minProject · ExpertAn emergency department dashboardBuild the figures for an ED dashboard by facility: visits, left without being seen, median door-to-provider time, median length of stay and admissions, each with its definition.
6 steps · 35 minMock exam · ExpertMock exam AA timed mock exam: 25 questions in 40 minutes, SQL tasks on Cedar Ridge data and questions on definitions, privacy and data sources.
25 questions · 40 minMock exam · ExpertMock exam BA second timed mock exam: 25 new questions in 40 minutes, leaning on claims, quality measures, privacy and window functions.
25 questions · 40 minLearn healthcare data analysis on the records of Cedar Ridge Health, a fictional health system with two hospitals and a clinic group. You read patient charts, map where clinical and claims data come from, apply the HIPAA privacy rules an analyst works under, and then answer real questions with SQL and Python: length of stay, readmissions, no-shows, emergency department throughput, denials and quality measures. Every answer is checked against the data, and a hidden second copy of the data catches answers typed in by hand. Every patient is invented, and the course teaches data work, not clinical care.
Beginner
The patient banner, encounter types, diagnoses and their codes, results against their reference ranges and the medication list, read the way an analyst reads them.
Clinical and claims data, the code sets inside them, HL7 messages and FHIR resources, and reading a data dictionary.
What counts as PHI, the 18 Safe Harbor identifiers, limited data sets and minimum necessary access, with easy interview questions.
SELECT and WHERE on patients, encounters and labs, counting visits against people, and the dates behind length of stay, age and monthly admissions.
Intermediate
Patients with their encounters, diagnoses by code, labs with their stays, and the left joins that find what is missing.
Duplicate patients under two record numbers, impossible dates and values, invalid diagnosis codes, and a data quality audit project.
Census and average length of stay, emergency department throughput and no-show rates, defined precisely, with medium interview questions.
Advanced
The 30-day readmission rate, planned readmissions, measure logic with numerators, denominators and exclusions, patient cohorts, and a readmissions report project.
The same tables as CSV extracts in pandas: loading and typing them, rates by group, merges and cohorts.
How a claim moves from charge to payment, denial rates by reason and payer, payer mix, and a denials case study.
Expert
Window functions over a patient's encounters, a Safe Harbor de-identified extract, metric definitions that hold up, a measure discrepancy case and an emergency department dashboard project.
Hard healthcare data analyst interview questions and two timed mock exams.
The first unit, on reading the patient chart, is free and needs no account. The rest of the course opens with a One Course or All Access plan, and the pricing page shows every plan and its price.
No. Cedar Ridge Health and every patient in it are invented, and the data is generated. The tables are shaped like real EHR and claims extracts, so the queries you write transfer to the job.
No. The chart is our own generic design, and the course is not affiliated with any EHR vendor or certifying body. It teaches the data work that analysts do in any system.
SQL and Python answers run against the data and then against a hidden second copy with different values, so an answer typed in by hand does not pass. Wrong answers get a message that names the likely mistake, such as counting patients twice through a join.
About 17 hours if you do every lesson once. Most lessons take 15 to 20 minutes, and the mock exams are 40 minutes each.