Sub-Total: $0.00
Creating tables and joins to recode data
Discover how to clean up messy text fields and make your data consistent. In this Data Survival Skills session, Robin teaches how to create a control table and use joins to recode survey data with lots of different spellings for the same thing. Instead of writing endless replace commands, you’ll learn how to build the table, map incorrect entries to the right names, merge it into your dataset, and instantly clean thousands of records. This approach ensures your pivot tables and reports are accurate, reliable, and ready for analysis.
#PowerBI #Excel #DataCleaning #DataPreparation #DataAnalysis #DataTransformation #DataSkills #BusinessIntelligence
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.