Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL
- 10h 17m
- Jos van Dongen, Roland Bouman
- John Wiley & Sons (US)
- 2009
Your all-in-one resource for using Pentaho with MySQL for Business Intelligence and Data Warehousing
Open-source Pentaho provides business intelligence (BI) and data warehousing solutions at a fraction of the cost of proprietary solutions. Now you can take advantage of Pentaho for your business needs with this practical guide written by two major participants in the Pentaho community.
The book covers all components of the Pentaho BI Suite. You'll learn to install, use, and maintain Pentaho-and find plenty of background discussion that will bring you thoroughly up to speed on BI and Pentaho concepts.
- Of all available open source BI products, Pentaho offers the most comprehensive toolset and is the fastest growing open source product suite
- Explains how to build and load a data warehouse with Pentaho Kettle for data integration/ETL, manually create JFree (pentaho reporting services) reports using direct SQL queries, and create Mondrian (Pentaho analysis services) cubes and attach them to a JPivot cube browser
- Review deploying reports, cubes and metadata to the Pentaho platform in order to distribute BI solutions to end-users
- Shows how to set up scheduling, subscription and automatic distribution
About the Authors
Roland Bouman is an application developer focusing on open source Web technology, databases, and Business Intelligence. He is an active member of the MySQL and Pentaho communities.
Jos van Dongen is a seasoned Business Intelligence professional and well-known author and presenter. He speaks regularly at conferences and seminars.
In this Book
-
Introduction
-
Quick Start—Pentaho Examples
-
Prerequisites
-
Server Installation and Configuration
-
The Pentaho BI Stack
-
Example Business Case—World Class Movies
-
Data Warehouse Primer
-
Modeling the Business Using Star Schemas
-
The Data Mart Design Process
-
Pentaho Data Integration Primer
-
Designing Pentaho Data Integration Solutions
-
Deploying Pentaho Data Integration Solutions
-
The Metadata Layer
-
Using the Pentaho Reporting Tools
-
Scheduling, Subscription, and Bursting
-
OLAP Solutions Using Pentaho Analysis Services
-
Data Mining with Weka
-
Building Dashboards
