Microsoft Business Intelligence & Big Data User Group of NYC presents: SQL 2012 - Building Better BI w. DQS (or Fighting GIGO w. Knowledge)
Monday, July 8, 2013 from 6:00 PM to 8:30 PM (EDT)
SQL 2012 - Building Better BI w. DQS (or Fighting GIGO with Knowledge)
Data Quality challenges were discovered when the first Data Warehouse went into production back in the 1970s. Now, almost 40 years later most DW & BI projects are still plagued by it. GIGO (garbage in – garbage out) is one of the biggest concerns for customers and without a framework for sifting out bad & unreliable data, their confidence in BI systems can be very low.
Data Quality Services (DQS) is a knowledge-driven solution, focusing on creation and maintenance of a Data Quality Knowledge Base (DQKB) that is reused for performing various data quality operations, such as data cleansing and matching. The main concept behind DQS is a rapid, easy-to-deploy, and easy-to-use data quality system that can be set up and used practically in minutes.
In this session we’ll review the fundamentals of DQS and build our own Knowledge Base from scratch. We’ll train this knowledgebase (i.e. use Machine Learning) to discover data in our source systems and create rules and domains to define what the outcome data should look like. We’ll also hook into the cloud to leverage Melissa Address Verification Reference Service. In addition, we’ll see how this knowledgebase can be reused over time with SQL Server Integration Services (SSIS) and expanded by data stewards as new data standards and domains are introduced into the DW.
Presenter: Stanislav Novoseletskiy, Microsoft
Stan is a Principal Platform Specialist for Microsoft’s State & Local Government customers. He specializes in SQL & BI Solutions and it’s his job to ensure customer planning and deploying SQL 2012 see the highest ROI by taking advantage of platform capabilities to address business and technical problems. During his career he’s done everything from computer helpdesk back in 1997 to networking and MS Access development in 1999 to .NET & SQL programming 2000’s. After joining Microsoft in 2006 he’s focused on architecting, deploying and supporting enterprise database solutions as well as delivering data warehousing and BI projects.
7-8-2013 6:00 P.M. – 8:30 P.M.
Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104
When & Where
Microsoft Business Intelligence and Big Data User Group of New York City
A community dedicated to the development of expertise in Microsoft BI technologies and related third party products.