Thank you for visiting us. We are currently updating our shopping cart and regret to advise that it will be unavailable until September 1, 2014. We apologise for any inconvenience and look forward to serving you again.

Wiley
Wiley.com
Print this page Share

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

ISBN: 978-0-470-48432-6
648 pages
August 2009
Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL (0470484322) cover image
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.

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

See More
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 http://rpbouman.blogspot.com/.

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 http://www.tholis.com.

See More
Download TitleSizeDownload
Read Me 908 bytes Click to Download
Chapter 1 1.73 KB Click to Download
Chapter 2 7.71 KB Click to Download
Chapter 3 6.43 KB Click to Download
Chapter 4 1.45 KB Click to Download
Chapter 5 40.50 KB Click to Download
Chapter 6 16.83 KB Click to Download
Chapter 7 67.01 KB Click to Download
Chapter 8 16.17 KB Click to Download
Chapter 9 6.31 KB Click to Download
Chapter 10 40.71 KB Click to Download
Chapter 11 18.80 KB Click to Download
Chapter 12 35.82 KB Click to Download
Chapter 13 249.50 KB Click to Download
Chapter 14 57.12 KB Click to Download
Chapter 15 13.87 KB Click to Download
Chapter 16 19.12 KB Click to Download
Chapter 17 22.06 KB Click to Download
SQL scripts [wcm.sql] 77.39 MB Click to Download
SQL scripts [wcm_dwh.sql] 60.14 MB Click to Download
See More
Buy Both and Save 25%!
+

Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL (US $50.00)

-and- Professional Microsoft SQL Server 2012 Integration Services (US $49.99)

Total List Price: US $99.99
Discounted Price: US $74.99 (Save: US $25.00)

Buy Both
Cannot be combined with any other offers. Learn more.

Related Titles

Back to Top