Healthcare data holds incredible insights, and as a data analyst, I love transforming raw numbers into meaningful stories. This time, I worked on an Emergency Room (ER) Visit Analysis to uncover key trends in patient visits, satisfaction, and service efficiency.

Project Overview

I got this dataset from a data scientist running a 20-day data challenge on Instagram. At first, I explored it independently, but later, I introduced it to my community during a challenge, and everyone found it interesting. That’s when we all decided to work on it together and share our dashboards. After numerous breaks and pauses, I finally put together this visualization, and I’m excited to showcase my insights!

Tools Used

Excel – Data cleaning and preparation

PowerPoint – Design enhancements for dashboard elements

Power BI – Data visualization and dashboard creation

Key Insights from the Dashboard

Total Patient Visits: The ER recorded 9,216 visits, with a nearly even split between scheduled (49.96%) and non-scheduled (50.04%) appointments.

Patient Satisfaction: The average satisfaction score stands at 5.47, but a concerning 75.10% of services remain unrated.

Waiting Time: Patients wait an average of 35.26 minutes before receiving medical attention.

Patient Demographics:
Most patients are adults, followed by middle childhood and teenage groups.

Weekend visits (2.6K) are significantly lower than weekday visits (6.6K).

Department Referrals: While many patients didn’t require further referrals (5,400 cases), some were directed to General Practice, Orthopedics, and other specialties.

Seasonal Trends: The highest number of visits occurred in August (1,024), while February recorded the lowest (431).

Challenges and Learnings

Balancing multiple projects and commitments made it hard to complete this dashboard sooner, but I eventually pushed through.

Presenting insights in a clear and engaging way required creative dashboard design, which PowerPoint helped refine.

Community involvement gave me a fresh perspective and motivated me to finalize my work.

Final Thoughts

This project reinforced my passion for healthcare analytics and storytelling through data. I’m glad I took on this challenge, and I hope it provides valuable insights for understanding ER visits better.

📌 Check out the full project on GitHub: [https://github.com/Aderonke101]

💡 What do you think of these insights? Let’s discuss in the comments!