Skip to content

Latest commit

 

History

History
10 lines (7 loc) · 980 Bytes

Readme.md

File metadata and controls

10 lines (7 loc) · 980 Bytes
Raw

This is a Power BI analysis of Healthcare data of hospitals accross various countries. There are three dimension tables (Bed_detail, Department and staff_detail) and one fact table (detail data set).

Three dashboards are created:

  1. Main Dashboard: Contains the overviews of the inpatient and outpatient dashboards and has navigation buttons to navigate to the respective dashboards.
  2. Inpatient Dashboard: Contains KPI analysis for KPIs like mortality rate, average treatment cost, patient to staff ratio, inpatient satisfaction rate, average inpatient rating, bed turnover rate etc.
  3. Outpatient Dashboard: Contains KPI analysis for KPIs like Average age, treatment cost, patient to staff ratio, average ER time etc.

Each of the secondary dashboards contains a back button to navigate to the main dashboard. The secondary dashboards also contain more granular analysis of each KPI by using line, column and donut charts with a slicer provided for selecting the department.