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