SERVICE PERFORMANCE

IT Operations Dashboard

Illustrative service data for the NovaTech student project.

SAMPLE DATA

Total tickets50All sample records

Open tickets1020% of sample tickets

Resolved tickets2142% of sample tickets

Avg. resolution7.9 hrsResolved-record average

TICKET VOLUME

Tickets by category

50 total

Access

Hardware

Network

Software

Printer

Change Request

Category counts match the 50 records in the NovaTech Excel workbook.

TICKET STATUS

Work in the queue

Open1020%

Resolved2142%

Pending1938%

Use consistent status labels in the Excel ticket records.

ASSET LIFECYCLE

Replacement review

8assets flagged for review

Assets older than five years are flagged by the workbook formula. Confirm actual condition, warranty, and budget before recommending replacement.

Keep the provided Excel workbook alongside your project files and update the figures here to match its data.

CHANGE MANAGEMENT

Change request outcomes

4Approved

5Declined

4Pending

Change request outcomes match the 13 change-request records in the NovaTech Excel workbook.

View change process →

For assessment: This HTML dashboard displays manually entered values aligned with the original NovaTech Excel workbook. If you change the workbook records, update the dashboard figures so the two remain consistent.