← Analytics Dashboards & Reports Analytics Dashboards & Reports

Average Time to Cut Keys Dashboard.

A Power BI dashboard for Ingress Management Services and Facilities Services, tracking monthly key-cutting workload, completion time, and backlog trends from 2023 onward.

Power BI Operational reporting Turnaround time Backlog trends

Key-cutting dashboard with average completion days and monthly backlog indicators, plus monthly columns for submitted, in-progress, notified, and canceled phases and trend lines for completion time and backlog. — Dashboard snapshot showing monthly key-cutting activity from 2023 through 2026. Figures reflect the captured report view, not live operational metrics. View full-size ↗

The need

Ingress Management Services and Facilities Services needed a clearer view of their key-cutting process: how much work was arriving, what was still in progress, how many customers had been notified, and how long completion was taking.

The dashboard brings these measures together with historical backlog trends so the teams can review monthly activity and identify periods when outstanding work peaked.

The dashboard

The Power BI report combines headline indicators for average days to complete a key cut and monthly backlog with a monthly trend chart. Columns compare submitted, in-progress, customer-notified, and canceled work-order phases, while lines show average completion time and backlog.

The historical view begins in 2023 and extends through the latest available reporting period. In the Power BI report, selecting a month shows the average completion time and backlog for that month.

My contribution

I assisted throughout the development process as a contributor to the dashboard, supporting the effort to give Ingress Management Services and Facilities Services useful information about their key-cutting operations.

Key metrics

Submitted work: monthly counts of submitted work-order phases.
Work in progress: visibility into phases still being processed.
Customer notifications: monthly counts of phases marked as notified.
Cancellations: monthly counts of canceled phases.
Average completion time: average days to complete key cutting.
Monthly backlog: outstanding-work trends and peak periods across the reporting history.

Operational value

The dashboard gives both teams a shared view of key-cutting activity, turnaround time, and outstanding work. Comparing monthly volumes with completion-time and backlog trends helps them examine busy periods and understand changes in the process over time.