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]