Create an excel pivot table to display survey results using filters.
- or -
Post a project like this2485
$$
- 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 collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies