Automotive Holiday Deals Up to 50% Off Select Books Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon Prime Music Sweepstakes egg_2015 All-New Amazon Fire TV Grocery Gifts for Her Amazon Gift Card Offer cm15 cm15 cm15 $30 Off Amazon Echo $30 Off Fire HD 6 Kindle Cyber Monday Deals Cyber Monday Video Game Deals Shop Now HTL
Pentaho® Solutions and over one million other books are available for Amazon Kindle. Learn more

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL 1st Edition

23 customer reviews
ISBN-13: 978-0470484326
ISBN-10: 0470484322
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$10.17 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$33.81 On clicking this link, a new layer will be open
More Buying Choices
22 New from $26.25 33 Used from $6.00
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

$33.81 FREE Shipping on orders over $35. In Stock. Ships from and sold by Gift-wrap available.

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 5.0 Reporting by Example: Beginner's Guide
Total price: $117.02
Buy the selected items together

Special Offers and Product Promotions

  • Take an Extra 30% Off Any Book: Use promo code HOLIDAY30 at checkout to get an extra 30% off any book for a limited time. Excludes Kindle eBooks and Audible Audiobooks. Restrictions apply. Learn more | Shop now

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


Hero Quick Promo
Holiday Deals in Kindle Books
Save up to 85% on more than 1,000 Kindle Books. These deals are valid until November 30, 2015. Learn more

Product Details

  • Paperback: 648 pages
  • Publisher: Wiley; 1 edition (August 31, 2009)
  • Language: English
  • ISBN-10: 0470484322
  • ISBN-13: 978-0470484326
  • Product Dimensions: 7.4 x 1.3 x 9.2 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (23 customer reviews)
  • Amazon Best Sellers Rank: #921,629 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 By Doug Moran on September 3, 2009
Format: Paperback
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? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
9 of 9 people found the following review helpful By J. A. DIPAOLANTONIO on September 8, 2009
Format: Paperback
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? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
6 of 6 people found the following review helpful By Abhishek Srivastava on 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? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 2 people found the following review helpful By Pedro Alves on September 14, 2009
Format: Paperback
Roland Bouman and Jos Van Dongen took 6 months out of their family life and created this. And cutting to the chase, every Pentaho learner should thank them for that.

Pentaho is a very complex application due to many factors. For starters, the BI field is, by definition, a very sensitive field; the fact that pentaho started by combining distinct successful open-source projects - mondrian, kettle, jfreereport and weka - doesn't help when we want to learn exactly what's what. There are so many distinct applications that gets confusing to know what each thing is for.

All this makes the learning curve a very steep one. Until now. Trough over 600 pages Pentaho Solutions does a great job explaining all the Pentaho stack, where each of the components fit it and when to use what. And it doesn't stop there; It's impossible to do anything in Business Intelligence without some very solid knowledge of Data Warehouse. While this book is definitely not about it (this one is) still gives the novice reader the key concepts needed to read the book and go through the practical examples that are used.

The chapters are very well organized. They are in the same order as the topic appear when we are implementing a Pentaho solution. In the end the 600 pages even feel short, so many concepts it introduces. Don't expect to become an expert in pentaho; You won't master any of the components with this book only; you won't be a OLAP guru, a reporting wizard or even a etl master. But you will definitely know where to search for.

In my opinion, the ones that will benefit the most with this books are those guys with emails ending with [...]. It's so difficult to start playing with pentaho that a lot of newcomers feel scared and abandon it, resulting in a loss of potential user. This book changes all that. I wish I had it when I started playing with pentaho over 2 years ago. And I'm glad I have it know.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL
This item: Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL
Price: $33.81
Ships from and sold by

Want to discover more products? Check out these pages to see more: mysql data warehousing, mysql admin, mysql performance