From the course: The Data Skills Survival Kit
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Cleaning survey data for the purposes of analysis
From the course: The Data Skills Survival Kit
Cleaning survey data for the purposes of analysis
- [Instructor] Cleaning survey data sometimes feels like a specialized skill and we definitely need to survive it. One of the key challenges of survey data is the structure of the data. It is often data we've research, but if you don't transform it, you may not be able to study it and you certainly limit your ability to visualize it. I bet Bill Shander would agree that it's not just production visuals that matter, like dashboard slides, but it's visualization that gives you the ability to dig into the insights before you get to the production level visuals. And to do that, you have to structure your data. So here's an example. We have the data related skillset and this is a raw data sample in your exercise files. So I'm just take a look at how this data is structured. So I have the original question, okay? And then I have a line that gives me things like response and then I have the answer. So, okay, how long have…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
- Ex_Files_Data_Skills_Survival_Kit_2022_Q4.zip
- Ex_Files_Data_Skills_Survival_Kit_2023_Q1.zip
- Ex_Files_Data_Skills_Survival_Kit_2023_Q2.zip
- Ex_Files_Data_Skills_Survival_Kit_2023_Q3.zip
- Ex_Files_Data_Skills_Survival_Kit_2023_Q4.zip
- Ex_Files_Data_Skills_Survival_Kit_2024_Q1.zip
- Ex_Files_Data_Skills_Survival_Kit_2024_Q2.zip
- Ex_Files_Data_Skills_Survival_Kit_2024_Q4.zip
- Ex_Files_Data_Skills_Survival_Kit_2025_Q2.zip
- Ex_Files_Data_Skills_Survival_Kit_2025_Q3.zip
- Ex_Files_Data_Skills_Survival_Kit_2025_Q4.zip
Contents
-
-
-
-
-
-
- (Locked) Using Unpivot to build data sets from survey results8m 38s
- (Locked) Cleaning data from a PDF in Power BI6m 7s
- (Locked) Duplicate vs. reference in Power Query7m 19s
- (Locked) Cleaning data from a folder of files in Power BI4m 10s
- (Locked) Build conditional functions to make data15m 26s
- (Locked) Creating tables and joins to recode data8m 29s
- (Locked) Merging data and building basic calculations into a data set10m 13s
- (Locked) Mapping data into other software tools12m 52s
- (Locked) Creating subgroups for use in visuals and basic analysis12m 12s
- (Locked) Cleaning survey data for the purposes of analysis14m 29s
- (Locked)
-
-
-
-
-
-