This Power BI dashboard provides a comprehensive overview of healthcare wait list data, segmented by case types and time periods. Key features include:
KPI Cards displaying the latest month’s wait list total (709K) and comparison with the previous year (640K).
A Donut Chart breaking down total values by Case_Type (Outpatient, Day Case, Inpatient).
Multiple Slicer Filters allowing users to interactively filter data by:
Archive Date
Medical Specialty
Case Type
Wait Time Metric (Median/Average)
A Bar Chart showing Avg/Med Wait List by Time_Bands, highlighting long-term wait time distribution.
Line Charts tracking the trend in total values over time, both for individual case types and overall trends.
A Table displaying average wait list values by medical specialty, such as Ophthalmology and Paediatric Respiratory.
The visual design uses color coding for easy distinction between metrics, and interactive slicers enhance user-driven analysis. The dashboard effectively supports healthcare operations and planning by revealing trends, bottlenecks, and service demands across time.
