Mighty QuinnConsultingMighty Quinn Consulting — home
Insights

Automotive · Customer Service

Customer Service Dashboard

An experimental dashboard over a SharePoint-based ticket process, to see what the tickets were actually about.

Duration
< 5 months
Budget
< 10.000 €
Project team
MQC 1 · Client 4

End-of-project survey

This client did not answer our end-of-project survey — so there are no scores to show.

The brief

  • Monitor active tickets and give managers directional insight into what the tickets are about

The build

  • Power Query to load and prepare the SharePoint data, then the measures and bookmarks the questions needed
Tech stack
  • Power BI
  • Power Query
  • SharePoint
Our part
  • Development

The good

  • A handy dashboard that gives quick insight into the ticket load

The bad

  • The analysis stayed too high level; a deeper understanding of the underlying data would have helped