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...

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...

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...

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...