none
DQS Videos - a great succinct way to learn the basics when using DQS

    General discussion

  • Just wanted to plug the first eight video recordings that the DQS Product Team put together to train us on the basics of using SQL 2012 "Denali" Data Quality Services. What a big help to see some practical and succinct training.

    I suggest the following order to help your DQS studies. The demos go by quickly, so pause and rewind to recap a couple of times if you need to revisit a topic untill it gels in your mind.

    As more videos are added, check out these links and the RSS feed to see any upcoming video items.

     

    Here's the order I recommend. Enjoy! -Jason

    ==========
    VIDEO 1. How Do I: Install and Configure DQS?
    http://msdn.microsoft.com/en-us/sqlserver/hh323828.aspx

    SQL Server Data Quality Services (DQS) is a new feature in SQL Server “Denali” that provides you with a knowledge-driven data cleansing solution. In this video, you will learn about the prerequisites to install DQS, how to install DQS, and how to perform post-installation tasks to configure DQS. This video walks you through a basic installation where we use the SQL Server setup installation wizard to perform installation, and all the DQS components are installed on the same computer.

    ==========
    VIDEO 2. How Do I: Manage a knowledge base in SQL Server Denali DQS?

    http://msdn.microsoft.com/en-us/sqlserver/hh323825.aspx

    The DQS client application enables you to perform data quality operations using a standalone tool. To cleanse data, you have to have knowledge about the data. To prepare knowledge for a data quality project, you build and maintain a Data Quality knowledge base (KB) that DQS can use to identify incorrect or invalid data. In this video you will learn how to add knowledge through a computer-assisted process - the knowledge discovery activity - and how to add domain rules.


    ==========
    VIDEO 3. How Do I: Cleanse my data with SQL Server Denali DQS?
    http://msdn.microsoft.com/en-us/sqlserver/hh323834.aspx

    Data cleansing is the process of analyzing the quality of data in a data source, and manually applying rules and making changes to the data. Data cleansing includes a computer-assisted process that analyzes how data conforms to the knowledge in a knowledge base, and an interactive process that enables the data steward to ensure that the data cleansing includes exactly what they want done. In this demo we will learn how to use a published data quality knowledge base to cleanse our data. We will open a cleansing project, select a source file, and go through the computer-assisted cleansing process and the interactive process. In the end we will export the cleansing results.


    ==========
    VIDEO 4.  How Do I: Cleanse my data with SQL Server Denali SSIS DQS Cleaning Component?
    http://msdn.microsoft.com/en-us/sqlserver/hh323819.aspx

    Many real-world scenarios require running cleansing as a batch process. The DQS Cleansing component in SQL Server Integration Services addresses these scenarios. In this video, we will learn how to define and use the DQS Cleansing component in a SSIS data flow. Please note: familiarity with SSIS is a prerequisite for understanding this video.

    ==========
    VIDEO 5. What is a Composite Domain and How Do I use it to cleanse my data with SQL Server Denali DQS?

    http://msdn.microsoft.com/en-us/sqlserver/hh323742.aspx

    Data contains different types of data types: some are simple and stand alone, and some are composite and are more meaningful when grouped together. A composite domain enables you to group together individual domains that represent common data. For example, addresses can contain house number and street name, city, state, and Zip Code, and names of people can contain title, first name, last name, and gender. In this demo, we will learn how to create a composite domain, how to create business rules for composite domains, and how to use a composite domain to cleanse data.

    ==========
    VIDEO 6. How Do I: Cleanse my data with SQL Server Denali Data Quality Services (DQS) and Data Market Reference Data Service (RDS) Provider?
    http://msdn.microsoft.com/en-us/sqlserver/hh510077.aspx

    There are various reference data providers today with different types of reference data, such as address data, company data, Geocoding, etc. These providers can help you cleanse and enrich your data easily using DQS and the DataMarket Reference Data service provider. Instead of building and maintaining your own knowledge, you can use external knowledge to cleanse the data. You can attach a DQS domain or a DQS composite domain to a DataMarket reference data service provider and use it to cleanse and enrich your data. In this video we will learn how to configure, and then use, the Reference Data Services feature in SQL Server Data Quality Services (DQS) to cleanse your data.

    ==========
    VIDEO 7. How Do I: Create a Matching Policy with SQL Server Denali DQS?
    http://msdn.microsoft.com/en-us/sqlserver/hh323803.aspx

    Data matching analyzes your data and groups matching records. The challenge for a matching system is to overcome errors and variations that naturally exist in the data and across different data sources. DQS can help you create rules that will identify matching records in a controlled and interactive fashion. In this demo we will learn how to create a matching policy in a knowledge base that we created earlier.

    ==========
    VIDEO 8.How Do I: Match my Data with SQL Server Denali DQS?
    http://msdn.microsoft.com/en-us/sqlserver/hh323741.aspx

    Data matching analyzes your data and clusters matching records. The challenge for a matching system is the degree to which it can understand and overcome the errors and variations that naturally exist in the data and across different data sources. DQS helps you identify and remove duplicate records from your data in a guided and easy way. In this demo we will learn how to use the matching policies defined in the knowledge base that we created in the previous video to match your data in a data quality project.
    ==========

     

     


    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
    Saturday, November 05, 2011 6:50 AM
    Moderator

All replies

  • Jason,

    I guess other than SSIS and DQS client there must some APIs that would enable the use of DQS services. Can you please provide pointers to any samples or demos related to this?

    Regards,

    Sri Meda

    Monday, January 09, 2012 4:18 PM
  • The DQS APIs are not available for consumption in this release.  I imagine they can be reverse engineered (most of .Net is that way with reflection), but those APIs are not supported for now. I think the product team is aware of the interest in the DQS APIs and will consider it for future plans.

    Thanks, Jason


    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance
    Monday, January 09, 2012 7:44 PM
    Moderator
  • Thank you Jason. May be an imporper forum to ask but can you please help me on the below question.

    Can we use SQL server analysis services TABULAR as data source in Report Builder 3.0? I could create one successfully but when tried creating a dataset I got an error to install DAX extension which I could not find. Any pointers to the extension will be highly helpful.

    Regards,

    Sri Meda

    Monday, January 09, 2012 8:19 PM