This Power BI dashboard provides an analytical view of healthcare provider data, offering insights into billing amounts, treatment costs, insurance coverage, and various healthcare services. The interactive visualizations help stakeholders understand financial aspects and service distribution across different departments, procedures, and diagnoses.
- Billing & Cost Analysis: Breakdown of billing amount, treatment cost, medication cost, and insurance coverage.
- Geographical Insights: Mapping total billing amounts by state.
- Procedure-Based Analysis: Comparison of billing amounts across X-Ray, CT Scan, MRI Scan, Ultrasound, and Blood Test.
- Departmental Breakdown: Billing distribution across Cardiology, General Surgery, Neurology, Orthopedics, and Pediatrics.
- Diagnosis & Service Type Analysis: Segmentation of healthcare services into Emergency, Inpatient, and Outpatient categories.
- User Filters: Dynamic selection of Department, Procedure, and Diagnosis for custom insights.
- Total Billing Amount: $3.36M with an average billing per person of $674.86.
- Highest Billing Procedure: X-Ray ($1.05M, 31% of total billing).
- Department with Highest Billing: Cardiology (25.24%, $846.93K).
- Hypertension Cases: 53.92% are outpatient, while 22.66% require emergency care.
- Power BI for dashboard creation and data visualization.
- Microsoft Bing Maps for geographical insights.
- DAX & Power Query for data transformation.
- Open the Power BI file (
.pbix) in Power BI Desktop. - Interact with filters to explore different segments of healthcare billing data.
- Use insights for data-driven decision-making in the healthcare industry.
- Integration with real-time hospital data.
- Predictive analytics for cost forecasting.
- Enhancing interactivity with drill-through reports.
If you have any feedback or suggestions, feel free to connect!
🔗 LinkedIn: https://www.linkedin.com/in/rohanur-rahman-ontu/
📧 Email: [email protected]