Upcoming course · not yet open

Build an IT Operations Dashboard

Show leadership what's aging, what keeps breaking, and how fast service comes back — calculated from your ticket and outage records. Labs use fictional data.

The full project

What you'll build

  1. 01

    Turn ticket and outage exports into a dashboard

    Clean sample help desk and incident exports, then calculate aging open tickets, recurring categories, and median time to restore service — with date and severity filters.

  2. 02

    Design it for leadership

    Pick a few metrics that drive decisions, put a plain-language definition beside each, and show the records behind every number.

  3. 03

    Write a short weekly operations summary

    Turn the dashboard into five sentences: what changed, what's at risk, what recurs, and what the team will do next.

Starter worksheet

KPI worksheet

Start with these examples, then add your own metrics. Every metric needs a definition, a data source, an owner, and the threshold that triggers action.

MetricDefinitionData sourceOwnerAction threshold
Aging open ticketsOpen tickets created more than 7 days agoHelp desk ticket exportService desk leadMore than 5, or any P1/P2
Top recurring categoryTicket category with the most tickets in the periodHelp desk ticket exportProblem managerSame category tops 2 weeks in a row → open a problem record
Median time to restoreMiddle restore time of resolved outages in the periodOutage / incident logInfrastructure leadAbove 90 minutes
Unresolved outagesOutages with no restore time recordedOutage / incident logOn-call managerAny older than 4 hours
—————
Download worksheet (.csv)

Notify me when it opens

This course isn't open yet. Leave your details and we'll email you when it opens. No payment is taken.

Upcoming courses

Hands-on courses for IT teams

Pilot · waitlist open

Build an Internal AI Help Desk With Access Controls

Build an assistant from sample SOPs and test what each employee role can access.

Coming soon

Build a Cloud Cost Dashboard

Turn a sample billing export into a dashboard, investigate a spending change, and set budget alert thresholds.

Coming soon

Design an Employee Offboarding Workflow

Build a repeatable workflow with HR, IT, and manager responsibilities, an escalation path, and completion evidence.