Key Learning. Healthcare Data & Power BI Foundations
- Providers = Deliver care. e.g., doctors, hospitals, clinics, pharmacies.
- Members = Receive care. e.g., patients, beneficiaries
- DAX = Power BI calculation language
- ETL = Move and prepare data for analytics
- HIPAA = Healthcare privacy law
- CDC = Public health agency
- CMS = Medicare/Medicaid regulator
- NIH = Medical research organization
- FHIR (HL7 FHIR) = Industry standard for secure healthcare data exchange and interoperability.
Data Modeling & Analytics
Star Schema
- A simple data warehouse design with one central fact table connected to multiple dimension tables.
- Optimized for reporting and fast queries.
- Easy to understand and maintain.
Snowflake Schema
- An extension of the Star Schema where dimension tables are further normalized.
- Reduces data redundancy and storage.
- More complex but offers better data organization.
DAX (Data Analysis Expressions)
- Formula language used in Power BI, Power Pivot, and Analysis Services.
- Used to create calculations, measures, and business KPIs.
- Example: YTD revenue, rolling averages, growth percentages.