Pentaho Solutions Business Intelligence and Data Warehousing with Pentaho and MySQL

- Wiley - führender Fachbuchverlag im Bereich Data Warehousing und Business Intelligence
- Pentaho - die erste umfassende Open-Source-Suite für Data Warehouse-Integration, Reporting und Analyse
- Pentaho - brandaktuell und erst kürzlich ausgezeichnet als Infoworld's Best of Open Source Enterprise Applications
- Autorenteam - bekannte Förderer des Pentaho-Projekts, die in der Pentaho-Community aktiv für das Buch werben werden


Das Buch befasst sich mit allen Komponenten und zugehörigen Produkten der Pentaho Business Intelligence Suite. Zu jeder Komponente werden, soweit erforderlich, Installation, Anwendung und Wartung beschrieben und erklärt. Leser ohne Kenntnisse in oder Erfahrung mit BI-Anwendungen erhalten zudem die notwendigen Hintergrundinformationen.

The book covers all components and related products that make up the Pentaho BI Suite. For each component (and where applicable), installation, usage and maintenance are discussed and illustrated. Background theory is given as needed to provide context for those readers with no prior BI knowledge or experience. When people have read this book they will have learned the following things: The components and products that form the Pentaho Business intelligence suite (and hows these products and components fulfill particular BI needs) How to install and configure Pentaho, and how to connect it to a database/datawarehouse How to design a datawarehouse using Pentaho and related open source tools How to build and load a datawarehouse with pentaho data integration/Kettle How to manually create JFree (pentaho reporting services) reports using direct SQL queries How to set up a metadata layer to allow ad-hoc and selfservice reporting (not involving direct SQL queries) How to create Mondrian (pentaho analysis services) cubes, and attach them to a JPivot cube browser How to deploy reports, cubes and metadata to the pentaho platform in order to distribute BI solutions to end-users How to set up scheduling, subscription and automatic distribution

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.