Skip Main Navigation
Page Content
This event has ended

Microsoft Business Intelligence & Big Data User Group of NYC presents: SQL 2012 - Building Better BI w. DQS (or Fighting GIGO w. Knowledge)

Microsoft Business Intelligence and Big Data User Group of New York City

Monday, July 8, 2013 from 6:00 PM to 8:30 PM (EDT)

Microsoft Business Intelligence & Big Data User Group...

Ticket Information

Type End Quantity
Attendee Ended Free  

Share Microsoft Business Intelligence & Big Data User Group of NYC presents: SQL 2012 - Building Better BI w. DQS (or Fighting GIGO w. Knowledge)

Event Details

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.

Date/Time:

7-8-2013 6:00 P.M. – 8:30 P.M.

Location:  

Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104

Have questions about Microsoft Business Intelligence & Big Data User Group of NYC presents: SQL 2012 - Building Better BI w. DQS (or Fighting GIGO w. Knowledge)? Contact Microsoft Business Intelligence and Big Data User Group of New York City

When & Where


Microsoft NYC Offices
1290 6th Avenue
New York, NY 10104

Monday, July 8, 2013 from 6:00 PM to 8:30 PM (EDT)


  Add to my calendar

Organizer

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.

  Contact the Organizer

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.