Pentaho products are a comprehensive platform used to access, integrate, manipulate, visualize, and analyze your data. Whether data is stored in a flat file, relational database, Hadoop cluster, NoSQL database, analytic database, social media streams, operational stores, or in the cloud, Pentaho products can help you discover, analyze, and visualize data to find the answers you need -- even if you have no coding experience. Advanced users with programming experience can use our extensive API to customize reports, queries, transformations to extend functionality.
Pentaho products include both web-based components and design tools. The components and tools you use depend on your workflow and what your environment supports.
Use the Pentaho web-based components to share business intelligence solutions by analyzing data, creating reports, and building integrated dashboards.
These components include:
- User Console
The Pentaho User Console (PUC) is a design environment for accessing Analyzer, Interactive Reports, and Dashboard Designer. PUC also offers system administration features for configuring your Pentaho Server.
Analyzer helps you visualize data to make informed business decisions. You can create geographic, scatter chart, heat grid, and multi-chart visualizations. You can also filter data, add query parameters, configure drill-down links, apply conditional formatting, and to generate hyperlinks.
- Interactive Reports
Interactive Reports is a design interface used to create both simple and on-demand operational reports without relying on IT or report developers. You can quickly add elements to your report and format them any way you like.
- Dashboard Designer
Dashboard Designer is used to choose layout templates, themes, and content to create visually attractive dashboards that help decision makers gain critical knowledge at a glance. You can combine a wide variety of content including Interactive Reports, Analyzer visualizations, and collaborative content.
Data Source Wizard
The Data Source Wizard helps you define a data source that contains your information and guides you through the creation of your first relational or multidimensional models for use in creating reports and analysis.
- Data Source Model Editor
The Data Source Model Editor helps you adjust and refine relational and multidimensional data models. You can drag fields to their appropriate locations, mix and match fields from different tables, add fields to more than one category, or remove a field.
Use Pentaho design tools to develop and refine how your data values are reported, modeled, transformed, and stored.
These tools include:
- Data Integration
Pentaho Data Integration (PDI) provides access to an Extraction, Transformation, and Loading (ETL) engine that captures the right data, cleanses the data, and stores data using a uniform format that is accessible and relevant to end users and IoT technologies.
- Report Designer
Report Designer is used to generate detailed, pixel-perfect reports using virtually any data source. It enables business intelligence professionals to create highly detailed, print-quality reports based on adequately prepared data.
- Aggregation Designer
Aggregation Designer provides a simple interface that allows you to create aggregate tables from levels within the dimensions you specify. Use this tool to improve the performance of your Pentaho Analysis (Mondrian) OLAP cubes.
- Metadata Editor
The Metadata Editor simplifies report building. Use the Metadata Editor to build Pentaho metadata domains and models. A Pentaho Metadata Model maps the physical structure of your database into a logical business model.
- Schema Workbench
Schema Workbench allows you to edit and create multidimensional (Mondrian) models. You can create Mondrian models graphically or define them by hand-coding XML files.
Reference material for supported components and JDBC drivers.