Hello,
I have raw data for survey results that we collect on a regular basis. We collect these survey results from our customers on our move services, and we need to analyze the data and report it to our leaders in a way that is easy to understand and tells us how we're performing and show us where/how we can improve.
We send the same survey for all of our moves - group moves and individual moves - and add the raw data for each survey onto one master spreadsheet. We need to report on a monthly basis, and probably quarterly and yearly as well. This survey is ongoing, and we need to report regularly. It is not a one-time occurrence.
The survey has 5 questions that asks for a score of 1-5 and includes a place for comments.
We would like to present the data in buckets (histogram) of how many answered between 1-1.9, 2.0-2.9, 3.0-3.9, etc., for example, for each question. We would also like to present the comments in some way, too, if possible. We would like to have the ability to filter based on move type, work order #, and month.
The raw data has many columns, some of which are columns for each question (scroll to the right). There is a column for work order # and another column for move type (group or individual). The score (1-5) is in the cell (rows) of the question columns. Please see attached example sheet for reference.
- Summary -
-Objective: present survey results in an easy-to-understand fashion and in a way that is meaningful and helpful
-We collect and report these results on an ongoing basis
-We need to filter based on move type, work order #, and month
My colleague has created simple histogram charts, but we're wondering:
1. How does the data need to be set up so that we can create this histogram?
2. Is there a way to create a histogram in Power View? or Power BI?
3. Is there a better way to present the results to achieve our objective?
Please help! Thank you much!
Bookmarks