|
|
|
|
|
|
Date:
|
10/10/2012
|
|
Start Time:
|
12:00:00 PM
|
|
End Time:
|
1:00:00 PM
|
|
Timezone:
|
(GMT-05:00) Eastern Time (US & Canada)
|
|
|
|
|
|
Dealing with bad data is a painful and expensive experience. In this session, we explore the main causes of bad data and layout key data quality concepts that will helps us better understand how data quality issues can be very costly. Then, we will jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with SQL Server Data Quality Services (DQS) and Integrations Services (SSIS). We will dive into DQS knowledge-driven approach, reusability, cleansing and matching, and explore the collaboration opportunities between data stewards and IT professionals. You will demonstrate how to create a knowledge base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component.
|
|
|
|
|
WED 10/10 12pm EDT
Waiter, There's a Fly in My Data
Speaker: Rafael Salas
Dealing with bad data is a painful and expensive experience. In this session, we explore the main causes of bad data and layout key data quality concepts that will helps us better understand how data quality issues can be very costly. Then, we will jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with SQL Server Data Quality Services (DQS) and Integrations Services (SSIS). We will dive into DQS knowledge-driven approach, reusability, cleansing and matching, and explore the collaboration opportunities between data stewards and IT professionals. You will demonstrate how to create a knowledge base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component.
Rafael is a recognized speaker, published authored and blogger with more than a decade of relevant IT experience across multiple industries. He specializes in Business Intelligence and information architecture and is the recipient of multiple industry awards, including Microsoft Most Valuable Professional and The Data Warehouse Institute best practices, as recognition of his expertise and high quality of the solutions he and his team have built. His Areas of expertise include data integration and data quality, data warehouse architecture, data analytics, data modeling and data visualization. Rafael is also an active member in the SQL Server technical community and maintains a blog at www.rafael-salas.com.
|
|
|
|
|
Community Webcast
|
|
|
|
|
|
Return To Events
|
|