Creating unique identifiers between two data sets 

Learn how to seamlessly connect datasets—even when key fields are missing. In this Data Survival Skills session, Robin walks through importing, cleaning, and merging data in Power Query, showing how to create unique identifiers and bring mismatched sources together. Perfect for turning messy data into one clear story.

 

 #MicrosoftExcel #PowerQuery #DataMerging #DataTransformation #DataCleaning #UniqueIdentifiers #DataAnalysis #ExcelTips #SpreadsheetTools #DataIntegration #DataSkills 

Excel data import options menu displayed.
Plant data table in Power Query Editor. Unique identifiers
Spreadsheet displaying plant data and queries. unique identifiers
Power Query editor merging plant product tables. Unique Identifiers.
Power Query Editor displaying plant product data. unique identifiers

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.

Watch the Series Intro Today

Note: Because this is an ongoing series, viewers will not receive a certificate of completion.