High Level Design
OverviewIn 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:
Deliver better care by streamlining physician allocation.
Improve the ratio of patients per physician to 100:1.
|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|
|#||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)