Healthcare Data Analysis & Power BI Dashboard

Analyzed 56K+ patient records and approximately $1B in total billing to evaluate healthcare and financial performance.

The project included:

• Data cleaning and transformation using Power Query

• Development of key healthcare and financial KPIs

• Analysis of average billing, patient age, and length of stay

• Comparison of billing across insurance providers and medical conditions

• Analysis of patient admission trends from 2019 to 2024

• Identification of the highest-billing insurance provider and medical condition

• Development of an interactive Power BI dashboard using DAX and Power Query

Key findings included an average billing of approximately $25.5K, an average patient age of 52, and an average length of stay of 16 days.

Tools: Power BI, Power Query, DAX