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>
Table of Contents (15 chapters)
Pentaho Analytics for MongoDB
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Creating a new analysis view


You should be in the View mode after refreshing your Instaview. With a newly updated model, it is a good idea to test model changes by creating a new analysis. The analysis created in the following exercise will validate that our measures are correctly aggregating across the Referringurl dimension:

  1. Click on the New Analysis button.

    Note

    The measures and dimensions are updated in the Available fields section.

  2. Drag all three measures, Event Count, Session Count, and Session Duration, to the Measures drop zone in the Layout section.

  3. Drag Referringurl to the Rows drop zone in the Layout section.

  4. Click on the Report Options button, checkmark Show Grand Totals for Columns, and then click on OK.

  5. Right click on the Session Duration column header and choose Subtotals from the right-click menu options.

  6. Uncheck the default Sum aggregation and check Average.

  7. Click on OK.

    Your table values should match those in the following figure:

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