Description
This course covers advanced design topics related to dimensions and partitions. It explains how to utilize Analysis Services features for parent-child hierarchies, financial analytics, referenced dimensions and many-to-many relationships. It also demonstrates how to work with write back in Analysis Services for both dimensions and cells. In addition, this course provides guidance for managing Analysis Services performance and storage through the implementation of aggregations and partitions. Furthermore, this course expands topics introduced in the Analysis Services Fundamentals course by explaining how to manage design and data changes following initial implementation and how to implement alternative security scenarios. The features and demonstrations in this course focus on the SQL Server 2008 R2 release, although most topics also apply to all versions of Analysis Services (SQL Server 2005 and later).
Course Curriculum
00.Data Warehousing Packages, Part I | |||
0000.Introduction | 00:00:00 | ||
0001.Introduction to Data Warehousing | 00:00:00 | ||
0002.Dimensional Modeling | 00:00:00 | ||
0003.Data Profiling | 00:00:00 | ||
0004.Demo Data Profiling | 00:00:00 | ||
0005.ETL Design Patterns | 00:00:00 | ||
0006.Extract Package | 00:00:00 | ||
0007.Demo Extracting to Staging Tables | 00:00:00 | ||
0008.Load Patterns | 00:00:00 | ||
0009.Fact Extract for Ongoing Load | 00:00:00 | ||
0010.Demo Extracting Records since Last Load | 00:00:00 | ||
0011.Summary | 00:00:00 | ||
01.Data Warehousing Packages, Part II | |||
0100.Introduction | 00:00:00 | ||
0101.Slowly Changing Dimensions | 00:00:00 | ||
0102.Dimension Load Patterns Type 0, Type 1, and Type 2 | 00:00:00 | ||
0103.Dimension Load Package | 00:00:00 | ||
0104.Demo Transforming and Loading Data for Type 0 | 00:00:00 | ||
0105.Demo Loading Data with The Slowly Changing Dimension Wizard | 00:00:00 | ||
0106.Fact Table Design Patterns | 00:00:00 | ||
0107.Demo Performing ETL for A Fact Table | 00:00:00 | ||
0108.Demo Selecting Data for Ongoing Fact Table Load | 00:00:00 | ||
0109.Analysis Services Objects | 00:00:00 | ||
0110.Demo Using The Analysis Services Task | 00:00:00 | ||
0111.Demo Orchestrating The ETL Process | 00:00:00 | ||
0112.Summary | 00:00:00 | ||
02.Data Cleansing | |||
0200.Introduction | 00:00:00 | ||
0201.Data Flow and Data Quality | 00:00:00 | ||
0202.Column Problems Missing Data Default | 00:00:00 | ||
0203.Demo Derived Column | 00:00:00 | ||
0204.Columnn Problems Derive Missing Data | 00:00:00 | ||
0205.Demo Lookup Transformation | 00:00:00 | ||
0206.Column Problems Translation | 00:00:00 | ||
0207.Demo Lookup Transformation and Cache Transformation | 00:00:00 | ||
0208.Column Problems Data Type | 00:00:00 | ||
0209.Demo Data Conversion Transformation | 00:00:00 | ||
0210.Column Problems Truncation | 00:00:00 | ||
0211.Demo Flagging Unfixable Data Flow Errors | 00:00:00 | ||
0212.Record Problems Missing Dimension Data | 00:00:00 | ||
0213.Demo Inferred Members | 00:00:00 | ||
0214.Record Problems Lookup Failures | 00:00:00 | ||
0215.Demo Fuzzy Lookup Transformation | 00:00:00 | ||
0216.Record Problems Duplicate Data | 00:00:00 | ||
0217.Record Problems Fuzzy Grouping and Data | 00:00:00 | ||
0218.Business Rule Problems Out of Range Values | 00:00:00 | ||
0219.Data Quality Services | 00:00:00 | ||
0220.Summary | 00:00:00 | ||
03.Package Performance | |||
0300.Introduction | 00:00:00 | ||
0301.Pipeline Buffer Architecture | 00:00:00 | ||
0302.Non-Blocking Streaming Transformations | 00:00:00 | ||
0303.Demo Executing Non-Blocking Streaming Transformations | 00:00:00 | ||
0304.Non-Blocking Row-Based Transformations | 00:00:00 | ||
0305.Demo Executing Non-Blocking Row-Based Transformations | 00:00:00 | ||
0306.Partially Blocking Transformations | 00:00:00 | ||
0307.Demo Executing Partially BlockingTransformations | 00:00:00 | ||
0308.Blocking Transformations | 00:00:00 | ||
0309.Demo Executing Blocking Transformations | 00:00:00 | ||
0310.Synchronous versus Asynchronous | 00:00:00 | ||
0311.Execution Trees | 00:00:00 | ||
0312.Demo Reviewing The Pipeline Execution Tree Log | 00:00:00 | ||
0313.Performance Optimization Buffers | 00:00:00 | ||
0314.Demo Performance Optimization Buffer Sizing | 00:00:00 | ||
0315.Parallelism, Transformations, Sources, and Destinations | 00:00:00 | ||
0316.Performance Monitoring | 00:00:00 | ||
0317.Summary | 00:00:00 | ||
Material | |||
Tải tư liệu | 00:00:00 |