Apr 2015 – Konstantin Khomyakov – April QLD SQL Server User Group

April QLD SQL Server User Group – Konstantin Khomyakov

Data Quality Services Deep Dive

Data Quality Services (DQS) is one of the main mechanisms for data normalization, removing duplicate content and filling knowledge base. It allows you to perform various operations to obtain quality data. The main feature is the creation of the knowledge base, in which there are basic configuration, data manipulation rules. DQS Cleansing is the standard SSIS control, which is used for normalization (cleansing) data. In this session two new controls will be introduced: DQS Domain Value Import and DQS Matching Transformation. During the session SSIS package will be created. This package will automate the process of importing domain entities, including synonyms, to the existing kno…wledge base. Also mechanism for removing duplicates will be applied, relying on returned weights coefficients compared between each set of records.

In this session two new controls will be introduced: DQS Domain Value Import and DQS Matching Transformation. During the session SSIS package will be created. This package will automate the process of importing domain entities, including synonyms, to the existing knowledge base. Also mechanism for removing duplicates will be applied, relying on returned weights coefficients compared between each set of records.

About the Speaker

Konstantin Khomyakov specializes in in Microsoft SQL Server Business Intelligence. Key areas of interest are: Integration Services (SSIS), Analysis Services (SSAS), Data Quality Services (DQS) and Master Data Services (MDS). His consulting focuses on all aspects of Microsoft Business Intelligence stack from architecture design and implementation planning to installation and support of the product. Konstantin is an active member in the SQL Server community, presenting technical sessions at SQL Saturday and PASS events both in Australia and Overseas. Konstantin is a SQL Server Microsoft Most Valuable Professional recognised for his technical excellence and his ongoing commitment to the Microsoft SQL Server community.

Venue: Microsoft Brisbane – Level 28, 400 George Street, Brisbane Duration: Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM)
On: Thursday, 23rd April 2015
RSVP: to contact@wardyit.com to help with catering
To Register. Click here

WARDY IT Solutions

WARDY IT Solutions - Australia's leading SQL Server consultants, trainers and Business Intelligence specialists. WARDY IT Solutions has established itself amongst the top solution providers in SQL Server technologies providing solutions for customers throughout Asia Pacific.