Healthcare Analytics Dashboard built with Power BI to transform hospital and clinic appointment data into actionable business insights.
The dashboard provides a comprehensive analysis of appointment performance, operational efficiency, patient experience, and financial performance.
Key insights include appointment trends, completion and no-show rates, waiting time, consultation duration, doctor and department performance, patient satisfaction, revenue, discounts, and net revenue.
The project includes data cleaning and transformation using Power Query, data modeling, Star Schema, Date Table, DAX measures, KPI calculations, interactive visualizations, slicers, drillthrough analysis, navigation, and final data validation.
Tools: Power BI, Power Query, DAX, Data Modeling, Data Visualization.