It should be date, but some reason, whatever method I used to convert it to a date type it didn’t work. once it’s downloaded open the file and let’s take a look: I already provided the link to the dataset above, you can also google ‘Real World Fake Data call-centers’ and you should be able to find it.

Step 1: Download the dataset and open the file.

So you are more than ready to start building it today and add your personal touch to it!īefore jumping into how to build the dashboard I already have the xlsx file on my GitHub profile here and you can download it and fiddle around to see things before building your own. If you are nervous or feeling meh about using Excel, bear in mind that I learned Excel on the go as I built this dashboard in one day. We can use them to filter our data and thus make our dashboard interactive. My favourite part actually was the slicers that we can see on the left side. Then we have a map, a column chart for the reason the person called and last but not least, a bar chart indicating the response time. Below them we have a line chart to show the trend of calls during October(that’s the only month available, the dataset is basically information about calls made in October 2020), a doughnut chart to show through which channel the call was made. Other than that, what does it contain ? at the top we have 3 KPI’s which list the number of calls in total, the average customer satisfaction score and the average call duration in minutes. As you can see in the picture, it looks fugly.

How to find data analysis tool in excel