Pentaho Solutions

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

3.79 (34 ratings by Goodreads)
By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?


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.
show more

Product details

  • Online resource | 648 pages
  • 185.42 x 233.68 x 38.1mm | 1,020.58g
  • John Wiley and Sons Ltd
  • John Wiley & Sons Ltd
  • Chichester, United Kingdom
  • English
  • 1. Auflage
  • 0470484322
  • 9780470484326
  • 516,059

Back cover copy

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
show more

About Roland Bouman

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
show more

Table of contents

Introduction. 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 Warehouse Design. 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. Index.
show more

Rating details

34 ratings
3.79 out of 5 stars
5 35% (12)
4 26% (9)
3 26% (9)
2 6% (2)
1 6% (2)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X