Google Looker Studio Report for Survey
Budget: $30 – $250 USD
I have recently conducted a survey and I'm looking for a skilled freelancer to put the data into a Google Looker Studio Report for me. The survey asked 1129 people to rank a set of 25 issues in order of importance. I want the Report to present, as a default, the list of issues ranked by order of importance. I should then be able to sort the list according to the available demographic data (age, race, region, and location).
As an example, this was the report from the last time we ran this survey: https://lookerstudio.google.com/reporting/178d368f-0e52-4b95-ba3c-e3a4447558f7
- Please use the same age groups, i.e.:
18-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80+
Key Points:
- The report should be visually appealing and easy to interpret and use bar charts (again, see the previous Report linked above, you just need to do something similar to that Report).
- The survey data is currently housed in Google Sheets, so prior experience with this format is a plus.
- Your role will be to translate the raw data into a comprehensive Report that can be used for analysis.
- The report should allow for easy filtering and sorting of data based on the selected demographic factors.
- The ranking of results should be done by simply assigning each rank a score (#1 = 25 points, #2 = 24 points, and so on until #25 = 1 point), adding up all the points, and then dividing by the total number of respondents.
- I should also be able to see how many people chose a specific issue at a specific rank, e.g. how many people ranked "Healthcare" at #5.
- (optional) I would like to be able to do this survey again in the future, so if possible please build the Report so that I can simply make a copy and point the copy to a new Google Sheet to analyse the new sheet. Please assume a new Google Sheet will have the same demographic data (age, race, region, location) BUT may have more or fewer issues.
Ideal Skills/Experience:
- Proficiency in Google Looker Studio and Google Sheets.
- Strong data visualization skills, with a focus on bar chart creation.
- Previous experience in working with demographic data and sorting it for analytical purposes.
- Good understanding of survey data and its interpretation.
- Ability to deliver efficient, well-structured reports.
As an example, this was the report from the last time we ran this survey: https://lookerstudio.google.com/reporting/178d368f-0e52-4b95-ba3c-e3a4447558f7
- Please use the same age groups, i.e.:
18-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80+
Key Points:
- The report should be visually appealing and easy to interpret and use bar charts (again, see the previous Report linked above, you just need to do something similar to that Report).
- The survey data is currently housed in Google Sheets, so prior experience with this format is a plus.
- Your role will be to translate the raw data into a comprehensive Report that can be used for analysis.
- The report should allow for easy filtering and sorting of data based on the selected demographic factors.
- The ranking of results should be done by simply assigning each rank a score (#1 = 25 points, #2 = 24 points, and so on until #25 = 1 point), adding up all the points, and then dividing by the total number of respondents.
- I should also be able to see how many people chose a specific issue at a specific rank, e.g. how many people ranked "Healthcare" at #5.
- (optional) I would like to be able to do this survey again in the future, so if possible please build the Report so that I can simply make a copy and point the copy to a new Google Sheet to analyse the new sheet. Please assume a new Google Sheet will have the same demographic data (age, race, region, location) BUT may have more or fewer issues.
Ideal Skills/Experience:
- Proficiency in Google Looker Studio and Google Sheets.
- Strong data visualization skills, with a focus on bar chart creation.
- Previous experience in working with demographic data and sorting it for analytical purposes.
- Good understanding of survey data and its interpretation.
- Ability to deliver efficient, well-structured reports.