Project Overview
Interactive Power BI dashboard analyzing potential impacts of rural health interventions, focusing on care access, workforce challenges, and social determinants of health.
Built using synthetic data for portfolio and learning purposes only. No real patient data or actual organizational data was used.
Key Findings
- Post-Discharge Support, Specialty Telehealth, and Suboxone Program are the most utilized interventions.
- Mobile and Telehealth Clinics deliver the highest cost savings.
- Outcomes are well distributed across 5 counties.
- Opioid and Rural Patients represent the biggest opportunities.
Recommendations
- Scale Post-Discharge Support and Suboxone Program.
- Expand Mobile & Telehealth services.
- Strengthen support for food, housing, and employment needs.
- Focus resources on higher-need counties (Yakima & Spokane).
Key Features
- Multi-page interactive dashboard (Overview, Intervention Analysis, Target Groups & Barriers, Geographic View)
- Analysis of intervention effectiveness, cost savings, and geographic distribution
- Focus on key rural health challenges: Post-Discharge Support, Specialty Telehealth, Suboxone Program, and Social Determinants of Health (Housing, Food Insecurity, Unemployment)
Skills Demonstrated
- Data modeling (Star Schema)
- DAX measures and calculations
- Interactive dashboard design with page navigation
- Healthcare domain knowledge in risk adjustment and rural health policy