O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Pentaho Analytics for MongoDB

Book Description

Together, Pentaho and MonoDB can provide the complete solution for storing, processing, and visualizing data. This user-friendly guide will soon have you configuring Pentaho Business Analytics to talk to MongoDB for great results.

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

  • 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

Table of Contents

  1. Pentaho Analytics for MongoDB
    1. Table of Contents
    2. Pentaho Analytics for MongoDB
    3. Credits
    4. About the Author
    5. About the Reviewers
    6. www.PacktPub.com
      1. Support files, eBooks, discount offers and more
        1. Why Subscribe?
        2. Free Access for Packt account holders
    7. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Errata
        3. Piracy
        4. Questions
    8. 1. Getting Started with Pentaho and MongoDB
      1. MongoDB technology overview
      2. Pentaho technology overview
      3. Installing MongoDB
        1. Installing MongoDB as a Windows service
        2. Restoring the sample clickstream MongoDB database
      4. Installing Pentaho
      5. Summary
    9. 2. MongoDB Database Fundamentals
      1. MongoDB database objects
        1. Sample clickstream database objects
      2. MongoDB data modeling
        1. Normalized models
        2. Denormalized models
      3. MongoDB query methods
        1. Query exercise 1
      4. Read operations
        1. Query exercise 2
      5. Query operators
        1. Querying arrays
          1. Query exercise 3
      6. Summary
    10. 3. Using Pentaho Instaview
      1. Accessing and connecting Instaview to MongoDB
      2. Parsing and profiling a MongoDB collection
        1. Adding a MongoDB query expression
        2. Creating and saving an analysis view and Instaview
      3. Summary
    11. 4. Modifying and Enhancing Instaview Transformations
      1. Opening an existing Instaview
      2. Data integration
      3. Adding a new data source
        1. CSV file input
        2. Stream lookup
      4. Creating a new analysis view from blended data
      5. Summary
    12. 5. Modifying and Enhancing Instaview Metadata
      1. Model design with dimensions and measures
        1. Open an existing Instaview
      2. Modifying measures and dimensions
        1. Session duration measure
        2. Session count measure
        3. Event count measure
        4. Referring URL dimension
        5. Other dimension changes
      3. Creating a new analysis view
      4. Summary
    13. 6. Pentaho Report Designer Fundamentals
      1. Pentaho Report Designer features
        1. Data sources
        2. Report elements
        3. Aggregations and calculations
        4. Formatting and output
      2. Navigating through Pentaho Report Designer
        1. Report workspace
        2. The Structure tab
        3. The Data tab
        4. The Style and Attributes tabs
        5. The palette
        6. The main menu and toolbar
        7. The tab toolbar
        8. Interface reference
      3. Creating a MongoDB connection and query
        1. Adding a MongoDB data source
      4. Adding and formatting report elements
        1. Adding a message field to your report
        2. Adding number-fields to your report
        3. Adding calculated values to your report
      5. Summary
    14. 7. Pentaho Report Designer Prompting and Charting
      1. Adding additional MongoDB queries
        1. Adding a bar chart query
        2. Adding a pie chart query
      2. Visualizing your data with charts
        1. JFreeChart chart types
        2. Subreports
        3. Chart data collectors and properties
        4. Creating a bar chart
        5. Modifying bar chart properties
        6. Creating a pie chart
      3. Creating a report prompt
        1. Creating a new parameter
        2. Adding parameters to existing report queries
        3. Creating subreport import parameters
      4. Summary
    15. 8. Deploying Pentaho Analytics to the Web
      1. Publishing a Report Designer report to the Web
        1. Publishing the clickstream report
      2. An introduction to the Pentaho User Console
        1. Running and scheduling the clickstream report
      3. Enabling your Instaview output for the Web
        1. Copying and modifying the Instaview transformation
      4. Using the Data Source Wizard to model your data
        1. Creating a JDBC connection and default metadata model
        2. Customizing the metadata model
      5. Creating Analyzer Views and Dashboard Designer dashboards
        1. Creating a map view in Analyzer
        2. Creating a heat grid in Analyzer
        3. Creating a dashboard using Dashboard Designer
      6. Summary
    16. Index