Healthcare Data Analysis with Power BI

Project Overview

This end-to-end healthcare analytics project leverages Power BI to uncover actionable insights from patient data. It demonstrates the full lifecycle of a data analysis workflow—from data cleaning and transformation to DAX calculations and dashboard design. The project is ideal for beginners aiming to build real-world business intelligence skills.

Objectives

• Analyze performance of different Speciality types
• Calculating WaitingList of patient over period by Specicality types
• Analyze Top 5 Speciality
• Visualize hospital performance metrics
• Build interactive dashboards for decision-making in healthcare operations

Tools & Technologies

• Power BI Desktop – for data modeling and visualization
• Excel – for initial data cleaning
• DAX – for calculated columns and measures
• GitHub – for project documentation and version control

How to Use

1. Download or clone this repository.
2. Open HealthcareDashboard.pbix in Power BI Desktop.
3. Explore the dashboard using slicers and filters to interact with the data.

Learning Outcomes

• Create calculated columns and measures using DAX
• Format dashboards with custom visuals and backgrounds
• Build slicers with tooltips and dynamic filtering
• Apply real-world healthcare KPIs in Power BI

Author

Muhammed Ibrahim M S

Aspiring Data Analyst