The customer dashboard is created purely with Excel, including the survey form used to collect the responses. I thought that it would be a good idea to share what I have created for him.
Designing the Survey form is easy if you know the information you want to gather. The form collects the needed information and this becomes the "database" which the company use to analyse the trends and observations about their customers profile. Building this profile enable the company to better understand their customers. This in turn enable them to tailored their service to meet the customers expectations.
Instead of just showing tables of numbers, I have make the presentation Visual, with Charts rather than numbers. The whole process is efficient and time saving. After the initial set up, the user needs minimum effort to update and maintain this dashboard. If you have a similar requirement, perhaps you can use the ideas shown here. I would be glad to help you if you need to build such a report.
Contributed By Freddy Ng.