Videos

A woman working on a computer.

Creating aggregated datasets

Creating aggregated datasets  Creating aggregate data sets is vital for effective data analysis and decision-making....
A woman working on a computer.

Using Functions to Mask Data

Using Functions to Mask Data Exploring Different methods to mask data for privacy (because data...
A woman working on a computer.

Model or Merge- and what’s the difference? 

Model or Merge- and what's the difference?  You may wonder, "When is it best to...
Data on a single topic is normalized in a separate table, which other tables reference.

Normalizing data to achieve a data design

Normalizing data to achieve a data design Normalizing data is typically the skill of a...
Unlocking data fundamentals for portfolio building opportunities.

DFU: Finding portfolio building work

***For best viewing experience log in to LinkedIn*** March 13, 2023 - A portfolio is...
A screen shot of a window showing the settings for Microsoft Outlook and working with full outer joins.

Working with full outer joins

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

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

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 

Creating unique identifiers between two data sets When a join is required, and the field...
Data-Driven Decision Making unpacked - episode 12.

DFU: Data-Driven Decision Making

***For best viewing experience log in to LinkedIn*** November 22, 2022 - Today's episode is...