Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL

Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL


$45.00 $50.00 Save 10% Current price is $45, Original price is $50. You Save 10%.
View All Available Formats & Editions
Eligible for FREE SHIPPING
  • Usually ships within 1 week


Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL by Roland Bouman, Jos van Dongen

Your all-in-one resource for using Pentaho with MySQL forBusiness Intelligence and Data Warehousing

Open-source Pentaho provides business intelligence (BI) and datawarehousing solutions at a fraction of the cost of proprietarysolutions. Now you can take advantage of Pentaho for your businessneeds with this practical guide written by two major participantsin the Pentaho community.

The book covers all components of the Pentaho BI Suite. You'lllearn to install, use, and maintain Pentaho-and find plenty ofbackground discussion that will bring you thoroughly up to speed onBI and Pentaho concepts.

  • Of all available open source BI products, Pentaho offers themost comprehensive toolset and is the fastest growing open sourceproduct suite
  • Explains how to build and load a data warehouse with PentahoKettle for data integration/ETL, manually create JFree (pentahoreporting services) reports using direct SQL queries, and createMondrian (Pentaho analysis services) cubes and attach them to aJPivot cube browser
  • Review deploying reports, cubes and metadata to the Pentahoplatform in order to distribute BI solutions to end-users
  • Shows how to set up scheduling, subscription and automaticdistribution

The companion Web site provides complete source code examples,sample data, and links to related resources.

Product Details

ISBN-13: 9780470484326
Publisher: Wiley
Publication date: 08/31/2009
Pages: 648
Product dimensions: 7.40(w) x 9.20(h) x 1.60(d)

About the Author

Roland Bouman is an application developer focusing on opensource Web technology, databases, and Business Intelligence. He isan active member of the MySQL and Pentaho communities, and you canfollow his blog at

Jos van Dongen is a seasoned Business Intelligenceprofessional and well-known author and presenter. He speaksregularly at conferences and seminars. You can find moreinformation about Jos at

Read an Excerpt

Click to read or download

Table of Contents


Part I Getting Started with Pentaho.

Chapter 1 Quick Start: Pentaho Examples.

Chapter 2 Prerequisites.

Chapter 3 Server Installation and Configuration.

Chapter 4 The Pentaho BI Stack.

Part II Dimensional Modeling and Data WarehouseDesign.

Chapter 5 Example Business Case: World Class Movies.

Chapter 6 Data Warehouse Primer.

Chapter 7 Modeling the Business Using Star Schemas.

Chapter 8 The Data Mart Design Process.

Part III ETL and Data Integration.

Chapter 9 Pentaho Data Integration Primer.

Chapter 10 Designing Pentaho Data Integration Solutions.

Chapter 11 Deploying Pentaho Data Integration Solutions.

Part IV Business Intelligence Applications.

Chapter 12 The Metadata Layer.

Chapter 13 Using The Pentaho Reporting Tools.

Chapter 14 Scheduling, Subscription, and Bursting.

Chapter 15 OLAP Solutions Using Pentaho Analysis Services.

Chapter 16 Data Mining with Weka.

Chapter 17 Building Dashboards.


Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews