Book Review: Pentaho Analytics for MongoDB (February 2014)



Book review by: David Fombella Pombal (twitter: @pentaho_fan)

Book Title: Pentaho Analytics for MongoDB

Author: Bo Borland

Paperback: 146 pages

I would like to suggest this book if you want to get started with MongoDB document oriented storage engine and Pentaho Open Source BI suite.

Target Audience
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 already have
experience in defining the data requirements needed to support business processes
and exposure to database modeling, SQL query, and reporting techniques.

Rating: 8 out of 10


Chapter 1, Getting Started with Pentaho and MongoDB, introduces you to the powerful combination of MongoDB and Pentaho and provides step-by-step guidance on how to install and configure both technologies and restore the sample MongoDB data provided with this book.
Chapter 2, MongoDB Database Fundamentals, expands on the topic of data modeling and explains MongoDB database concepts essential to querying MongoDB data with Pentaho.
Chapter 3, Using Pentaho Instaview, shows you how to visualize data by connecting Pentaho to MongoDB. You use Instaview with the sample MongoDB database to analyze and visualize the website clickstream data.
Chapter 4, Modifying and Enhancing Instaview Transformations, introduces Pentaho Data Integration (PDI)—the ETL tool used by Instaview to extract, load, and transform data from various data sources.
Chapter 5, Modifying and Enhancing Instaview Metadata, explores metadata by explaining dimensional modeling concepts and how to model metadata to better reflect business requirements.
Chapter 6, Pentaho Report Designer Fundamentals, teaches you the basics of Pentaho Report Designer (PRD) to build pixel-perfect reports sourced directly from MongoDB databases.
Chapter 7, Pentaho Report Designer Prompting and Charting, expands on the previous chapter by teaching you additional advanced PRD features. You can enhance your report with new queries, charts, and a prompt designed to make the report more interactive.
Chapter 8, Deploying Pentaho Analytics to the Web, is all about web-enabling your MongoDB data using Pentaho methods and web interfaces for connecting to, modeling, and analyzing our sample clickstream data in a web browser.

MongoDB Chapter8


Chapter Contents List:

  Chapter 1: Getting Started with Pentaho and MongoDB
MongoDB technology overview
Pentaho technology overview
Installing MongoDB
Installing MongoDB as a Windows service
Restoring the sample clickstream MongoDB database
Installing Pentaho

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

    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

    Chapter 4: Modifying and Enhancing Instaview Transformations
Opening an existing Instaview
Data integration
Adding a new data source
CSV file input
Stream lookup
Creating a new analysis view from blended data

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

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

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

    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