📌Project Overview
This dashboard analyzes performance metrics across multiple healthcare programs to evaluate record validity, service compliance, and monthly performance trends. The goal was to identify fluctuations and improvement opportunities using interactive data visualization in Power BI.
Dashboard Design & Interactivity
The dashboard was built with dynamic filtering functionality using a program slicer. Users can select between:
- 340B
- Chronic Care
- HIV Support
This enables comparative performance analysis across healthcare programs while maintaining consistent KPIs.
The report incluedes:
- Total Records KPI
- Valid Records KPI
- Valid Percentage Rate
- Monthly Trend Visualization
🔎 Program -Level Analysis
340B Program
Analyzed monthly record validity trends to identify periods of performance dips and recovery patterns.
Chronic Care Program
Evaluated compliance trends and seasonal variation in service delivery.
HIV Support Program
Reviewed validity rate fluctuations to determine potential operastional inconsistencies.
Key Insights
- Validity rates fluctuate across programs, indicating performance variability
- Certain month show consistent dips across multiple programs
- Interactive filtering improves decision-making by isolating program-level performance