Using anti joins to search for data
We know that data sets cannot be achieved efficiently without adjusting joins so we learn about left and right joins. Then as we produce these results sometimes we are only looking for the null value. So then we spend time by filtering for null values. We will learn how to create data sets with anti joins to create filtering joins to produce data sets that show missing values from tables we select.
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.