Overview
1 Day $1,100
This one-day Microsoft training course will teach students how to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Lesson 1: Overview of Data Warehousing
- The Business Problem
- What is a Data Warehouse?
- Data Warehouse Architectures
- Components of a Data Warehousing Solution
- Data Warehousing Projects
- Data Warehousing Project Roles
- SQL Server as a Data Warehousing Platform
Lesson 2: Considerations for a Data Warehouse Solution
- Data Warehouse Database and Storage
- Data Sources
- Extract, Transform, and Load Processes
- Data Quality and Master Data Management
Lab: Exploring a Data Warehousing Solution
Lesson 1: Introduction to Data Quality
- What Is Data Quality, and Why Do You Need It?
- Data Quality Services Overview
- What Is a Knowledge Base?
- What Is a Domain?
- What Is a Reference Data Service?
- Creating a Knowledge Base
- Demonstration: Creating a Knowledge Base
Lesson 2: Using Data Quality Services to Cleanse Data
- Creating a Data Cleansing Project
- Viewing Cleansed Data
- Demonstration: Cleansing Data
- Using the Data Cleansing Data Flow Transformation
Lab A: Cleansing Data
Lesson 3: Using Data Quality Services to Match Data
- Creating a Matching Policy
- Creating a Data Matching Project
- Viewing Data Matching Results
- Demonstration: Matching Data
Lab B: Deduplicating Data
Lesson 1: Introduction to Master Data Services
- The Need for Master Data Management
- What Is Master Data Services?
- Master Data Services and Data Quality Services
- Components of Master Data Services
Lesson 2: Implementing a Master Data Services Model
- What Is a Master Data Services Model?
- Creating a Model
- Creating Entities and Attributes
- Adding and Editing Members
- Demonstration: Creating a Master Data Services Model
- Editing a Model in Microsoft Excel
- Demonstration: Editing a Model in Excel
Lesson 3: Managing Master Data
- Hierarchies and Collections
- Creating Derived Hierarchies
- Creating Explicit Hierarchies
- Creating Collections
- Finding Duplicate Members
- Validating Members with Business Rules
- Demonstration: Creating and Applying Business Rules
Lesson 4: Creating a Master Data Hub
- Master Data Hub Architecture
- Master Data Services Staging Tables
- Staging and Importing Data
- Demonstration: Importing Master Data
- Consuming Master Data with Subscription Views
- Demonstration: Using Subscription Views
Lab: Implementing Master Data Services
This course is intended for database professionals who need to support a data warehousing solution. Primary responsibilities include:
Before attending this course, students must have:
- At least 2 years' experience working with relational databases.
- Some exposure to basic programming constructs (such as looping and branching).
- An awareness of key business priorities
