Sub-Total: $0.00
Cleaning Survey Data for the Purposes of Analysis
Learn how to fix messy text data with a simple control table in Power Query. In this Data Survival Skills session, Robin demonstrates how to take inconsistent survey responses—like multiple spellings of the same tour name—and map them to one clean, official list. By walking through step-by-step examples, she shows how to remove duplicates, create a control table, and use a join to apply corrections across the entire dataset. You’ll also see how to quickly rebuild a clean pivot table that delivers accurate results. This method helps you save time, avoid manual fixes, and keep your reports consistent.
#PowerQuery #Excel #DataCleaning #SurveyData #BusinessIntelligence #DataAnalytics #MicrosoftPowerQuery
If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.