Create a prototype of a dashboard that displays the following Key Performance Indicators for a hospital, it should include:
· Average treatment costs for patients by age groups in the following age groups: 0–1, 2–17, 18–44, 45–64, 65–84, 85+
· Number of monthly hospital admissions
· Number of monthly hospital readmissions
· Distribution of the length of stay in the hospital
You can use excel to compile this information. It is more important to focus on which chart would best display the information and how the information should be displayed.
120 POINTS
