Create an excel pivot table to display survey results using filters.
- or -
Post a project like this1843
$$
- Posted:
- Proposals: 8
- Remote
- #1564817
- Awarded
Description
Experience Level: Intermediate
We are in the process of creating a survey that analyses consumers buying habits.
The survey will contain between approx. 20 product purchased questions (e.g. type of product, model number, where did you buy this product or where did you first see this product) as well as a number of key demographics (e.g. age, gender, region, home tenure and marital status).
We want to be able to upload the data to the excel file with the pivot table once a month and refresh results, thus allowing the user to view the latest statistics.
We then want the user to be able to click on multiple selections to drill down further. For example, you might want to see the results of people who live in the North East of England, are aged between 45-54 and purchased their product from Amazon.
It would be good to have charts but raw numbers and percentages are probably more important of the two.
-I have attached something we have put together on the back of watching a 15 minute Yu Tube video which shows at least the direction we are travelling in. We know it can be done much better.
The survey will contain between approx. 20 product purchased questions (e.g. type of product, model number, where did you buy this product or where did you first see this product) as well as a number of key demographics (e.g. age, gender, region, home tenure and marital status).
We want to be able to upload the data to the excel file with the pivot table once a month and refresh results, thus allowing the user to view the latest statistics.
We then want the user to be able to click on multiple selections to drill down further. For example, you might want to see the results of people who live in the North East of England, are aged between 45-54 and purchased their product from Amazon.
It would be good to have charts but raw numbers and percentages are probably more important of the two.
-I have attached something we have put together on the back of watching a 15 minute Yu Tube video which shows at least the direction we are travelling in. We know it can be done much better.

Simon W.
100% (1)Projects Completed
3
Freelancers worked with
3
Projects awarded
100%
Last project
13 Jun 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy