High Level Design


In order to avoid delayed treatment, inappropriate appointment setup, increased wait time 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:

Physician Allocation - Healthcare Dashboard


Deliver better care by streamlining physician allocation.


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)

Suggested data model for physician allocation analysis