📋 Project Overview
The Medokanja project focuses on analyzing healthcare waiting lists to enhance resource management and improve patient care for a public hospital. The name "Medokanja" combines "Medo" (medical) and "Kanja" (patient in Japanese).
This project aims to equip a hospital with actionable insights to minimize waiting times and enhance operational efficiency. By utilizing historical trends (2018–2021), the dashboard identifies bottlenecks, improves service delivery, and highlights demographic patterns and medical specialties with delays, enabling targeted improvement strategies.
🔑 Key Concepts
🏥 Inpatients
Individuals requiring hospital admission for complex treatment or extended care.
🚪 Outpatients
Receive care without overnight hospitalization.
📊 Statistical Distribution
The dataset is likely not normally distributed, as the mean and median differ significantly, suggesting skewness and potential outliers.
Sensitive to outliers, which can inflate or distort the central tendency.
Provides a more reliable center for skewed data by focusing on the middle value.
Including both average and median in the dashboard offers flexibility to meet diverse analytical needs.
📚 Prerequisites & Architecture
🛠️ Technical Requirements
- Power BI Desktop and App
- Proficiency in building and publishing Power BI reports
- Advanced knowledge of DAX formulas
📖 Two (2) Report Pages
- A Summary Page for an overall view of the data.
- A Detailed Page for granular analysis and deeper exploration.
📱 Interactive Dashboard
For better visibility, switch to full-screen mode to easily navigate and visualize the dashboard.
🔗 External Links
To explore more about this project: