Business Intelligence - Pentaho

Pentaho is the commercial open source alternative for Business Intelligence (BI). Pentaho BI Suite Enterprise Edition provides comprehensive reporting, OLAP analysis, dashboards, data integration, data mining and a BI platform that have made it the world's leading and most widely deployed open source BI suite.

Pentaho's commercial open source business model eliminates software license fees, providing support, services, and product enhancements via an annual subscription.

The suite is componed of:

Pentaho Reporting

● Access and format data from disparate sources

− RDBMS

− XML

● Produce in popular formats

− HTML

− Excel

− PDF

− Text

● Create, distribute and manage reports

− Interactive web-based reporting

− Rich graphical report designer

− Deliver reports via web or e-mail

Pentaho Analysis

● View data “dimensionally”

i.e. Sales by region, by channel, by time period

● Navigate and explore

− Ad Hoc analysis

− Dynamically drill-down into greater detail

− Pivot dimensions

− Select specific members for analysis

● Interact with high performance

− Technology optimized for rapid interactive response

Pentaho Data Integration

Many organizations have valuable information scattered across disparate applications and databases. Often it’s hard, if not impossible, for business users to get a clear view into  customer service, sales performance, internal efficiency, or global performance without an integrated view of information across these data silos. Pentaho Data Integration unlocks, and integrates this valuable information and puts it in the hands of your business users.

● Access and integrate disparate data

− ERP and CRM applications

− Legacy systems

− Databases

● Scale up to meet large data requirements

− Sophisticated caching

− Clustering

− Optimized SQL

● Maximize administrator productivity

− 100% metadata-driven

− Rich graphical user interface

− Remote monitoring and execution

Pentaho Dashboards

● Monitor and analyze Key Performance Indicators (KPIs)

− Rich visual displays

− Web-based, end user dashboard creation

● Investigate underlying details

− Drill to supporting reports

● Track exceptions

− Alert users based on business rules

Data Mining

Data Mining is the process of running data through sophisticated algorithms to uncover meaningful patterns and correlations that may otherwise be hidden. These can be used to help you understand the business better and also exploited to improve future performance through predictive analytics. For example, data mining can warn you if there’s a high probability a specific customer won’t pay on time based on an analysis of customers with similar characteristics.

● Uncover hidden patterns and correlations in data

● Predict future events based on historical patterns

Pentaho BI Platform

The Pentaho BI Platform provides critical services including scheduling, security, integration, content navigation and more. It supports all of Pentaho’s end user capabilities, providing one central place to access and explore all BI information.

● Integrate with business processes

● Orchestrate platform operations

− Within the platform

− Outside the platform

● Manage and schedule reports

● Maintain user security

● Integrate via open standards to portals, applications, etc