Pentaho Analytics for MongoDB

Pentaho Analytics for MongoDB
eBook: $16.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $43.98    Print cover: $26.99
save 39%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • This is a step-by-step guide that will have you quickly creating eye-catching data visualizations
  • Includes a sample MongoDB database of web clickstream events for learning how to model and query MongoDB data
  • Full of tips, images, and exercises that cover the Pentaho development lifecycle

Book Details

Language : English
Paperback : 146 pages [ 235mm x 191mm ]
Release Date : February 2014
ISBN : 1782168354
ISBN 13 : 9781782168355
Author(s) : Bo Borland
Topics and Technologies : All Books, Big Data and Business Intelligence, Open Source

Table of Contents

Chapter 1: Getting Started with Pentaho and MongoDB
Chapter 2: MongoDB Database Fundamentals
Chapter 3: Using Pentaho Instaview
Chapter 4: Modifying and Enhancing Instaview Transformations
Chapter 5: Modifying and Enhancing Instaview Metadata
Chapter 6: Pentaho Report Designer Fundamentals
Chapter 7: Pentaho Report Designer Prompting and Charting
Chapter 8: Deploying Pentaho Analytics to the Web
  • Chapter 2: MongoDB Database Fundamentals
    • MongoDB database objects
      • Sample clickstream database objects
    • MongoDB data modeling
      • Normalized models
      • Denormalized models
    • MongoDB query methods
      • Query exercise 1
    • Read operations
      • Query exercise 2
    • Query operators
      • Querying arrays
  • Summary
  • Chapter 3: Using Pentaho Instaview
    • Accessing and connecting Instaview to MongoDB
    • Parsing and profiling a MongoDB collection
      • Adding a MongoDB query expression
      • Creating and saving an analysis view and Instaview
    • Summary
  • Chapter 5: Modifying and Enhancing Instaview Metadata
    • Model design with dimensions and measures
      • Open an existing Instaview
    • Modifying measures and dimensions
      • Session duration measure
      • Session count measure
      • Event count measure
      • Referring URL dimension
      • Other dimension changes
    • Creating a new analysis view
    • Summary
  • Chapter 6: Pentaho Report Designer Fundamentals
    • Pentaho Report Designer features
      • Data sources
      • Report elements
      • Aggregations and calculations
      • Formatting and output
    • Navigating through Pentaho Report Designer
      • Report workspace
      • The Structure tab
      • The Data tab
      • The Style and Attributes tabs
      • The palette
      • The main menu and toolbar
      • The tab toolbar
      • Interface reference
    • Creating a MongoDB connection and query
      • Adding a MongoDB data source
    • Adding and formatting report elements
      • Adding a message field to your report
      • Adding number-fields to your report
      • Adding calculated values to your report
    • Summary
  • Chapter 7: Pentaho Report Designer Prompting and Charting
    • Adding additional MongoDB queries
      • Adding a bar chart query
      • Adding a pie chart query
    • Visualizing your data with charts
      • JFreeChart chart types
      • Subreports
      • Chart data collectors and properties
      • Creating a bar chart
      • Modifying bar chart properties
      • Creating a pie chart
    • Creating a report prompt
      • Creating a new parameter
      • Adding parameters to existing report queries
      • Creating subreport import parameters
    • Summary
  • Chapter 8: Deploying Pentaho Analytics to the Web
    • Publishing a Report Designer report to the Web
      • Publishing the clickstream report
    • An introduction to the Pentaho User Console
      • Running and scheduling the clickstream report
    • Enabling your Instaview output for the Web
      • Copying and modifying the Instaview transformation
    • Using the Data Source Wizard to model your data
      • Creating a JDBC connection and default metadata model
      • Customizing the metadata model
    • Creating Analyzer Views and Dashboard Designer dashboards
      • Creating a map view in Analyzer
      • Creating a heat grid in Analyzer
      • Creating a dashboard using Dashboard Designer
    • Summary

Bo Borland

Bo Borland is the vice president of field technical sales at Pentaho, a leading Big Data analytics software provider. He has a passion for building teams and helping companies improve performance with data analytics. Prior to joining Pentaho, Bo worked as a management consultant at Deloitte and as a solution architect at Cognos, an IBM company. He founded a successful analytics consulting company, Management Signals, which merged with Pentaho in 2012. His 14 years' experience in professional analytics includes roles in management, sales, consulting, and sales engineering.

Pentaho Corporation is a leading Big Data analytics company headquartered in Orlando, FL, with offices in San Francisco, London, and Portugal. Pentaho tightly couples data integration with full business analytics capabilities into a single, integrated software platform. The company's subscription-based software offers SMEs and global enterprises the ability to reduce the time taken to design, develop, and deploy Big Data analytics solutions.

Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Pentaho Analytics for MongoDB +    Learning Nagios 3.0 =
50% Off
the second eBook
Price for both: $25.30

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Install and configure Pentaho and MongoDB
  • Discover MongoDB data models and the implications of collection design on queries
  • Use the Mongo shell for database commands and queries
  • Familiarize yourself with Pentaho Instaview for instant analysis on MongoDB data
  • Discover Pentaho Data Integration for blending and enriching your MongoDB data
  • Create prompted reports in Pentaho Report Designer
  • Assemble interactive dashboards using Pentaho Dashboard Designer

In Detail

Pentaho Analytics for MongoDB will teach you MongoDB and Pentaho integration points and developer skills needed to create turnkey analytic solutions that deliver insight and drive value for your organization.

Starting with how to install, configure, and develop content in both Pentaho and MongoDB, this book will give you the complete range of skills needed to gain insight into MongoDB data using Pentaho Business Analytics.  You will learn about MongoDB data models and query techniques, which are covered in combination with the provided sample MongoDB database. You then advance to data integration, analysis, and reporting using Pentaho.

You will learn how to use Pentaho Data Integration to blend and enrich data from additional sources. From this blended data, you will develop professional-looking reports and analysis views that are visual and interactive. Lastly, we will cover the Pentaho web portal and web interfaces for deploying analytics out to a broader set of consumer users.


This is an easy-to-follow guide on the key integration points between Pentaho and MongoDB. This book employs a practical approach designed to have Pentaho configured to talk to MongoDB early on so that you see rapid results.

Who this book is for

This book is intended for business analysts, data architects, and developers new to either Pentaho or MongoDB who want to be able to deliver a complete solution for storing, processing, and visualizing data. It’s assumed that you will already have experience defining data requirements needed to support business processes and exposure to database modeling, SQL query, and reporting techniques.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software