Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        Courses / Healthcare

        Healthcare data analyst course with SQL and Python

        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.

        Start lesson 1Practice the first unit of every course. No account needed.
        58lessons
        351checked exercises
        10projects, cases and exams
        Prepares you for Healthcare data analyst roles and interviews

        What you will be able to do

        • Read a patient chart: the banner, encounter types, diagnoses and their ICD-10-CM codes, results against reference ranges and the medication list
        • Tell clinical data from claims data, and name the code set behind each column: ICD-10-CM, ICD-10-PCS, HCPCS, NDC, LOINC and SNOMED CT
        • Map HL7 v2 messages and FHIR resources to the tables an analyst queries
        • Apply the HIPAA privacy rule: PHI, minimum necessary, limited data sets and the 18 Safe Harbor identifiers
        • Write SQL on encounters, diagnoses, labs, appointments and claims, from the first SELECT to window functions
        • Find duplicate patients, impossible dates and invalid diagnosis codes in raw extracts
        • Compute census, average length of stay, emergency department throughput and no-show rates to a written definition
        • Compute 30-day readmission rates with planned readmissions excluded, and build quality measures from a numerator, denominator and exclusions
        • Do the same analysis in Python with pandas: types, rates by group, merges and patient cohorts
        • Measure denial rates and payer mix, and build a Safe Harbor de-identified extract in SQL

        Who it is for

        You know some SQL or Excel and want to work in healthcare
        The course teaches what the data means first, then uses the SQL and Python you know on records shaped like a hospital's.
        You work in health information, coding or billing and want to move into reporting
        You already know the codes and the forms. Here you learn to query them, define measures and catch the errors that change a number.
        You're preparing for a healthcare data analyst interview
        Interview questions at three levels and two timed mock exams that mix SQL tasks with questions on definitions, privacy and data sources.

        What you can practice free

        Unit 1, The patient chart: 6 lessons and 32 checked exercises, with no account or card.

        Start the free unit

        The rest of the course opens with a One Course or All Access plan. See plans and prices

        Keep going in Healthcare data analytics

        Choose access here. Your course is already selected.

        One Course

        Every lesson, project and mock exam in Healthcare data analytics.

        Loading price/ month

        Billed monthly. Cancel any time.

        All Access

        Every course, exam and project, plus the Interview Hub.

        Loading price/ month

        Billed monthly. Cancel any time.

        Projects, case studies and mock exams

        Learn 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

        FreeNo account or card needed. Every lesson in this unit is yours to practice.

        The patient chart

        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.

        6 lessons

        Where health data comes from

        Clinical and claims data, the code sets inside them, HL7 messages and FHIR resources, and reading a data dictionary.

        5 lessons

        HIPAA privacy for analysts

        What counts as PHI, the 18 Safe Harbor identifiers, limited data sets and minimum necessary access, with easy interview questions.

        5 lessons

        First queries on the EHR

        SELECT and WHERE on patients, encounters and labs, counting visits against people, and the dates behind length of stay, age and monthly admissions.

        4 lessons

        Intermediate

        Joining clinical tables

        Patients with their encounters, diagnoses by code, labs with their stays, and the left joins that find what is missing.

        5 lessons

        Data quality

        Duplicate patients under two record numbers, impossible dates and values, invalid diagnosis codes, and a data quality audit project.

        5 lessons

        Operational measures

        Census and average length of stay, emergency department throughput and no-show rates, defined precisely, with medium interview questions.

        5 lessons

        Advanced

        Readmissions, cohorts and quality measures

        The 30-day readmission rate, planned readmissions, measure logic with numerators, denominators and exclusions, patient cohorts, and a readmissions report project.

        6 lessons

        Python on health data

        The same tables as CSV extracts in pandas: loading and typing them, rates by group, merges and cohorts.

        5 lessons

        Claims and the revenue cycle

        How a claim moves from charge to payment, denial rates by reason and payer, payer mix, and a denials case study.

        4 lessons

        Expert

        Advanced analysis and de-identification

        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.

        5 lessons

        Interview and exam practice

        Hard healthcare data analyst interview questions and two timed mock exams.

        3 lessons

        Common questions

        Is it free?

        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.

        Is the data real?

        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.

        Is this EHR vendor training or a certification?

        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.

        How are my answers checked?

        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.

        How long does the course take?

        About 17 hours if you do every lesson once. Most lessons take 15 to 20 minutes, and the mock exams are 40 minutes each.

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Change your plan

        Checking the price

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.