This repository contains a comprehensive monthly summaries dashboard developed for the USA healthcare industry. The dashboard provides valuable insights into hospital operations, patient demographics, and financial trends, enabling data-driven decision-making.
- Filename:
dashboards.pbix - Format: Power BI Desktop File (.pbix)
- Purpose: Provides interactive reports and dashboards with visual analytics.
- Hospital Insights 📉: Admissions, discharges, bed occupancy, and readmission rates.
- Patient Analysis 🏥: Segmentation by state, gender, region, blood group, and payer provider (Medicaid, Medicare, Insurance, etc.).
- Financial Analysis 💰: Monthly expense trends, payer-wise revenue, and cost breakdowns.
- Decision Support 📊: Identifies regional healthcare demand patterns and cost-saving opportunities.
- Power BI - Data visualization and interactive reporting.
- SQL - Data extraction and transformation.
- Excel - Data preprocessing and formatting.
- Clone the repository:
https://github.com/UtkarshMidha/USA_Healthcare_Industry_Dashboard.git
- Open the
dashboards.pbixfile using Microsoft Power BI Desktop. - Connect to the required data sources, if applicable.
- Explore the interactive reports and gain insights into healthcare trends.
Want to improve the dashboards? Follow these steps:
- Fork the repository.
- Create a new branch for your modifications.
- Make improvements and push changes.
- Submit a pull request.
This project is licensed under the MIT License. See the LICENSE file for details.
For any queries or suggestions, feel free to open an issue .