Pentaho Analytics for MongoDB

Combine Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions

Overview

• 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

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.

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

Approach

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

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: Deploy Pentaho Analytics to the Web