Jan 22
Webinar: How to Capitalize on Power BI's Latest Features
Location: Online

In our webinar, one of our data experts will take you through the new features in Power BI desktop’s most recent release and why they matter. Stick around afterward for a Q&A where we will answer any questions you have about Power BI. 


Back to List

Jared Kuehn is Speaking at FoxPASS

 
Date: Sep 05 3:30 PM - Sep 05 5:30 PM
Location: 4351 W College Ave Appleton, Wisconsin
Skyline's Jared Kuehn is the featured speaker at September's FoxPASS meeting where he will be presenting, "When Low-Quality Data Strikes: Fuzzy Tools Provide Clarity in Matching and Deduplication".

Summary: You have a high-quality dataset, appropriately keyed, groomed, and trusted by business users. Then you're asked to merge in a new, low-quality dataset. It may contain a different key structure, numerous text fields with typos, or optional fields that are empty on most records. How would you find as many accurate matches as possible? You can define multiple matching algorithms to handle the various discrepancies you find, but it can be difficult and time consuming to prevent missing matches. In this session, I will showcase how you can solve problems like this using the fuzzy tools natively available in SQL Server. I will explain how a fuzzy approach compares to other options such as exact match algorithms, weighing the pros and cons. Finally, I will demonstrate how to set up the groundwork to incorporate fuzzy tools into a data flow solution. By the end of this session, you should have another tool in your toolbelt that can aid you in any matching or data deduplication scenario.

RSVP today!

About Jared: Jared has worked in the Business Intelligence industry for over 5 years, primarily in warehouse development and reporting solutions. He has acquired a MCSE certification in Business Intelligence and continues to do research in the realm of fuzzy logic. He's served in multiple industries including Healthcare, Higher Education, Insurance and Retail. He firmly believes in not only learning new technologies, but sharing knowledge with one another to grow together. In his spare time, he enjoys spending his time performing in musical groups and theater productions, nerding out with video games, or spending time with his family.

FoxPASS is THE SQL Server community in northeast Wisconsin. The group provides education, networking, and support to all SQL Server professionals - DBAs, developers, BI, and more.