Pentaho Analytics for MongoDB Cookbook电子书

Pentaho Analytics for MongoDB Cookbook

Table of Contents

Pentaho Analytics for MongoDB Cookbook

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why Subscribe?

Free Access for Packt account holders

Preface

Pentaho Installation

What this book covers

What you need for this book

Who this book is for

Sections

Getting ready

How to do it…

How it works…

There's more…

See also

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. PDI and MongoDB

Introduction

Learning basic operations with Pentaho Data Integration

Getting ready

How to do it…

How it works…

There's more…

Migrating data from the RDBMS to MongoDB

Getting ready

How to do it…

How it works…

There's more…

How to reuse the properties of a MongoDB connection

Loading data from MongoDB to MySQL

Getting ready

How to do it…

How it works…

Migrating data from files to MongoDB

Getting ready

How to do it…

How it works…

Exporting MongoDB data using the aggregation framework

Getting ready

How to do it…

How it works…

See also

MongoDB Map/Reduce using the User Defined Java Class step and MongoDB Java Driver

Getting ready

How to do it…

How it works…

There's more…

Working with jobs and filtering MongoDB data using parameters and variables

Getting ready

How to do it…

How it works…

2. The Thin Kettle JDBC Driver

Introduction

Using a transformation as a data service

Getting ready

How to do it…

How it works…

See also

Running the Carte server in a single instance

Getting ready

How to do it…

How it works…

There's more…

Running the Pentaho Data Integration server in a single instance

Getting ready

How to do it…

How it works…

Define a connection using a SQL Client (SQuirreL SQL)

Getting ready

How to do it …

How it works…

There's more…

3. Pentaho Instaview

Introduction

Creating an analysis view

Getting ready

How to do it…

How it works…

Modifying Instaview transformations

Getting ready

How to do it…

How it works…

Modifying the Instaview model

Getting ready

How to do it…

How it works…

See also

Exploring, saving, deleting, and opening analysis reports

Getting ready

How to do it…

How it works…

See also

4. A MongoDB OLAP Schema

Introduction

Creating a date dimension

Getting ready

How to do it…

How it works…

There's more…

Creating an Orders cube

Getting ready

How to do it…

How it works…

Creating the customer and product dimensions

Getting ready

How to do it…

How it works…

See also

Saving and publishing a Mondrian schema

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a Mondrian 4 physical schema

Getting ready

How to do it…

How it works…

Creating a Mondrian 4 cube

Getting ready

How to do it…

How it works…

Publishing a Mondrian 4 schema

Getting ready

How to do it…

How it works…

5. Pentaho Reporting

Introduction

Copying the MongoDB JDBC library

Getting ready

How to do it…

How it works…

Connecting to MongoDB using Reporting Wizard

Getting ready

How to do it…

How it works…

Connecting to MongoDB via PDI

Getting ready

How to do it…

How it works…

Adding a chart to a report

Getting ready

How to do it…

How it works…

Adding parameters to a report

Getting ready

How to do it…

How it works…

Adding a formula to a report

Getting ready

How to do it…

How it works…

Grouping data in reports

Getting ready

How to do it…

How it works…

Creating subreports

Getting ready

How to do it…

How it works…

Creating a report with MongoDB via Java

Getting ready

How to do it…

How it works…

Publishing a report to the Pentaho server

Getting ready

How to do it…

How it works…

Running a report in the Pentaho server

Getting ready

How to do it…

How it works…

6. The Pentaho BI Server

Introduction

Importing Foodmart MongoDB sample data

Getting ready

How to do it…

How it works…

There's more…

Creating a new analysis view using Pentaho Analyzer

Getting ready

How to do it…

How it works…

There's more…

Creating a dashboard using Pentaho Dashboard Designer

Getting ready

How to do it…

How it works…

See also

7. Pentaho Dashboards

Introduction

Copying the MongoDB JDBC library

Getting ready

How to do it…

How it works…

Importing a sample repository

Getting ready

How to do it…

How it works…

Using a transformation data source

Getting ready

How to do it…

How it works…

Using a BeanShell data source

Getting ready

How to do it…

How it works…

Using Pentaho Analyzer for MongoDB data source

Getting ready

How to do it…

How it works…

Using a Thin Kettle data source

Getting ready

How to do it…

How it works…

Defining dashboard layouts

Getting ready

How to do it…

How it works…

Creating a Dashboard Table component

Getting ready

How to do it…

How it works…

Creating a Dashboard line chart component

Getting ready

How to do it…

How it works…

8. Pentaho Community Contributions

Introduction

The PDI MongoDB Delete Step

Getting ready

How to do it…

How it works…

The PDI MongoDB GridFS Output Step

Getting ready

How to do it…

How it works…

The PDI MongoDB Map/Reduce Output step

Getting ready

How to do it…

How it works…

See also

The PDI MongoDB Lookup step

Getting ready

How to do it…

How it works…

There's more…

Index