Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation

Pentaho Business Analytics

The Pentaho Business Analytics (BA) platform enables you to securely access, integrate, manipulate, visualize, and analyze your big data assets. Whether data is stored in a flat file, relational database, Hadoop, NoSQL database, analytic database, social media streams, operational stores, or in the cloud, Pentaho BA helps you discover, analyze, and visualize data to find the answers you need -- even if you have no coding experience. If you can program, you can customize reports, queries, transformations, or extend functionality using our extensive API.

Pentaho Business Analytics (BA) is divided into three components:

Pentaho User Console (PUC)

The Pentaho User Console (PUC) is a web-based design environment where you can analyze data, create interactive reports, dashboard reports, and build integrated dashboards to share business intelligence solutions with others in your organization and on the internet. In addition to its design features, PUC offers a wide variety of system administration features for configuring your Pentaho Server.

Using PUC Perspectives

The PUC interface uses perspectives to extend your ability to work on different tasks at any given time. By default PUC has the Home, Browse, Opened, Schedules and Administration perspectives. You can also extend certain perspectives with plugins from the Pentaho Marketplace.

Home The Home perspective serves as the starting place for the Pentaho User Console and all of the tasks that you do with it.
Browse Files The Browse Files perspective helps you keep your files and folders organized and makes them easier for you to find and work with.
Opened The Opened perspective uses plugins to provide access to different analytic capabilities. Depending on your subscription, you may have access to any of the following plugins: Analyzer, Interactive Reporting, Dashboard Designer and CTools.

Analyzer helps you visualize data to make informed business decisions. You can use Analyzer to filter data, add query parameters, configure drill-down links, apply conditional formatting, and to generate hyperlinks. You can also create geographic, scatter chart, heat grid, and multi-chart visualizations.

Interactive Reporting

Interactive Reporting is a web-based design interface which is used to create both simple and on-demand operational reports without depending on IT or report developers.

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. Embed a wide variety of content in the web-based display, including Interactive Reports, Analyzer visualizations, graphics, charts, web pages and collaborative content.


CTools are a set of community-driven tools installed as a stack on top of the Pentaho Server.

  • Learn more about what the CTools set can do.

Use the Schedules perspective to run reports at regular intervals, on certain dates and times, and with different parameters. You can also set a scheduled report to be emailed automatically, if your system administrator has configured the server for emailing reports.

  • Learn how to use Schedule Reports.

In PUC, the Administration perspective can be used by logged-on users assigned a role that has permissions to administer security to perform system configuration and maintenance tasks.

  • Learn about managing users and roles in PUC.

Additional Features of PUC

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 data models for use in creating reports and analysis.

Data Source Model Editor

The Data Source Model Editor allows you to change relational and multidimensional data models to make your data more accessible.

Pentaho Mobile

Pentaho Mobile is available to allow you to view and edit Analyzer reports or review reports made by Dashboard Designer, Interactive Reporting and Report Designer all through the Apple iPad.

  • Learn how to set up Pentaho Mobile.

Design Tools

Design Tools help you develop and refine how your data values are reported, modeled, transformed, and stored. These tools include: Pentaho Data Integration (PDI), Report Designer, Aggregation Designer, Metadata Editor and Schema Workbench.

Pentaho Data Integration (PDI)

Pentaho Data Integration (PDI) is a flexible tool that allows you to collect data from many different sources, like databases, files, and applications, and turn the data into a unified format that is accessible and relevant to end users. PDI provides the Extraction, Transformation, and Loading (ETL) engine that facilitates the process of capturing the right data, cleansing the data, and storing the data using a uniform and consistent format.

Report Designer

Report Designer is used to generate detailed, pixel-perfect reports using virtually any data source.

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.

  • Learn more about the Pentaho Aggregation Designer.
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.

  • Learn more about Metadata Editor.
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.

  • Learn more about Schema Workbench.

Big Data

Pentaho provides a complete big data analytics solution that supports the entire big data analytics process. From big data aggregation, preparation, and integration, to interactive visualization, analysis, and prediction, Pentaho allows you to harvest the meaningful patterns buried in big data stores.

  • Learn more about Big Data.