Categories: Events

Webinar: Enhancing Your ETL Pipelines with Custom Data Cleansing and Matching

At Tuesday the 13th of December, I give a webinar about Unison, a self-service online data quality tool of Melissa Data. This is a 30-minute webinar, sponsored by Melissa and hosted by MSSQLTips.com. It’s a demo-driven webinar, where I’ll introduce this new tool and highlight its capabilities.

The abstract:

Bad or missing data can lead to huge costs for your company. However, implementing solutions to cleanse the data can be difficult and time-consuming. There are components available for SQL Server Integration Services, so you can automate the data cleansing processes. But what if these processes change often? What if your data input changes often? What if there’s no developer available to build or manage all those SSIS packages?

With Unison from Melissa Data, the data cleansing and matching can be performed by DBAs, Developers and the Data Stewards who know and own the data. Through an easy-to-use interface, you can create custom data cleansing and matching processes.

In this 30-minute webinar, we’re going to introduce you to this tool and show you how this can be used with your SQL Server data and cover:

  • Verifying data.
  • Easy address and name verification.
  • Deduplicating data by advanced matching algorithms. This also supports finding “the golden record”.
  • Data Profiling. Gather statistics about your data set in just a few clicks.
  • Standardized and repeatable approach accessible to many professionals in the organization.

At the end of the webinar, you’ll have a good understanding of how Unison can help you enhance and enrich your data.

For more info and registration, check out the MSSQLTips.com website.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Recent Posts

Power BI PBIR Format Admin Setting

The Power BI Enhanced Report Format (PBIR) will soon become the default, and that's a…

7 days ago

Logged in as a member of an Azure AD Group Error while Deploying DACPAC

Quite a long title for a short blog post :)While deploying a DACPAC (from a…

2 weeks ago

Export a Power BI Report that cannot be Downloaded

Yes, you're reading that right, we're going to download a report that cannot be downloaded.…

3 weeks ago

dataMinds Connect 2025 – Slides & Scripts

You can find all the session materials for the presentation "Indexing for Dummies" that was…

2 months ago

Cloud Data Driven User Group 2025 – Slides & Scripts

The slidedeck and the SQL scripts for the session Indexing for Dummies can be found…

2 months ago

Retro Data 2025 – Slidedeck

You can find the slides of my session on the €100 DWH in Azure on…

2 months ago