Daniel Bishop Honored

congratulatory message for Daniel Bishop

Daniel Biship Honored40 under 40 Daniel Bishop, Cofounder and Lead Software Architect, has been added to the most current class of Top 40 Under 40. This is one of the more coveted honors locally for young professionals. Daniel began his technical journey years before founding ThinkData Solutions, Inc. We are not surprised to see him…

Read More

Using anti joins to search for data

A screen displaying the settings for a Microsoft Excel spreadsheet, utilizing anti joins to search for data.

Using anti joins to search for data We know that data sets cannot be achieved efficiently without adjusting joins so we learn about left and right joins. Then as we produce these results sometimes we are only looking for the null value. So then we spend time by filtering for null values. We will learn…

Read More

Joining data with common data between two unrelated data sets

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 is part of the life of a data analyst. The problem is that most data sets that need to be joined exist in different systems. This means there isn’t a direct relationship we can establish using a key from the data system. We…

Read More