Lesson 1Supporting size tables: provider, place, facility, code looksThis part explains supporting size tables like provider, place, facility, and code looks. It covers groups, slow changing parts, and how good sizes improve filtering, grouping, and deep looks in analysis.
Provider and specialty sizesPlace and facility groupsClinical code and value set looksManaging slow changing sizesLesson 2Encounter/Visit part: admit/arrival, discharge, visit type and timesThis part describes the encounter or visit part, including coming in, arriving, leaving, visit type, and times. It covers linking encounters to patients, places, and payers, and helps length-of-stay and flow measures.
Encounter types and groupsAdmission, transfer, and discharge timesLinking encounters to patientsVisit grouping and episode logicLesson 3Standard patient part: identifiers, people info, merges and lastingThis part sets a standard patient part for analysis, covering identifiers, people info, merges, and lasting rules. It explains mastering across sources, handling doubles, and keeping old identity changes safely.
Core patient identifiers and keysPeople info parts for analysisPatient matching and merge logicLasting and source orderLesson 4Procedures and orders parts: procedure codes, order IDs, doing providerThis part covers making procedures and orders, including procedure codes, order identifiers, and doing providers. It explains linking orders to results, planning, and status, while helping use, quality, and flow analysis.
Order header and line item setupProcedure and order coding standardsLinking orders, procedures, and resultsOrder status, timing, and priorityLesson 5Keys and links: patient_id, encounter_id, result linking and reference sureThis part details how patient, encounter, and result keys keep reference sure across clinical datasets. It covers natural vs stand-in keys, flowing rules, and ways for late-coming or fixed records.
Patient and encounter key designResult and order link patternsStand-in keys vs natural identifiersFlows, deletes, and lost recordsLesson 6Diagnoses and problem list parts: fields, code system, severity, start and endThis part focuses on diagnoses and problem list parts, including fields for codes, status, severity, start, and end. It talks code systems, long vs short problems, and handling changes or stopping over time.
Core diagnosis and problem fieldsICD, SNOMED, and other code systemsStart, end, and episode timingActive, old, and solved problemsLesson 7Lab result part design: test code, sample, collection time, result value, units, reference range, statusThis part details lab result part design, including test codes, samples, collection times, values, units, reference ranges, and statuses. It talks odd flags, groups, and handling fixed or repeated results for analysis.
Test, group, and part setupSample type and collection infoResult value, units, and reference rangeResult status, flags, and fixesLesson 8Setup examples: star setup for analysis and part link mappingThis part brings in star setups for clinical analysis and compares them with part-link drawings. Learners see how facts, sizes, and links map to EHR ideas and help fast analytic questions.
Clinical fact and size tablesStar vs snowflake in healthMapping EHR parts to factsBridging many-to-many clinical linksLesson 9Ideas of analysis data making vs deal makingThis part compares analytic and deal data models in health. It explains normal, unnormal, question patterns, and work traits, guiding choices that balance work, bend, and data good.
OLTP vs OLAP works in EHRsNormal and unnormal tradeoffsSlow changing clinical partsMaking for long patient views
