/
Building a Data Mart with Pentaho Data Integration

Building a Data Mart with Pentaho Data Integration

Jan 27, 2014


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]