Excel Dashboard for Customer Service Metrics

Chandoo and his Excel Dashboard programmers are having a great time during their “Dashboard Week”. They are building and sharing Excel-based dashboards and I’ll be sure to report to you some of the great work they are doing.

(Chandoo runs the Excel School which includes modules for Excel Dashboard Training – click the link to learn more).

Today we share this excellent excel dashboard example from Mara.

Here is the excel workbook link for this dashboard: Excel Dashboard for Customer Service.

Here’s a look at the dashboard itself:

Excel Dashboard with Customer Service Metrics

Here are the comments from Chandoo:

Techniques used by Mara to Create this Dashboard:

Mara used several techniques to create this dashboard. But I specifically liked 5 things about this dashboard. They are,

  1. Tweetboard kind of area at the top where she showed summary of status.
  2. Dynamic dashboard which can be filtered based on a month.
  3. Interactive chart with check boxes to show / hide information.
  4. Interactive comparison chart to compare target with actual performances (of valet wait times).
  5. Scrollable list of various gift shop items.

See the numbers on this image for reference:

customer service dashboard in excel

Again, this is the excel workbook link for this excellent excel dashboard: Excel Dashboard for Customer Service.

If you are interested in using Excel for Dashboards, click on this banner to learn more about Excel School for Dashboards:

Excel School for Dashboards

Related Business Intelligence Dashboard Examples:

  • Dashboard Topic: Excel School The dirty little secret in business intelligence dashboards is th ...

  • Dashboard Spy guest appearance! I'll be doing an interview with Chandoo as part of his Excel Sch ...

  • This KPI Dashboard is created using Microsoft Excel 2007 by Chandoo as part of his Dashboard Wee ...

Leave a Reply