Physician Allocation

High Level Design


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.


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


The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)