Power BI Ticketing Dashboard
Budget: $10 – $30 USD
I have an Excel workbook that holds all incident and service-request records on a single sheet. I need you to turn that raw data into a polished Power BI dashboard that lets me monitor the health of our ticketing operation at a glance.
Core views & interactions
• Status coverage – compare open versus closed tickets in real time, with slicers for assignee and ticket type.
• Performance metrics – visualise MTTR and highlight whether each ticket met its SLA (these two metrics are the priority), plus secondary cards for reopened and reassigned rates.
• Workload insights – surface “most tickets requested by” and “most tickets resolved by”, daily open-ticket trend lines, and ageing buckets that flag anything breaching thresholds.
• Flexible time slicing – every visual must respond instantly to date-range selections (weekly, monthly, quarterly, bi-annual, annual).
Deliverables
1. A .pbix file containing the complete report, all measures, and clean data model.
2. Brief setup notes so I can refresh the file when the Excel source is updated.
Acceptance criteria
• All visuals interact correctly with the date and assignee filters.
• MTTR and SLA status calculate accurately for every ticket.
• No hard-coded paths: the report refreshes from the same-structure Excel sheet dropped into the folder.
If that scope is clear, let me know how long you’ll need and any clarifying questions you have.
Core views & interactions
• Status coverage – compare open versus closed tickets in real time, with slicers for assignee and ticket type.
• Performance metrics – visualise MTTR and highlight whether each ticket met its SLA (these two metrics are the priority), plus secondary cards for reopened and reassigned rates.
• Workload insights – surface “most tickets requested by” and “most tickets resolved by”, daily open-ticket trend lines, and ageing buckets that flag anything breaching thresholds.
• Flexible time slicing – every visual must respond instantly to date-range selections (weekly, monthly, quarterly, bi-annual, annual).
Deliverables
1. A .pbix file containing the complete report, all measures, and clean data model.
2. Brief setup notes so I can refresh the file when the Excel source is updated.
Acceptance criteria
• All visuals interact correctly with the date and assignee filters.
• MTTR and SLA status calculate accurately for every ticket.
• No hard-coded paths: the report refreshes from the same-structure Excel sheet dropped into the folder.
If that scope is clear, let me know how long you’ll need and any clarifying questions you have.