How best to automate survey analysis? #5

Open
opened 2025-02-14 10:25:43 +01:00 by marcuskammer · 1 comment
Owner

I work as one and only UX researcher in a company that slowly transforming from a start-up to a bigger firm (100+) employees, which is probably the most painful company phase you can experience. As the only one researcher here, I need to synthetise a lot of survey data daily. I use Google Sheets, as we run on Google Workspace and I follow all the same analysis - export csv data, clean it, filter data by our segments, visualise it by bar charts... but this process is mundane and time-consuming. I'm thinking about learning Python to do it faster. Is it a good idea? Where should I start? Are there any sources that you would recommend to me? I'm a little bit burnt out and would like to have more time for something else.

https://www.reddit.com/r/UXResearch/comments/1aunbrc/how_best_to_automate_survey_analysis/

I work as one and only UX researcher in a company that slowly transforming from a start-up to a bigger firm (100+) employees, which is probably the most painful company phase you can experience. As the only one researcher here, I need to synthetise a lot of survey data daily. I use Google Sheets, as we run on Google Workspace and I follow all the same analysis - export csv data, clean it, filter data by our segments, visualise it by bar charts... but this process is mundane and time-consuming. I'm thinking about learning Python to do it faster. Is it a good idea? Where should I start? Are there any sources that you would recommend to me? I'm a little bit burnt out and would like to have more time for something else. https://www.reddit.com/r/UXResearch/comments/1aunbrc/how_best_to_automate_survey_analysis/
marcuskammer added the
enhancement
label 2025-02-14 10:25:43 +01:00
marcuskammer added the
reddit
label 2025-02-14 10:35:04 +01:00
Author
Owner

As a UX researcher in a growing company, I want to automate my data analysis process using Python, so that I can reduce time spent on mundane tasks and focus on more valuable research activities.

Acceptance Criteria:

  • Can import CSV data from Google Sheets into Python
  • Can clean and filter data by segments automatically
  • Can generate visualizations like bar charts programmatically
  • Reduces time spent on data analysis by at least 50%
  • Works seamlessly with Google Workspace

Questions for clarification:

  1. What specific data cleaning tasks do you perform?
  2. How many different types of visualizations do you typically create?
  3. Are there any security or compliance requirements for handling the survey data?
  4. Do you need to share the analysis results with others in Google Sheets format?
  5. What is your current level of programming experience?
As a UX researcher in a growing company, I want to automate my data analysis process using Python, so that I can reduce time spent on mundane tasks and focus on more valuable research activities. Acceptance Criteria: - Can import CSV data from Google Sheets into Python - Can clean and filter data by segments automatically - Can generate visualizations like bar charts programmatically - Reduces time spent on data analysis by at least 50% - Works seamlessly with Google Workspace Questions for clarification: 1. What specific data cleaning tasks do you perform? 2. How many different types of visualizations do you typically create? 3. Are there any security or compliance requirements for handling the survey data? 4. Do you need to share the analysis results with others in Google Sheets format? 5. What is your current level of programming experience?
marcuskammer added the
story
label 2025-02-14 14:33:30 +01:00
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: marcuskammer/dev.metalisp.survey#5
No description provided.