__STYLES__
Tools used in this project
Maven Hospital Challenge

About this project

You can gain detailed insights and metrics related to various encounter classes directly on the map. Hover over different sections to see dynamic data updates and analyze performance trends. This intuitive visual approach allows for a comprehensive understanding of critical KPIs.

Overview page

  • It presents 7 cards with the following info:
  • the number of (distinct) Patients Admitted
  • the number of (distinct) Patients Readmitted within 30 days post procedure
  • the Readmission Rate (within 30 days post procedure)
  • the number of Encounters
  • the number of Procedures
  • the average cost per Visit
  • the average insurance coverage cost rate

Each card is enriched, using conditional formattig, with the YoY comparison, in order to highlight if there are some points of attention. undefinedTo view some significant info, filtered based on encounter class, was implemented an interation via tooltip.

In general each tooltip shows:

  • a distribution of encounters and avg. waiting time by 4-hour time slot, in order reason about resource allocation. The highlighted bin(s) is that with the max waiting time, in this way cab ne easy idetifying probable high demand peaks. For the inpatient encounter class, the graph shows the avg. time in days spent in Hospital by Reason Description, in 2021 COVID-19, was on top.
  • a bar chart of the avg number of Procedures by encounter class
  • kpis to monitoring: readmission rate, costs and insurance coverage

Patient Details

By clicking on details button in Patients Admitted card you can reach a new page of details about patients. The idea is to show how many encounters or procedures are associated to different Ethnic gruop to reason about access to the healthcare system in Massachusetts and study the insurance coverage and the readmission rate by age group to identify probable "class" of patients at risk.

Additional project images

KPI emergency
KPI inpatient
Overview with KPI and YoY
Patient Details
KPI urgentcare
KPI ambulatory
Discussion and feedback(16 comments)
comment-1561-avatar
Umayr Durrani
Umayr Durrani
4 months ago
I am amazed by your creativity and Great job on presenting such valuable insights.

comment-1562-avatar
Patrick D’Apollo
4 months ago
Marco is really talented. I had the fortune to study Power BI with him. He learned it quickly and is now already at a high level. Great job, Marco, congratulations!

comment-1574-avatar
Susanna Piccoli
3 months ago
Great! You did a fantastic job!

comment-1575-avatar
Valeria Saluzzo
3 months ago
Great job Marco! My favorite dashboard.

comment-1610-avatar
Akshay Paunikar
Akshay Paunikar
3 months ago
Wow Amazing !!! Very Interactive Dashboard design focusing on key metrics !!! I hope you will be the one winning this challenge. Good Luck !!!

comment-1615-avatar
Thet Pyae Sone Aung
Thet Pyae Sone Aung
3 months ago
Awesome!!!

comment-1637-avatar
Garcia Lufuankenda  Rogério, M.Sc.
Garcia Lufuankenda Rogério, M.Sc.
3 months ago
Very creative. Great work!

comment-1643-avatar
Jade Handy
Jade Handy
3 months ago
This is a sick project Marco! Well done. Fantastic visuals—love the unique brand conformity throughout and the gif work.
2000 characters remaining
Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.