Contact for queries :
banner1
This course is for business intelligence developers and database professionals who understand how to develop and deploy a basic Analysis Services solution and need to learn advanced design, deployment, and security concepts.
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
TAKE THIS COURSE
  • FREE
  • 10 Days
4 STUDENTS ENROLLED

About WPLMS

WPLMS is the most popular Education WordPress theme. With over 12000 customers and several startups successfully running their businesses on WPLMS, it is the most powerful solution for Education websites right now.

Popular Tags

Who’s Online

There are no users currently online
top
Template Design © VibeThemes. All rights reserved.