View Source

Language: English
Author: Diethard Steiner
Video: 1 hour and 50 minutes
Release Date: December 2013
Publisher: Packt Publishing
ISBN: 178216863X

Overview

Learn how to create ETL transformations to populate a star schema in a short span of time
Create a fully-functional ETL process using a practical approach
Follow the step-by-step instructions for creating an ETL based on a fictional company – get your hands dirty and learn fast

Approach

Packt Video courses: screencast-based tutorials that show you how to get the job done. Bite sized chunks, hands on instructions, and powerful results.

What you will learn from this video

Create a star schema
Populate and maintain slowly changing dimensions type 1 and type 2
Load fact and dimension tables in an efficient manner
Use a columnar database to store the data for the star schema
Analyze the quality of the data in an agile manner
Implement logging and scheduling for the ETL process
Get an overview of the whole process: from source data to the end user analyzing the data
Learn how to auto-generate data for a date dimension

Course Contents (full version)

Getting Started [18:25 minutes]
Agile BI – Creating ETLs to Prepare Joined Data Set [12:27 minutes]
Agile BI – Building OLAP Schema, Analyzing Data, and Implementing Required ETL Improvements [11:29 minutes]
Slowly Changing Dimensions [17:03 minutes]
Populating Data Dimension [16:10 minutes]
Creating the Fact Transformation [14:28 minutes]
Orchestration [10:29 minutes]
ID-based Change Data Capture [9:46 minutes]
Final Touches: Logging and Scheduling [11:14 minutes]