High Level Design
Overview
In order to avoid delayed treatment, inappropriate appointment setup, increased wait time, patient safety and patient dissatisfaction it is important to analyze our health care plan physicians allocation.Dashboard Example (sample data)
Click on the image to open and interact with the dashboard:
Goals
Deliver better care by streamlining physician allocation.
Objectives
Improve the ratio of patients per physician to 100:1.
KPI Architecture
| Objectives | KPIs | Measures | Data Source |
|---|---|---|---|
| Improve the ratio of patients per physician to 100:1. | Patients per Physician Ratio | Average Distance to Patient | FACT_VISITS |
| In-house physicians Ratio | DIM_PHYSICIANS |
Data Requirements
| # | Source | Table Name | Table Details (Type, #Rows, Key field/s) |
|---|---|---|---|
| 1 | Internal Resource | FACT_VISITS | Records all the patients’ visits to their physicians |
| 2 | DIM_PATIENTS | List of all patients | |
| 3 | DIM_PHYSICIANS | List of all physicians | |
| 4 | CITIES | List of all cities | |
| 5 | DIM_SPECIALITIY | List of specialties |
Data Modeling (Elasticube Design)
