Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Pentaho® Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL
 
 

Pentaho® Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL [Kindle Edition]

Roland Bouman , Jos van Dongen
4.7 out of 5 stars  See all reviews (3 customer reviews)

Print List Price: £33.99
Kindle Price: £25.53 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £8.46 (25%)
* Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition £25.53  
Paperback £26.87  
Kindle Daily Deal
Kindle Daily Deal: At least 60% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Customers Who Bought This Item Also Bought


Product Description

Product Description

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.

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

Product details

  • Format: Kindle Edition
  • File Size: 10381 KB
  • Print Length: 648 pages
  • Publisher: Wiley; 1 edition (8 Feb 2011)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B004OC00VE
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: #291,738 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Author

Discover books, learn about writers, and more.

Customer Reviews

3 star
0
2 star
0
1 star
0
4.7 out of 5 stars
4.7 out of 5 stars
Most Helpful Customer Reviews
4 of 4 people found the following review helpful
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?
2 of 2 people found the following review helpful
5.0 out of 5 stars Great book for a comprehensive application suite 12 Feb 2010
Format:Paperback
This is a tremendous book to get an insight into the workings of the Pentaho application behemoth.

During my java development, I've found the need to use the excellent Pentaho Data Integration aka Kettle to transform data with great flexibility.

I bought this book to get a handle on the Pentaho Report Designer and the Pentaho BI server setup, not thinking I would need to touch much of the other stuff.
After a few weeks of getting to grips with the Report Designer, the requirements changed, we are now looking at using Pentaho Analysis Reports/Mondrian. Guess what, it's pretty much covered all you need to know to get started.
The Pentaho Analysis Reports will blow people away!
And that couple of chapters on data warehousing that I thought I didn't need, well I'm ploughing through that now!

The only section I have not properly touched yet is Data Mining but once you start to gain the knowledge imparted here, it's only a matter of time ...

If you're intending to check Pentaho out, then JUST GET THIS BOOK!
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
4.0 out of 5 stars A good book - worth the money 6 Jan 2010
By M. Sear
Format:Paperback|Verified Purchase
I woudl not say this is a "great" book. To me it is very good but not a seminal work on BI. It is though I would say an essential purchase if you want to know anything about Pentaho and for that reason I would say buy it. The author clearly knows their stuff about BI and Pentaho in particular. Nice reference guide and nice initiation into Pentaho.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.5 out of 5 stars  22 reviews
14 of 15 people found the following review helpful
5.0 out of 5 stars It's not just a great Pentaho book, it's an awesome reference for building BI applications. 3 Sep 2009
By Doug Moran - Published on Amazon.com
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.

The last section covers transforming data into information via metadata, reporting, analysis services, data mining and dashboards. Each topic is covered by an introduction, explanation of the tools available and examples using data from the case study.

I like the way Roland and Jos combine general BI knowledge with tutorials on the Pentaho applications and tie it all together with an interesting case study giving you a chance to stop and play as you follow along. I also enjoyed the many side notes with tidbits of history and pointers to other resources. Overall I found this book both informative and enjoyable.

I'm a fifteen year veteran of building BI software, one of the original Pentaho developers and am currently the Pentaho community guy. I'm not affiliated with Jos, Roland or Wiley and receive no benefit from this book beyond the satisfaction of having Pentaho software be so well represented.

Doug Moran
Pentaho
9 of 9 people found the following review helpful
5.0 out of 5 stars DW, BI and Pentaho in One Place 9 Sep 2009
By J. A. DIPAOLANTONIO - Published on Amazon.com
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.
6 of 6 people found the following review helpful
5.0 out of 5 stars Excellent Book!! 20 Sep 2009
By Abhishek Srivastava - Published on Amazon.com
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!
2 of 2 people found the following review helpful
4.0 out of 5 stars Great book to start with Pentaho 21 Sep 2009
By Ing IVAN BUDZEL - Published on Amazon.com
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.
2 of 2 people found the following review helpful
5.0 out of 5 stars Must have 14 Sep 2009
By Pedro Alves - Published on Amazon.com
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.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Popular Highlights

 (What's this?)
&quote;
Insert timestamp Insert batch process Update timestamp Update batch process &quote;
Highlighted by 5 Kindle users
&quote;
A fact table therefore contains only foreign keys pointing to the dimension tables and attributes that can be aggregated (quantitative elements). Dimension tables contain all attributes that describe a certain organization perspective (qualitative elements). &quote;
Highlighted by 4 Kindle users
&quote;
dimension tables contain information about business entities (customers, products, stores) and fact tables about business events (sales, shipments, orders). &quote;
Highlighted by 4 Kindle users

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category