Book Image

Pentaho Analytics for MongoDB

By : Bo Borland
Book Image

Pentaho Analytics for MongoDB

By: Bo Borland

Overview of this book

<p>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.<br /><br />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.&nbsp; 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.<br /><br />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.</p>

Related Content you might be interested in

Current Title:

Small book image
Pentaho Analytics for MongoDB
Bo Borland
Feb, 2014 | 146 pages
No titles found
Table of Contents (15 chapters)
Pentaho Analytics for MongoDB
Pentaho Analytics for MongoDB
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Getting Started with Pentaho and MongoDB
Getting Started with Pentaho and MongoDB
MongoDB technology overview
Pentaho technology overview
Installing MongoDB
Installing Pentaho
Summary
2
MongoDB Database Fundamentals
MongoDB Database Fundamentals
MongoDB database objects
MongoDB data modeling
MongoDB query methods
Read operations
Query operators
Summary
3
Using Pentaho Instaview
Using Pentaho Instaview
Accessing and connecting Instaview to MongoDB
Parsing and profiling a MongoDB collection
Summary
4
Modifying and Enhancing Instaview Transformations
Modifying and Enhancing Instaview Transformations
Opening an existing Instaview
Data integration
Adding a new data source
Creating a new analysis view from blended data
Summary
5
Modifying and Enhancing Instaview Metadata
Modifying and Enhancing Instaview Metadata
Model design with dimensions and measures
Modifying measures and dimensions
Creating a new analysis view
Summary
6
Pentaho Report Designer Fundamentals
Pentaho Report Designer Fundamentals
Pentaho Report Designer features
Navigating through Pentaho Report Designer
Creating a MongoDB connection and query
Adding and formatting report elements
Summary
7
Pentaho Report Designer Prompting and Charting
Pentaho Report Designer Prompting and Charting
Adding additional MongoDB queries
Visualizing your data with charts
Creating a report prompt
Summary
8
Deploying Pentaho Analytics to the Web
Deploying Pentaho Analytics to the Web
Publishing a Report Designer report to the Web
An introduction to the Pentaho User Console
Enabling your Instaview output for the Web
Using the Data Source Wizard to model your data
Creating Analyzer Views and Dashboard Designer dashboards
Summary
Index
Index

Creating a new analysis view from blended data

Now that Instaview has successfully blended our clickstream and geographic data, let’s visualize the data on a Google map:

  1. Make sure you are connected to the Internet so the Google mapping feature will work.

  2. If you are in the Instaview Configure mode instead of the analysis interface, click on the New Analysis button.

    Note

    The measures and dimensions are updated in the Available fields section to include the Country, State, City, and Zipcode fields from the zip_codes.csv file.

  3. Drag Durationsession to the Measures drop zone in the Layout section.

  4. Drag Country to the Rows drop zone in the Layout section.

  5. Drag State to the Rows drop zone in the Layout section.

  6. In the View As section, click on the dropdown next to the chart icon and then select Geo Map:

  7. Expand the small plus icon on the right-hand side of the map and select the Google Physical base layer so that your visualization matches the following screenshot:

  8. Click on the Save View button and name the...

Previous Section
End of Section 5
Next Section