Physician Allocation

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:

Explore 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)