Interactive Hospital Dashboard in Power BI

Designed and developed a complete Hospital Analytics Dashboard using Microsoft Power BI to transform raw healthcare transactional data into interactive business insights. The project included data cleaning, preprocessing, data modeling, KPI creation, and building a professional multi-page dashboard for healthcare analysis and financial reporting. Key Tasks: • Cleaned and transformed raw hospital visit data using Power Query • Handled missing values, duplicates, and formatting inconsistencies • Built a Star Schema data model with Fact and Dimension tables • Created relationships between patients, doctors, hospitals, departments, diagnoses, procedures, and payments • Developed DAX measures and healthcare KPIs including: * Total Revenue * Average Bill Per Visit * Medicine Cost Percentage * Total Visits * Distinct Patients * Visits Per Patient Dashboard Pages: 1. Executive Overview * Revenue analysis * Monthly visits trends * Hospital performance overview 2. Medical Analysis * Top diagnoses * Top procedures * Department workload analysis 3. Financial Insights * Revenue by payment method * Revenue by insurance provider * Cost breakdown analysis Tools & Skills: • Power BI • Power Query • DAX • Data Cleaning • Data Modeling • Dashboard Design • Healthcare Analytics • Data Visualization The dashboard was designed to be interactive, organized, and presentation-ready with a clean user-friendly interface.