The Healthcare Provider Dashboard is an interactive Power BI dashboard built to analyze and visualize key healthcare billing and cost metrics. The project involves data cleaning and preparation in Excel, followed by data visualization in Power BI. It offers insights into billing amounts, treatment costs, medication expenses, and out-of-pocket payments, empowering stakeholders to make data-driven decisions.
- Key Metrics: Billing amounts, medication costs, treatment costs, and insurance coverage.
- Breakdowns: Data categorized by location, procedures, diagnoses, and medical departments.
- Data Preparation: Cleaned and organized raw data using Excel for better analysis.
- Interactive Filters: Filter data by year, quarter, and demographic attributes (e.g., race).
- Visualization: Clear, intuitive design to uncover trends and insights easily.
This project aims to assist healthcare providers and analysts in understanding financial patterns, optimizing costs, and improving cost management strategies.
- Excel: For data cleaning and preparation.
- Power BI: For data visualization and dashboard creation.
Clone this repository to access the files. The .pbix file can be opened in Power BI Desktop for exploring or customizing the dashboard. Excel files used for data cleaning are also included for reference.
- Add predictive analytics to forecast healthcare costs.
- Include patient satisfaction data for deeper insights.
- Expand demographic filters for more detailed analysis.