Data Survival Skills

A screen shot of a window showing the settings for Microsoft Outlook and working with full outer joins.

Working with full outer joins

March 2, 2023
Working with full outer joins Often times we find as data workers we are trying...
Data Survival Skills / Joining Data / Training / Videos
A screen displaying the settings for a Microsoft Excel spreadsheet, utilizing anti joins to search for data.

Using anti joins to search for data

February 16, 2023
Using anti joins to search for data We know that data sets cannot be achieved...
Data Survival Skills / Joining Data / Training / Videos
The goal is to join data with common data between two unrelated data sets, ensuring one list has an established key and incorporating that key into the other lists.

Joining data with common data between two unrelated data sets

February 2, 2023
Joining data with common data between two unrelated data sets Joining data is part of...
Data Survival Skills / Joining Data / Training / Videos
When we are missing a key field, we have to determine how to join the data by creating unique identifiers between two data sets.

Creating unique identifiers between two data sets 

January 19, 2023
Creating unique identifiers between two data sets When a join is required, and the field...
Data Survival Skills / Joining Data / Training / Videos

Archives