Building a Data Mart with Pentaho Data Integration

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


  • 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


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]