This blog provides information, news, tips, and announcements about the SQL Server Data Quality Services (DQS) feature introduced in SQL Server 2012.
I’ve been getting many requests to publish the files and KBs used in the DQS TechEd presentation (available here).
So I know it’s a bit late, but still – here it is…
For those of you who haven’t viewed the presentation yet - the high level story is about a major service provider for professional sports team in the US.
Joe, a data analyst in that company, gets up one morning and looks at the sports sales report from the last quarter, and sees a big mess – sports types contain duplicates, team names are spelled wrong, and even the types of revenue are all jumbled (see pics below).
So he wants to clean the data with DQS (see more details in the recording).The relevant files for this demo are attached:
To run the full scenario, just do the following:
I hope you find the demo data useful, in one of the next posts were going to introduce you to the DQS matching functionality.
Elad (The DQS Team)
Thanks for the samples!