Maven Hospital Challenge

I have been asked to create a report , based on the patient records to give stakeholders a visibility into the hospital’s recent performance.

I decided to split the project on 3 parts:

1. Hospital Performance

On that page it is able to learn more about the main Hospital information like:

• Income,

• Number of Patients examined,

• AVG base cost and total cost of a visit,

• AVG visit time

To make the data more clear and insightful there are given month over month (MoM) details, so it is possible to compare actual performance with the recent one.

MoM = month over month | CY = current year | CM = current month | PM = previous month

2. Patient Analysis

That page allows to find more information about the Patients. It is possible to check:

• Number of Patients gone and alive,

• AVG year of Patients gone and alive,

• Percentage of Patient readmitted over time,

• Patient's coverage for the medical services,

• Listed medical services with number of visits, their total cost and patient coverage,

• Patients information like: gender, race, ethnicity etc.

• Map view from where Patients are.

3. Insurance Preview

That page shows the most important Insurer's information. It is able to check here:

• Insurer comparison, based on the total coverage value spent for the Patient

• Insurer coverage for the specific medical service and encounter classification

• Insurer coverage value for specific Patient division