Sub-Total: $0.00
Joining data with common data between two unrelated data sets
Unlock the secret to joining two completely unrelated datasets by finding and creating common data. In this Data Survival Skills video, Robin shows how to build a unique key field in Power Query—using techniques like value replacement, column splitting, and formatting—so you can merge sources flawlessly and avoid common linking errors. #MicrosoftExcel #PowerQuery
#DataMerging #DataTransformation #DataCleaning #UniqueKey #DataAnalysis #ExcelTips #SpreadsheetTools #DataIntegration #DataSkills
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.