Using Joins and Update Queries to Create Valuable Markers
Using Joins and Update Queries to Create Valuable Markers in the data
Joins can provide you a valuable way to link information, but they can also be used to create valuable markers or fields in your data when you don’t have a field already to use. Learn how to mark data set information based on other tables and update statements.
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.