The Analysis module allows for complete drag-and-drop report design which allows users to create reports in very short periods of time. The module provides: |
| |
 |
Rich, interactive analysis |
| |
 |
Web- or Excel-based access |
|
No query skills required |
|
|
Business
Intelligence Suite Integration |
| |
|
Comprehensive auditing of user activity, performance and data access |
|
Integrated security, scheduling, alerting, portal integration, and metadata |
|
|
|
|
| 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 Analysis Feature Details |
| Rich Graphical Displays |
| |
|
Interactive data navigation with drillable spreadsheets and charts |
|
Web-based analysis via the Pentaho User Console |
|
Excel plug-in available – Pentaho Spreadsheet Services |
|
Cross-tab reports |
|
Easily tailored through user settings and preferences |
|
|
| Sophisticated OLAP Capabilities |
|
Sophisticated Relational OLAP (ROLAP) architecture with integrated, multi-level caching |
|
Optimized response times on top of operational application schemas or data warehouses and star schemas |
|
Large numbers of physical and virtual dimensions to allow for analysis by multiple attributes. Example:A retailer analyzing product sales by color, flavor, package size, and ad campaign across multiple stores by store square footage, store style, and the length of time since store opening |
|
Supports leading OLAP standards including Multidimensional Expression (MDX) Language and OLAP4J |
|
“Ragged hierarchy” support – allowing some members in a level to have child members when others don’t. |
|
| Example: |
|
A geography dimension that includes Country, State/Province and City in North America, but only has Country and City in Europe |
|
Calculations defined in the OLAP model, or requested at runtime via the query language |
|
Automatic conversion of MDX requests into sophisticated SQL queries |
|
Aggregate-awareness to improve relational database performance by using aggregate tables |
|
User and role-based security, including cell level security at the most granular level |
|
|
| Pentaho User Console |
|
Intuitive thin-client interface for central access to all BI content |
|
Create new ad hoc reports and analysis views in a few simple clicks |
|
Explorer-style interface for easy navigation of BI content |
|
Share reports, analysis views, and dashboards with others |
|
Schedule reports for reliable, on-time delivery of information |
|
| |
| The User Console provides central, secure, and easy access to business information |
| |
| Modern, Standards-based Architecture |
|
100% J2EE server components for scalability, portability, and integration |
|
Open, XML-based repository |
|
DBC 2.0 compliant |
|
Supports connectivity via JDBC to proprietary databases including Oracle, IBM DB2, Microsoft SQL Server, NCR Teradata and more |
|
Supports connectivity via JDBC to popular open source databases including MySQL, PostgresSQL, EnterpriseDB, and others |
|
Support for OLAP4J API |
|
All components exposed via Web Services for easy integration into Service Oriented Architectures (SOAs) |
|
| |
| Pentaho Schema Workbench |
|
Integrated OLAP schema designer |
|
Create, edit, update, and publish OLAP schema definitions |
|
Simplifies and accelerates the development of analytical solutions |
|
| |
| The Schema Workbench accelerates development and deployment of analytical solutions. |
| |
| Broad Data Source Support |
|
Compliant with Java Database Connectivity (JDBC) 2.0 or later |
|
Supports proprietary databases including Oracle, IBM DB2, Microsoft SQL Server, Teradata and more |
|
Supports popular open source databases including MySQL, PostgresSQL, EnterpriseDB, and others |
|
|
| We use a sophisticated OLAP architecture for high-performance, interactive analysis. |
| |
| Performance and Scalability |
|
Multi-level caching of data, dimensions, and user information |
|
Robust relational database-based storage |
|
100% J2EE architecture to leverage scalability of popular application servers like JBoss |
|
Aggregate-awareness to take advantage of database aggregates |
|
| |
| Pentaho Aggregation Designer |
|
Pentaho Aggregation Designer analyzes database structures and OLAP schemas to automatically generate aggregate tables for faster analytic query performance |
|
Identifies “costs” and “benefits” of aggregate tables based on the size of the aggregate table and the performance improvement it will provide |
|
Automatically creates the tables, populates the data, and updates the OLAP schema |
|
|
| The Aggregation Designer makes it easy to achieve high-performance analysis. |
| |
| Integration with the BI Suite |
|
Comprehensive auditing of user activity, performance, and data access |
|
Rich reporting via integration with Pentaho Reporting |
|
Integrated Report Design Wizard to simplify and streamline report design |
|
Drillable dashboards allowing users to drill from a metric into Pentaho Analysis |
|
Integrated security, scheduling, portal integration, and metadata |
|
