Boxplot modernized the Power BI reporting layer for a large health center’s crisis stabilization and residential facilities. We integrated clinical data from Epic and SQL Server to develop a structured semantic model using DAX. The new dashboard accurately captured 23-hour observations, mobile crisis activity, and true bed utilization, moving beyond legacy census-based metrics. We also enhanced financial dashboards for location-based analysis and documented strict KPI definitions to align leadership on reporting standards.
