Video Review: Building a Data Mart with Pentaho Data Integration
PACKT Video
Author: Diethard Steiner
Topics and Technologies : Video, e-Learning, Open Source
Link to the video page: http://www.packtpub.com/building-a-data-mart-with-pentaho-data-integration/video
My rating: 4/5
If you are looking for an easy way to learn how to create ETL transformations to populate a star schema these videos are recorded for you.
You only have to follow these videos step-by-step and you will get powerful results.
Today we will started with Chapter 3: "Agile BI – Building OLAP Schema, Analyzing Data, and Implementing Required ETL Improvements"
There are 3 videos here:
* 3.1: Creating a Pentaho Analysis Model
In this video we may learn two interesting perspectives on PDI: Model and Visualize. The first one we can built metadatas for analysis and reporting on an easy way. We only select our data from the physical tables and drop into the model.
* 3.2: Analyzing Data Using Pentaho Analyzer
Once we have created our model we can explore the data. In this case we will use Pentaho Analyzer. We drop our measures or levels into the sections we want and we will make our report, that's simple!!
* 3.3: Improving Your ETL for Better Data Quality
There are tools to get a better data quality. DataCleaner is fully integrated within Pentaho Kettle / PDI and you can profile your data directly within Spoon.
You can download this plugin here: http://wiki.pentaho.com/display/EAI/Human+Inference
In this video we may learn two interesting perspectives on PDI: Model and Visualize. The first one we can built metadatas for analysis and reporting on an easy way. We only select our data from the physical tables and drop into the model.
* 3.2: Analyzing Data Using Pentaho Analyzer
Once we have created our model we can explore the data. In this case we will use Pentaho Analyzer. We drop our measures or levels into the sections we want and we will make our report, that's simple!!
* 3.3: Improving Your ETL for Better Data Quality
There are tools to get a better data quality. DataCleaner is fully integrated within Pentaho Kettle / PDI and you can profile your data directly within Spoon.
You can download this plugin here: http://wiki.pentaho.com/display/EAI/Human+Inference
You will get some interesting statistics about your data (row count, highest value, lowest value, standard deviation, variance, mean...) with this useful tool.
Also, on this chapter, you will learn some PDI steps to clean and you do not load duplicates values.
Also, on this chapter, you will learn some PDI steps to clean and you do not load duplicates values.
Short videos, faster knowledge. Totally recommend!!
No comments:
Post a Comment