MetroCare Community Hospital Project

Here is a project I created as part of a PowerBI Bootcamp I participated in. This project was my first time using Figma to make backgrounds.

The details of the project brief are below:

Company Name:

MetroCare Community Hospital

Company Overview:

MetroCare Community Hospital is a leading healthcare provider located in a thriving metropolitan area. Our mission is to deliver high-quality, patient-centered care in a compassionate and efficient manner. Our emergency room serves as the first point of contact for a diverse patient population experiencing a wide range of urgent medical issues.

Main Business Problem

In recent months, our emergency room has experienced an increase in patient volumes, and we currently have no reporting solution in place to analyse the impact of this growth. We want to understand if patient wait times are being affected by the increased number of patients and identify potential bottlenecks in our processes.

To address this challenge, am seeking a reporting solution in Power BI that will help our management team gain insights into the current performance of our emergency room, patient demographics (age, gender, race), wait times, admission rates, satisfaction scores, and department referrals. By analyzing these data points, we aim to identify areas for improvement and optimize our emergency room operations.

By implementing this Power BI reporting solution, we aim to:

• Analyse the relationship between the increased number of patients and patient wait times, identifying any correlation or trends that may indicate bottlenecks or inefficiencies in our processes.
• Investigate patient demographics (age, gender, race) to ensure equitable care delivery and understand if certain groups are disproportionately affected by extended wait times.
• Monitor admission rates to assess the efficiency of our patient triage process and resource allocation.
• Examine patient satisfaction scores to evaluate the impact of increased patient volumes and wait times on the overall patient experience.
• Assess department referrals to identify patterns and potential opportunities for collaboration and process improvement.