In today’s data-driven world, effectively collecting, cleaning, and visualizing survey data is crucial for evaluators and analysts alike. This workshop dives deep into the essentials of quantitative data management, equipping you with the tools needed to transform raw data into actionable insights.

Throughout this hands-on workshop, you’ll explore how to leverage popular platforms like Google Forms and Microsoft Forms for survey data collection. You’ll also master essential techniques in Excel for cleaning your datasets and applying tailored visualization techniques that allow your findings to stand out and drive decision-making.

 

What You’ll Learn

• Data Collection with Excel: Explore how to build a data collection template in Excel that includes data validation features such as locked cells, predetermined data formats, and warnings that data have been entered incorrectly.

• Data Collection with Survey Platforms: Learn how to design and distribute surveys using platforms like Google Forms and Microsoft Forms, ensuring accurate and efficient data collection.

• Data Cleaning in Excel: Master essential techniques to clean and prepare survey data for analysis, from handling missing values to organizing and transforming raw data for clarity and precision.

• Survey-Specific Visualizations: Create customized charts and graphs in Excel, specifically designed for survey data, ensuring your insights are clear, meaningful, and ready for reporting.

•  

What You’ll Get

• 5+ hours of pre-recorded content divided into learning modules, so you can learn at a time and pace that works best for you

• Practice exercises

• Live support via an Office Hours session the week the class is released

• Lifetime access to the learning community Q+A Board, where you can give and receive data analytics support from your peers

• A Certificate of Completion

• Access to the workshop videos and materials for at least one month (longer if you join as a Silver, Gold, or Platinum Tier member!)

• Silver, Gold, and Platinum Tier members will also unlock access to our Learning Community, our dynamic, member-only support system designed to help you integrate new skills into your work through features such as weekly office hours, monthly skill sprints, a Q+A board, quarterly webinars, and exclusive access to uncut recordings on the Data Jam Podcast.

 

How it Works

The next blended delivery of this workshop will be the week of February 16, 2025. All materials will be released on Sunday. Then, join us for a live office hours session on Friday from 3-4pm EST where we will address any questions you have.

 

Why You Should Attend

This workshop is designed for evaluators, data analysts, and professionals who work with survey data and want to sharpen their skills in data collection, cleaning, and visualization. Whether you’re new to survey data management or seeking to refine your approach, this workshop will provide you with the knowledge and tools necessary to streamline your workflow and present data-driven insights effectively.

By the end of the session, you’ll have hands-on experience collecting data through popular platforms and the confidence to transform messy data into visually compelling reports that engage and inform.

 

What Past Participants Are Saying

• “This workshop helped me streamline my data collection process and made data cleaning a breeze. It’s a game changer!”

• “The hands-on approach was incredibly useful. I’m now able to create survey visualizations that communicate my findings clearly.”

•