Sub-Total: $0.00
Using anti joins to search for data
Learn how to search for specific data across multiple lists of information. In this Data Survival Skills session, Robin loads customer records and website leads into Power Query, lines up the fields, and merges the lists. Using an anti-join, she can instantly see which customers do or don’t have a matching website lead, making it easy to pinpoint exactly the information she’s looking for. Perfect for tracking leads, analyzing customer info, and getting clear answers from messy data.
#MicrosoftExcel #PowerQuery #DataMerging #DataTransformation #DataCleaning #AntiJoin #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.