Videos

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...
A woman wearing a purple shirt is engaged in networking conversations within the tech industry.

Networking in Tech

We’re continuing our series with a lesson on networking. Watch this Meetup Live recording with...
When data gets scary, explore the fundamentals that unpack it.

DFU: When Data Gets Scary

***For best viewing experience log in to LinkedIn*** October 25, 2022 - Oz du Soleil...