Date: 2025-01-14 Page is: DBtxt003.php txt00005062 | |||||||||
Peter Burgess Contacts ... NYMeetups | |||||||||
Burgess COMMENTARY | |||||||||
Welcome to New York Business Intelligence
Peter Burgess Info
Short Bio
What industry am I most involved with
How am I involved with BI
What BI topics interest me
How did I learn about the BI meetup group
SQL 2012 - Building Better BI w. DQS (or Fighting GIGO with Knowledge) Print ticket Export Tell a friend Share Monday, July 8, 2013 6:00 PM to 8:30 PM Microsoft Offices, 6th floor 1290 Avenue of the Americas between 51st and 52nd Streets New York, NY (map) 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. |