It automated several data preparation tasks, enabled cleaner/standardized data for Tableau reports, and was used for integrating data from the current operating system with 3 other legacy system data.

Pentaho was used to migrate data from legacy systems such as Mumps, AS400, AeGIS, to MS SQL Data Warehouse.

ETL jobs helped to move data from Premia (Oracle) systems and OGG Replicas (Oracle Golden Gate) to MS SQL.

We used Pentaho to perform data quality analysis and for the development of data marts/DWH solutions and dashboards adhering to time requirements. 

Pentaho Business Analytics can significantly improve an organization's IT insite, instead of creating silos of their data, they can manage, analyze and create an overall report using one product. It has a community version and an Enterprise version. Organizations can benefit from it by Increasing their Productivity, Improving Data Pipeline Quality, and faster Data Delivery.

It is a very good replacement for BIS, an organization's needs can be fulfilled by using the community version if they don't have any compliance issues.

Helped us form great visualizations at practically no cost since we built end to end open source architecture. This has helped in gaining business insights for us. We have also learned a lot from the development perspective since this is more of a developer's tool than tools like Tableau/Qlikview that are pretty much automated.

We were able to configure our data warehouse and implement more than eight data cubes in a very short period of time.

It helped in managing the data from different sources into one unique target.

I work for the largest government owned IT enterprise in Brazil, employing over 10.000 people with yearly earning in surplus of half billion dollars. Designing and delivering timely BI solutions used to be a bogged down process because everything involved license costs. With Pentaho we were able to better suit our needs and better serve our customers. We use CE were for our departamental BI needs, and deliver solid service to our customers using paid licenses. Also, in being so complete, Pentaho has enabled a whole new level of experimentation and testing. We can completlly evaluate a customer need with CE licenses and then delivery the solution at a price, assembling it over EE licenses. We need paid support for our customers in order to be able to timely answer any outage.

My company was able to reduce software costs and hire additional staff given the cost savings that Pentaho provided. We are moving towards a Hadoop environment after the migration of our current ETL processes and Pentaho’s easy to use development tools and big data analytics capabilities were a factor in choosing Pentaho as a solution.

We developed Sales’s and HR's datamarts. So nowadays, managers of these departments can have quick and flexible response with them. I think it was an improvement, because in the past each new analyses demanded IT resources, taking time, and this doesn't occur nowadays. The final users have much more freedom to discover the information they need.

Pentaho was used for data massaging in a system integration project. It enabled seamless data movement from one system to another. The biggest advantage of using this tool was that it support a wide range of input and output formats

It helps us build decision supported systems. The use of MicroStrategy improved the decision-making process through enterprise report automation and corporate information management.

Powerful Analytics, Fast KPI Analysis

The first eight years, I used this tool in one company. Now, I have some customers who hire me to give them advice. I have a couple of great customers in my country and they are very satisfied because they have increased productivity and lowered costs.

As for the data integration part each development team were writing their own integration scripts, parsers and interfaces from scratch on each different project over and over again. With Pentaho Data Integration which offers all these common tasks out-of-the-box we reduced development time significantly. Also by using such a universal tool and introducing a uniform architecture it became a lot easier for our developers to switch and/or join between the different development projects.

Also on the business intelligence part we moved from developing custom solutions on each track to the usage of standard functionality of the BI server and thus cutting down both complexity and development time.

When we wanted pursue this tool, the major factor was the amount of money we could save. Other than that, there is no special use cases for using this product as it was not that matured when we started using it in 2012 when compared to other ETL tools. 

We wanted a tool where by using it we could integrate multiple data sets, and could get responsive reports and Pentaho helped us do this in a good way.

- Senior management dashboard

- Pentaho Reporting and CDF integration

Making business decision easily and efficient by simplifying the Performance Management of each business units on timely basis.

I use Pentaho everyday in my company, creating new BI environments for my customers.

It covers most of our ETL requirements.

Pentaho reports have enabled our client and their users to take calculated and informed tactical decisions. The drag and drop reporting of Pentaho is very user friendly and takes care of all reporting needs very efficiently.

We've used Pentaho since 2007 in many open source business intelligence projects.

Organizing the data & representing data with Graphical view gives an insight on the data.

For decision purposes, it serves the information to managers to so they can make proper decisions using the data. With the help of the Data Analysis tool, decisions are very easy.

With the launch of Pentaho the organization has aggregated information about the various functional areas and the ability to generate real-time analysis (OLAP) without the need of IT.

I'm working on poverty alleviation in Indonesia; this tool has improved the ability to make good decisions for policy makers.

It has provided the ability to successfully integrate many different systems into one big data warehouse.

We can demonstrate a better report UI and vivid experience for our customers.

• License cost has come down
• Easy maintenance