Pentaho Business Intelligence Suite is a collection of software applications intended to create and deliver solutions for decision making.
It's a BI Server plus standalone client tools and it is having a graphical interface for managing data sources, users and roles and other administrator functions ,called Pentaho Enterprise Console("Pentaho Administration Console" for community edition ).
BI Suite= BI Server + (standalone client tools and PEC).
The BI Server is a Java Web application that contains specialized content creation engines plus a graphical user interface ( Pentaho User Console) for interacting with them.
BI Server Contains :
BI Platform,
Analysis Engine,
Reporting Engine,
Data Integration Engine,
Pentaho User Console(PUC).
This includes an application server (Tomcat) and three WARs: one for the Pentaho Web application, and two optional WARs that provide style sheets for BI Server content.
BI Platform:
The BI Platform is a workflow engine that forms the operational core of the BI Server. It ties the other content engines(Reporting, Analysis, and Data Integration ) to the Pentaho User Console to provide content display, delivery, and scheduling functionality.
The Reporting (JFreeReport) engine provides functions which create and render data-driven reports and
charts in a variety of formats.
The Pentaho Analysis (Mondrian) provides the ability to create an analysis schema, and to form data sets from that schema by using an MDX query.
The Data Integration (Kettle) engine enables Data Integration jobs and transformations to run in conjunction with other BI Server processes.(Data Integration Server)
Pentaho Client Tools:
Pentaho Data Integration:
It's an ETL tool, some times it is called as KETTLE, which enables us to access and prepare data sources for analysis, data mining, or reporting. This is generally where you will start if you want to prepare data for analysis.
Schema Workbench:
A graphical tool that helps us to create ROLAP schema for analysis.We need to create mondrian schema to create analyzer report or JPivot report to analyze the data.
Report Designer:
An advanced report creation tool. If you want to build a complex data-driven report, this is the right tool to use. Report Designer offers far more flexibility and functionality than the ad hoc reporting capabilities of the Pentaho User Console(PUC).
Design Studio:
An Eclipse-based tool that enables you to hand-edit a report or analysis view xaction file. Generally, people use Design Studio to add modifications to an existing report that cannot be added with Report Designer.(To create pentaho solutions and action sequences)
Aggregate Designer:
To improve mondrian schema efficiency and performance, we can create aggregate tables using aggregate designer tool.
Metadata Editor :
Pentaho Metadata Editor is a Graphical User interface for creating a user friendly metadata model on top of complex relational (initial release) data sources. These business views allow administrators to suppress the complexities of underlying data sources, enrich the models through concepts (formatting, data suppression, descriptions, and more), and apply role based security .
Dashboards:
Dashboards are used to monitor and analyze Key Performance
Indicators (KPIs). A set of tools incorporated to the BI Suite in the latest version
allows users to create interesting dashboards, including graphs, reports, analysis
views, and other Pentaho content, without much effort.
There are three ways to create dashboards:
1.Enterprise dashboard (In PUC)
2.Community Dashboard Framework
3.Pentaho Dashboard Editor.
It's a BI Server plus standalone client tools and it is having a graphical interface for managing data sources, users and roles and other administrator functions ,called Pentaho Enterprise Console("Pentaho Administration Console" for community edition ).
BI Suite= BI Server + (standalone client tools and PEC).
The BI Server is a Java Web application that contains specialized content creation engines plus a graphical user interface ( Pentaho User Console) for interacting with them.
BI Server Contains :
BI Platform,
Analysis Engine,
Reporting Engine,
Data Integration Engine,
Pentaho User Console(PUC).
This includes an application server (Tomcat) and three WARs: one for the Pentaho Web application, and two optional WARs that provide style sheets for BI Server content.
BI Platform:
The BI Platform is a workflow engine that forms the operational core of the BI Server. It ties the other content engines(Reporting, Analysis, and Data Integration ) to the Pentaho User Console to provide content display, delivery, and scheduling functionality.
The Reporting (JFreeReport) engine provides functions which create and render data-driven reports and
charts in a variety of formats.
The Pentaho Analysis (Mondrian) provides the ability to create an analysis schema, and to form data sets from that schema by using an MDX query.
The Data Integration (Kettle) engine enables Data Integration jobs and transformations to run in conjunction with other BI Server processes.(Data Integration Server)
Pentaho Client Tools:
Pentaho Data Integration:
It's an ETL tool, some times it is called as KETTLE, which enables us to access and prepare data sources for analysis, data mining, or reporting. This is generally where you will start if you want to prepare data for analysis.
Schema Workbench:
A graphical tool that helps us to create ROLAP schema for analysis.We need to create mondrian schema to create analyzer report or JPivot report to analyze the data.
Report Designer:
An advanced report creation tool. If you want to build a complex data-driven report, this is the right tool to use. Report Designer offers far more flexibility and functionality than the ad hoc reporting capabilities of the Pentaho User Console(PUC).
Design Studio:
An Eclipse-based tool that enables you to hand-edit a report or analysis view xaction file. Generally, people use Design Studio to add modifications to an existing report that cannot be added with Report Designer.(To create pentaho solutions and action sequences)
Aggregate Designer:
To improve mondrian schema efficiency and performance, we can create aggregate tables using aggregate designer tool.
Metadata Editor :
Pentaho Metadata Editor is a Graphical User interface for creating a user friendly metadata model on top of complex relational (initial release) data sources. These business views allow administrators to suppress the complexities of underlying data sources, enrich the models through concepts (formatting, data suppression, descriptions, and more), and apply role based security .
Dashboards:
Dashboards are used to monitor and analyze Key Performance
Indicators (KPIs). A set of tools incorporated to the BI Suite in the latest version
allows users to create interesting dashboards, including graphs, reports, analysis
views, and other Pentaho content, without much effort.
There are three ways to create dashboards:
1.Enterprise dashboard (In PUC)
2.Community Dashboard Framework
3.Pentaho Dashboard Editor.
