Healthcare Community Analysis — Power BI

Overview

Analyzed 10,000+ patient and demographic records to identify insurance trends, disease patterns, and claim approval rates using Power BI and Excel.

Problem Statement

Healthcare operations lacked visibility into denial trends and insurance performance across patient demographics.

Tools Used

• Power BI (DAX, Power Query, KPI dashboards, slicers, drill-through)
• Excel (data cleaning, pivot analysis)

Key Findings

• Identified 15–20% improvement opportunity in claim approval rates
• Built interactive drill-through dashboards for admissions monitoring
• Segmented patients by insurance type, age group, and disease category

How to Use

Download the .pbix file and open in Power BI Desktop.