PENTAHO
ANALYTICS
BENEFITS
ETL
  • Manual query
  • Techle skill set
ETL
  • Visual design environment
  • Data movement In and Out of MongoDB
  • Blend MongoDB with other key data sources
  • Need to know data/manual queries
ETL
  • Visual data integration designer
  • Manual query input
  • Need to know collections names
ETL
  • No ETL step needed
ETL
  • No ETL step needed
ETL
  • Multi-dimensional cube
  • Leverages PTHO meta-data
  • No need to know structure, queries, ...
2009.2011

2009.2011

DARK YEARS

LIMITATIONS
  • Manual report creation
  • Long development cycle
  • Limited scope
2012

2012

LIGHT AT THE END OF THE TUNNEL

DATA PIPELINE

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

2012.Q1

INVENTION OF THE WHEEL

REPORT DESIGN TOOLS

FEATURES
  • Visual, desktop report designer
  • Manual publish
2013Q3

2013.Q3

GETTING CLOSER

REPORT DESIGN TOOLS V2

FEATURES
  • Create reports directly in report designer
  • 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
2013Q4

2013.Q4

WAIT FOR IT

SELF-SERVICE INTERACTIVE REPORTING & DASHBOARDS

FEATURES
  • Self-service interactive reporting/all thin
  • Uses Pentaho meta-data layer for full usage interactive reports & dashboard
  • First class citizen as a data source
  • Leverages aggregation pipeline
2013.2014

2013.2014

WINNING

HIGHLY INTERACTIVE ANALYTICS DISCOVERY, EXPLORE & VISUALIZE

DISCOVERY & EXPLORATION
  • Highly interactive analytics/discovery
  • Advanced visualizations (chart types, zoom, select, focus)
  • Built-in functions like Top N, Calcs, Sorte, ...