Pentaho® Solutions and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $7.74 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Start reading Pentaho® Solutions on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL [Paperback]

by Roland Bouman, Jos van Dongen
4.5 out of 5 stars  See all reviews (22 customer reviews)

List Price: $50.00
Price: $32.91 & FREE Shipping on orders over $35. Details
You Save: $17.09 (34%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Gift-wrap available.
Want it tomorrow, April 25? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition $28.99  
Paperback $32.91  
Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more

Book Description

August 14, 2009 0470484322 978-0470484326 1
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

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

Frequently Bought Together

Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL + Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration + Pentaho Data Integration 4 Cookbook
Price for all three: $106.48

Buy the selected items together

Customers Who Bought This Item Also Bought

Editorial Reviews

From the Back Cover

Your one-stop resource for open source BI and data warehousing solutions

Pentaho is a full-featured, open source Business Intelligence suite that lets you build data warehouses and rich, powerful BI applications at a fraction of the cost of a proprietary solution. This book gets you up and running with Pentaho within minutes: right from the start you'll be running example reports, dashboards, and OLAP pivot tables while you learn about Pentaho concepts and architecture. Using a practical case study, you'll learn what dimensional modeling is and how to apply it to design a data warehouse. You'll create and populate your data warehouse with Pentaho data integration tools. Finally, you'll learn how to build your own BI applications on top of your data warehouse using Pentaho reporting, analysis, dashboarding, and data mining tools.

  • Understand important Pentaho concepts, including action sequences and the solution repository

  • Apply the key concepts of dimensional modeling and construct a data warehouse using star schemas

  • Use Pentaho data integration tools to build ETL applications

  • Explore advanced PDI features including remote execution and clustering

  • Design and deploy reports and charts using Pentaho Report Designer

  • Leverage OLAP and create interactive pivot tables with drill up/drill down using Pentaho Analysis Services

  • Concentrate and compact BI content for business users with comprehensive dashboards

  • Discover and explore patterns in your data using Pentaho data mining

About the Author

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, and you can follow his blog at

Jos van Dongen is a seasoned Business Intelligence professional and well-known author and presenter. He speaks regularly at conferences and seminars. You can find more information about Jos at

Product Details

  • Paperback: 648 pages
  • Publisher: Wiley; 1 edition (August 14, 2009)
  • Language: English
  • ISBN-10: 0470484322
  • ISBN-13: 978-0470484326
  • Product Dimensions: 1.4 x 7.3 x 9.1 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (22 customer reviews)
  • Amazon Best Sellers Rank: #247,025 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews
14 of 15 people found the following review helpful
Jos and Roland have done a great job explaining the tools and technology of the Pentaho BI Platform in the context of building real world Business Intelligence applications. They have taken some very complicated and technical concepts and presented them in an easy to follow case study. The case study they chose is simple to understand yet filled with the same kinds of real world complexities that make BI applications difficult to deliver.

The "Getting Started with Pentaho" section has all the information and documentation you wish you could find neatly arranged on the Pentaho community site. They do an excellent job explaining the entire Pentaho application stack from collecting data to presenting information. The book could have stopped here, being the Pentaho missing manual, and still have been worth buying.

The next section, "Dimensional Modeling and Data Warehouse Design" is an very good introduction/refresher on hows and whys of building data warehouses, data marts and OLAP cubes. Again they have taken a subject that is broad and complex and presented it in a way that is easy to understand and apply. Where appropriate, they refer the reader to other resources available for more in-depth coverage of specific topics.

A data warehouse is useless until you can reliably get good, complete and accurate data into it. The section on "ETL and Data Integration" is another section that could easily stand on it's own. After an introduction to ETL and Pentaho Data Integration, they show how to populate the database used for the case study including populating time dimensions. Other real world topics touched upon include; change data capture, data validation, data cleansing and issues with generating dimension tables.
Read more ›
Comment | 
Was this review helpful to you?
9 of 9 people found the following review helpful
5.0 out of 5 stars DW, BI and Pentaho in One Place September 8, 2009
I've been involved with statistical analysis & algorithm creation for 30 years, DW/BI for 15, and Pentaho (the product, not the company) for 5 years.

Jos and Roland do an excellent job of presenting the possibilities of data warehousing, reporting and online analytical processing (OLAP) in general, and in the specific, using Pentaho and other open source tools, to build their teaching example. This would be an excellent text for a university course in data warehousing or data analytics.

This is more than a book about Pentaho, this is a wonderful introduction to the world of data warehouses, data marts, business intelligence, data mining and dashboards, using the open source Pentaho BI suite, and associated open source tools such as Power*Architect, to provide hands-on experience with the concepts being explained.

The first chapter dives right into showing the potential of these concepts, by having the reader download and install Pentaho BI Suite in its simplest configuration (right out of the virtual box), and then examine the examples of various types of reports, slice-and-dice (OLAP, Cubes, Pivot Tables) and dashboards that are included with the Pentaho download. Within a maximum of two hours, and for all of $31 (the current price on Amazon), one has a business intelligence solution running on their favorite computer, and should have their mind churning with all the things they can do beyond any spreadsheet, to capture, understand, analyze and share their new-found insights of the data with which they must work every day.

Any developer tasked with adding reporting, analysis and dashboards to their web-app or enterprise software, any business person who considers themselves a power user, and any student considering a career in statistics, business analysis or software development, should reward themselves with this book.
Comment | 
Was this review helpful to you?
6 of 6 people found the following review helpful
5.0 out of 5 stars Excellent Book!! September 20, 2009
Format:Paperback|Verified Purchase
I have worked on Microsoft BI platform for a long time. I wanted to try out pentaho... but so many dependencies like Linux, MySQL, Tomcat etc were too much for me to handle. In my last attempt I couldn't even install the product.

However this book is so well written that even a person like me who doesn't know an iota of Linux/MySQL/Tomcat/Java was able to install and get up and running with a few hours of work.

The book introduces some tools which are very useful to everyone (like Power*Architect). The book explains Data warehousing and Pentaho tools very well. If someone wants to start PentahoBI then this is THE book to have.

Thanks to the authors for such a wonderful creation!
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
4.0 out of 5 stars Great book to start with Pentaho September 21, 2009
Format:Paperback|Verified Purchase
I am working with BI shortly and I am already using Pentaho products.
Great thanks for such an open source solution. Book is great for beginners when need to start using pentaho. It guides readers through enabling process when trying to use this software solution. From installation to using. Also having this book reader can save some time when browsing on Pentaho Comunity forums and looking for some solution when trying to fix some problems. This book is giving all what is need to have it working.

From developer BI perspective I would welcome more technical information about setting modrian solution over not 100 % star DB schema's. Also this book is using MySQL as target DB BI. But is does not mention about performance and DB tunning towards MySQL configuration. Also I missed information about non-functional aspects of Penatho BI. Like logging configuration, auditing configuration and so on.
It is part of enterprise edition but basic info would be welcome.

The clustering functionality in PDI (Pentaho Data Integration) is mention just slightly as last chapter. I think such an great feature of PDI deserves more pages and examples how PDI could be setup to bring more performance and scalability.

It is great book and saving a lot of time when starting with Penatho. For the guys who are already using and working with it I would consider it before buying cause many info from this book are available on community forums.

Anyway Many thanks to authors for writing such a book for this valuable Pentaho community.
Ivan Budzel.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
2.0 out of 5 stars This book is horribly out of date and of no practical use
Whatever qualities this book had when it came out; as a guide to a piece of software it is horribly dated - there are a couple of 'principles' chapters that are useful, but none of... Read more
Published 3 months ago by Claus Dahl
4.0 out of 5 stars Due for a revised edition.
This a great book on Pentaho and BI/EDW in general, but it could really use an update. The latest version of Pentaho Community Edition is out and C*tools are also much improved.
Published 5 months ago by Mdlle Tarponne
4.0 out of 5 stars Cool!
I have worked with Pentaho BI Server some time ago. But it took me a lot of hard work to make it up and running because I had to help myself on the forums. Read more
Published 16 months ago by Johnny Ceccoto
5.0 out of 5 stars Pentaho suite and Business intelligence in one book
I really enjoyed reading this book and I find myself periodically reaching for it when encountering some problem with Pentaho. Read more
Published 20 months ago by Mr. Peter Pirc
5.0 out of 5 stars Great reference guide for anyone who wants to learn about this...
This book is a very straightforward, easy to understand and very readable book. It covers the open-source Pentaho solution in detail, including the installation, the use of (in... Read more
Published on February 3, 2012 by Joe
5.0 out of 5 stars Overall Great Data Warehouse Book
Gives great context around Data Warehousing and solutions - Easy to follow and very interesting read. I wasn't expecting to like the book as much as I did. Read more
Published on December 28, 2011 by Brandon Fletcher
5.0 out of 5 stars good book and intro to amazing suite!
This is a good book to get started with the Pentaho suite.

While it may require a bit more technical skills to deploy and develop, the analysis tools really are equal to... Read more
Published on November 16, 2010 by joseph b baird iii
4.0 out of 5 stars Business Intelligence and Data warehousing with Pentaho
I had downloaded the Pentaho BI Suite, I installed it and start using it. My knowledge was limited to how to use the programs that came with the Pentaho BI Suite. Read more
Published on November 15, 2010
5.0 out of 5 stars Great book
Great book. One thing I like is explaining BI with MySQL which allows me to try the whole thing on my laptop. The early chapters give a great introduction to Pentaho. Read more
Published on November 11, 2010 by ivar
4.0 out of 5 stars Open Source BI and Warehousing Using Pentaho
I am pleased with the book. It presents a good practical introduction into warehousing and bi reporting using specifically Pentaho open source tools. Read more
Published on August 20, 2010 by gkoko
Search Customer Reviews
Only search this product's reviews


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category