Solutions / Pentaho

Timely and effective management decisions through quality analytics of your business!

About the Pentaho Platform

Market leader in data integration and Big Data processing.

• 12+ years in the Analytics market
• Leader in data integration and Big Data for the past 7 years, creators of the term "Data Lake"
• Proven solution operating at petabyte scale
• The most comprehensive Big Data technology support on the market, with cloud integration
• The only complete “end-to-end” platform from integration to advanced analytics

Seamless Work with Hadoop

• Automatic installation on each cluster node without environment variable changes
• Uses Native Hadoop API
• Support for the latest Hadoop versions from leading vendors
• Visual Map Reduce
• Spark and other task orchestration
• YARN* support
• Security with Kerberos, Sentry and Ranger* support

*Available only in the Enterprise Edition

Data Integration

Pentaho Data Integration (PDI) prepares data to create a clear view of your business. The platform includes visual tools to consolidate data from any source — from CSV and Excel to 1C:Accounting and SQL. Pentaho's integration layer unifies your data into a single repository and provides ready-to-use information for analysis.

• Graphical ETL designer simplifies building data processing workflows.
• Rich library of built-in components for accessing, preparing, and cleansing data from enterprise apps or third-party sources.
• Unlimited capabilities for data harmonization, merging, and transformation.

Example ETL process for cleaning Excel files:

Reporting

The capabilities of Pentaho Report Designer meet all business reporting needs — from department-level interactive reports to complex enterprise-wide reporting formats.

• User-friendly interactive report builder for business users.
• Advanced visual report designer for experienced users.
• Export to popular formats: HTML, Excel, CSV, PDF, and RTF.
• In-memory caching for fast results.

Pentaho Achievements

The Pentaho platform is a leader among open-source BI solutions. It has been actively developed since 2005 and has received numerous awards.

Pentaho is featured in Gartner's "Magic Quadrant for Business Intelligence Platforms", moving from "Niche Players" to "Visionaries" in 2016, highlighting its impact in the BI market.

Pentaho Clients

The Pentaho platform is used for business analytics by many companies around the world.

Community Edition and Marketplace

Pentaho is available both as an Enterprise Edition and a free Community Edition. The Community version allows you to build basic analytics and expand it using add-ons from the Pentaho Marketplace.

Formalized Queries

Check out sample reports built using the Pentaho platform. The "Sales/Periods" cubes are tailored for distribution business models with monthly price list updates.

• Switch between report views using the shortcuts in the top bar.
• Measurement units and period levels can be set in report parameters.
• Navigate through periods using arrows in the table header.

ADHOC Queries

For non-formalized queries, third-party modules are used, such as Saiku Analytics, developed for the Pentaho platform.