Entry 10: EpicHospital

If the report above doesn't load, please find a live version here.

Note From The Creator: 

I came across an intriguing synthetic hospital dataset on Kaggle, which inspired me to create a comprehensive analytical report using Power BI.

My first step involved thoroughly analyzing the dataset. I quickly realized that patient gender information was missing. To resolve this, I developed a Python script leveraging the gender-guesser package, enabling me to accurately assign a gender to each patient based on their name.

Next, I structured the data into a clear star schema within Power BI, carefully connecting all dimension tables to the central fact table via relationships. This foundational step ensured robust and efficient data modeling.

The real excitement began with storytelling and creatively uncovering analytical insights. My report highlights trends and insights around medical conditions, patient admissions over time, blood type distributions, and more.

When visualizing patient admissions over time, I provided flexibility by displaying data either monthly or daily. If a single year is selected, the visualization dynamically presents a line chart for continuous monthly analysis. When multiple years or daily data options are selected, it shifts to a bar chart for better readability. To achieve this seamless transition without using additional buttons or bookmarks, I cleverly overlapped the bar and line charts, dynamically adjusting their transparency based on slicer selections.

Furthermore, I introduced a user-friendly patient register with a paginated table, enhancing the browsing experience compared to traditional scrolling tables. Selecting a patient navigates to a detailed profile page showing key metrics such as condition, hospital stay duration, total billed amounts, and more. A similar feature is included for doctors, highlighting details like hospital affiliation, medical conditions treated, and total patient count. Dummy profile images dynamically adjust based on gender, adding an engaging visual element.

Finally, I crafted an appealing visual design inspired by hospital website color schemes, settling on a calming green theme. Using Figma, I designed a polished, visually cohesive background, complemented by a unique logo created with the help of ChatGPT, combining the classic medical cross, the Power BI logo, and a memorable brand name, "EpicHospital," symbolizing the blend of healthcare data and my affiliation with EpicData.