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

Model design with dimensions and measures


Instaview metadata is made up of measures and dimensions. A measure is a standard numerical unit used to express the size, amount, or degree of something. As numeric data elements, measures are aggregated at query time by each dimension defined in the metadata. For example, the total volume of shares traded in the stock market in the history represents a single measure with a large, aggregated value in units. That summarized measure value is not very useful for investors unless the dataset also contains dimensionality.

The total volume of shares traded for Google stock (GOOG) on October 18, 2013, is a more meaningful measure value. Dimensions such as stock symbol and time add context to the measure of volume of shares. Dimensional data becomes powerful for business users when modeled correctly with multiple dimensions and measures to form a multidimensional model for analysis.

In our sample clickstream data, event dimensions provide context to the...