2009- 2011 Dark Ages

• Manual query• Techie skill set

• Manual Report creation• Long dev cycle• Limited scope

MongoDB Business Analytics

2012 Light At The End Of The Tunnel

E T L• Visual data integration designer (required to get data)• Manual Query input• Need to know collections names

REPORT DESIGNER• Visual, desktop report designer• Manual Publish

REPORT DESIGNER• Create reports directly in report designer (no ETL step needed)• Fully leverages Aggregation Pipe• Schema on read via doc sampling• No need to know doc structure• Enhanced parameters for light interactivity• Publish and distribute• Still need to know query language• Support for replica sets, tags, nested docs, arrays

Reporting & Dashboard Designer• Self-service Interactive Reporting/all thin• Uses Pentaho meta-data layer for full usage interactive reports and dashboard• 1st class citizen as a data source …no need to code query• Leverages Aggregation Pipeline

Data Pipeline

Getting Closer

E T L• Visual design environment• Data movement in and out of MongoBD• Blend MongoDB with other key data sources• Need to know data/manual queries

TARGET DATA SET• Seed data to report designer/ visualization objects • Use as a direct pipeline to reporting

Invention of the Wheel

2013 - Q3

2013 - Q4

Wait for ItSelf-Service Interactive Reporting & Dashboards

NOLAP• Multi-dimensional Cube• Leverages PTHO meta-data• No need to know structure, queries, etc.

Benefits1. Expand Audience of Users2. Faster Development of Analytics3. Richer Analytics4. First Class Citizen5. Tied into Data Fabric

Discovery & Exploration• Highly interactive Analytics/Discovery• Advanced visualizations (chart types, zoom, select, focus)• Built-in functions like Top N, Calcs, Sort, more

Pentaho Report Design Tools V2

Winning2013-2014

Highly Interactive Analytics Discovery, Explore and Visualize

Pentaho Report Design Tools

Pentaho Analytics

2012

MongoDB Business Analyics