You are previewing Pentaho Analytics for MongoDB Cookbook.
O'Reilly logo
Pentaho Analytics for MongoDB Cookbook

Book Description

Over 50 recipes to learn how to use Pentaho Analytics and MongoDB to create powerful analysis and reporting solutions

About This Book

  • Create reports and stunning dashboards with MongoDB data

  • Accelerate data access and maximize productivity with unique features of Pentaho for MongoDB

  • A step-by-step recipe-based guide for making full use of Pentaho suite tools with MongoDB

  • Who This Book Is For

    This book is intended for data architects and developers with a basic level of knowledge of MongoDB. Familiarity with Pentaho is not expected.

    What You Will Learn

  • Extract, load, and transform data from MongoDB collections to other datasources

  • Design Pentaho Reports using different types of connections for MongoDB

  • Create a OLAP mondrian schema for MongoDB

  • Explore your MongoDB data using Pentaho Analyzer

  • Utilize the drag and drop web interface to create dashboards

  • Use Kettle Thin JDBC with MongoDB for analysis

  • Integrate advanced dashboards with MondoDB using different types of connections

  • Publish and run a report on Pentaho BI server using a web interface

  • In Detail

    MongoDB is an open source, schemaless NoSQL database system. Pentaho as a famous open source Analysis tool provides high performance, high availability, and easy scalability for large sets of data. The variant features in Pentaho for MongoDB are designed to empower organizations to be more agile and scalable and also enables applications to have better flexibility, faster performance, and lower costs.

    Whether you are brand new to online learning or a seasoned expert, this book will provide you with the skills you need to create turnkey analytic solutions that deliver insight and drive value for your organization.

    The book will begin by taking you through Pentaho Data Integration and how it works with MongoDB. You will then be taken through the Kettle Thin JDBC Driver for enabling a Java application to interact with a database. This will be followed by exploration of a MongoDB collection using Pentaho Instant view and creating reports with MongoDB as a datasource using Pentaho Report Designer. The book will then teach you how to explore and visualize your data in Pentaho BI Server using Pentaho Analyzer. You will then learn how to create advanced dashboards with your data. The book concludes by highlighting contributions of the Pentaho Community.

    Style and approach

    A comprehensive, recipe-based guide to take complete advantage of the Pentaho Analytics for MongoDB.

    Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the code file.

    Table of Contents

    1. Pentaho Analytics for MongoDB Cookbook
      1. Table of Contents
      2. Pentaho Analytics for MongoDB Cookbook
      3. Credits
      4. About the Authors
      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. Pentaho Installation
        2. What this book covers
        3. What you need for this book
        4. Who this book is for
        5. Sections
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        6. Conventions
        7. Reader feedback
        8. Customer support
          1. Downloading the example code
          2. Errata
          3. Piracy
          4. Questions
      8. 1. PDI and MongoDB
        1. Introduction
        2. Learning basic operations with Pentaho Data Integration
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        3. Migrating data from the RDBMS to MongoDB
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
            1. How to reuse the properties of a MongoDB connection
        4. Loading data from MongoDB to MySQL
          1. Getting ready
          2. How to do it…
          3. How it works…
        5. Migrating data from files to MongoDB
          1. Getting ready
          2. How to do it…
          3. How it works…
        6. Exporting MongoDB data using the aggregation framework
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        7. MongoDB Map/Reduce using the User Defined Java Class step and MongoDB Java Driver
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        8. Working with jobs and filtering MongoDB data using parameters and variables
          1. Getting ready
          2. How to do it…
          3. How it works…
      9. 2. The Thin Kettle JDBC Driver
        1. Introduction
        2. Using a transformation as a data service
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        3. Running the Carte server in a single instance
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        4. Running the Pentaho Data Integration server in a single instance
          1. Getting ready
          2. How to do it…
          3. How it works…
        5. Define a connection using a SQL Client (SQuirreL SQL)
          1. Getting ready
          2. How to do it …
          3. How it works…
          4. There's more…
      10. 3. Pentaho Instaview
        1. Introduction
        2. Creating an analysis view
          1. Getting ready
          2. How to do it…
          3. How it works…
        3. Modifying Instaview transformations
          1. Getting ready
          2. How to do it…
          3. How it works…
        4. Modifying the Instaview model
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        5. Exploring, saving, deleting, and opening analysis reports
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
      11. 4. A MongoDB OLAP Schema
        1. Introduction
        2. Creating a date dimension
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        3. Creating an Orders cube
          1. Getting ready
          2. How to do it…
          3. How it works…
        4. Creating the customer and product dimensions
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        5. Saving and publishing a Mondrian schema
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
        6. Creating a Mondrian 4 physical schema
          1. Getting ready
          2. How to do it…
          3. How it works…
        7. Creating a Mondrian 4 cube
          1. Getting ready
          2. How to do it…
          3. How it works…
        8. Publishing a Mondrian 4 schema
          1. Getting ready
          2. How to do it…
          3. How it works…
      12. 5. Pentaho Reporting
        1. Introduction
        2. Copying the MongoDB JDBC library
          1. Getting ready
          2. How to do it…
          3. How it works…
        3. Connecting to MongoDB using Reporting Wizard
          1. Getting ready
          2. How to do it…
          3. How it works…
        4. Connecting to MongoDB via PDI
          1. Getting ready
          2. How to do it…
          3. How it works…
        5. Adding a chart to a report
          1. Getting ready
          2. How to do it…
          3. How it works…
        6. Adding parameters to a report
          1. Getting ready
          2. How to do it…
          3. How it works…
        7. Adding a formula to a report
          1. Getting ready
          2. How to do it…
          3. How it works…
        8. Grouping data in reports
          1. Getting ready
          2. How to do it…
          3. How it works…
        9. Creating subreports
          1. Getting ready
          2. How to do it…
          3. How it works…
        10. Creating a report with MongoDB via Java
          1. Getting ready
          2. How to do it…
          3. How it works…
        11. Publishing a report to the Pentaho server
          1. Getting ready
          2. How to do it…
          3. How it works…
        12. Running a report in the Pentaho server
          1. Getting ready
          2. How to do it…
          3. How it works…
      13. 6. The Pentaho BI Server
        1. Introduction
        2. Importing Foodmart MongoDB sample data
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        3. Creating a new analysis view using Pentaho Analyzer
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
        4. Creating a dashboard using Pentaho Dashboard Designer
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
      14. 7. Pentaho Dashboards
        1. Introduction
        2. Copying the MongoDB JDBC library
          1. Getting ready
          2. How to do it…
          3. How it works…
        3. Importing a sample repository
          1. Getting ready
          2. How to do it…
          3. How it works…
        4. Using a transformation data source
          1. Getting ready
          2. How to do it…
          3. How it works…
        5. Using a BeanShell data source
          1. Getting ready
          2. How to do it…
          3. How it works…
        6. Using Pentaho Analyzer for MongoDB data source
          1. Getting ready
          2. How to do it…
          3. How it works…
        7. Using a Thin Kettle data source
          1. Getting ready
          2. How to do it…
          3. How it works…
        8. Defining dashboard layouts
          1. Getting ready
          2. How to do it…
          3. How it works…
        9. Creating a Dashboard Table component
          1. Getting ready
          2. How to do it…
          3. How it works…
        10. Creating a Dashboard line chart component
          1. Getting ready
          2. How to do it…
          3. How it works…
      15. 8. Pentaho Community Contributions
        1. Introduction
        2. The PDI MongoDB Delete Step
          1. Getting ready
          2. How to do it…
          3. How it works…
        3. The PDI MongoDB GridFS Output Step
          1. Getting ready
          2. How to do it…
          3. How it works…
        4. The PDI MongoDB Map/Reduce Output step
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. See also
        5. The PDI MongoDB Lookup step
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
      16. Index