Try our new research platform with insights from 80,000+ expert users

MicroStrategy vs Pentaho Business Analytics comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in BI (Business Intelligence) Tools
7th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
Reporting (4th)
MicroStrategy
Ranking in BI (Business Intelligence) Tools
8th
Average Rating
8.2
Reviews Sentiment
5.7
Number of Reviews
159
Ranking in other categories
Embedded BI (3rd)
Pentaho Business Analytics
Ranking in BI (Business Intelligence) Tools
21st
Average Rating
8.0
Number of Reviews
42
Ranking in other categories
Cloud Operations Analytics (4th), Reporting (15th)
 

Mindshare comparison

As of November 2024, in the BI (Business Intelligence) Tools category, the mindshare of IBM Cognos is 3.8%, down from 4.4% compared to the previous year. The mindshare of MicroStrategy is 3.5%, down from 3.6% compared to the previous year. The mindshare of Pentaho Business Analytics is 0.6%, down from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Jul 27, 2022
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
Pietro Saglietti - PeerSpot reviewer
Sep 26, 2023
A robust solution for powerful data analytics
I use its Discovery Analytics feature, particularly in the context of KPI analysis for management It plays a vital role in establishing a connection with predictive continuous improvement. This approach proves highly valuable for teams involved in continuous improvement efforts, especially in…
Sayan König - PeerSpot reviewer
Feb 16, 2022
Flexible, easy to understand, and simple to set up
It's a data warehouse for finance and central bank reporting purposes, and an ETL tool in this environment It's easily understandable. The product is quick and flexible, with very good steps to make data transformation possible.  The initial setup is pretty straightforward. The repository should…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"We use IBM Cognos for enterprise analytics and reporting."
"I have worked on the features like dashboards and stories, and I do like them a lot."
"Security administration tools are powerful and flexible."
"The tool can join data from different sources, write back to databases, generate alerts, and be customized to our preferences. It's an enterprise BI tool that's more powerful than just visualization tools like Power BI or Tableau."
"IBM Cognos is an excellent solution for tax, planning, budgeting, profit and loss statements and balance sheets."
"It is a stable product."
"The dashboarding offered by this solution is very valuable to us."
"The basic platform comes with several meta-modelling tools."
"The data governance leads people to trust the data that they have, and they know where to get it."
"The solution has excellent features available on mobile."
"It's user-friendly, also the MTDI cube is a very good approach, as it helps you to use the pre-format instead of using the standard objects from the schema of MicroStrategy."
"The solution's platform analytics gives us real-time analysis of how a particular user uses the report and how the systems behave."
"It's a stand-alone mobile development app that you don't even have to do business intelligence on. You can just use it to build apps."
"We are using mobile analytics, and it is amazing."
"In terms of functionality, MicroStrategy is alright. It's a solid BI tool and can handle most tasks you'd expect."
"Project Schema/metadata- Very flexible, connects to a variety of different data sources and is very flexible for many specific tasks. Attributes/metrics/filters created once used by everyone."
"The initial setup is pretty straightforward."
"Easy to use components to create the job."
"We were able to install it without any assistance from tech support."
"Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud."
"The most valuable feature of Pentaho is the Tableau report."
"Pentaho is an analytics platform that can be used when an organization has a lot of big data storage systems already installed and needs to manage and analyze that data. It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
 

Cons

"Extending features on dashboards so it becomes a real dashboard building application, not only a data exploration tool."
"We need more predictive analytical functions, not only diagnostic or decryptic analytics."
"The solution's support could be better."
"It is a costly product; it is comparatively expensive."
"The high cost of a license makes it hard to scale up on a budget."
"Data modeling needs to be improved. We use the ETL process, and when we get errors, we then need to identify which structural change is required. The error messaging should be better. They should be descriptive rather than semantic."
"It would be good if the solution had conditional formatting."
"Cognos is quite slow - it's missing the performance of the PowerPlay cubes."
"I don't think that they will, but I'd like to see parallel processing, scalable parallel processing."
"MicroStrategy needs to do some more development to make the platform easier to use. It's a complicated platform that requires a lot of skill to effectively utilize. So they could work on reducing the complexity to make it more accessible for a broader community of people."
"They need to improve on having more professional, well-equipped premium support.​"
"MicroStrategy is dragging behind other tools on the self-service visualizations, like Tableau. I would rate Tableau as a 10. For the same visualizations, I would say MicroStrategy is an eight, maybe nine. They're still behind on the self-service visualizations,"
"Data preparation-wise, it was not so straightforward with respect to getting different sources. Preparing or transforming the data inside and then bringing it onto the dashboard was a bit difficult, and the experience could have been better."
"The product could be improved by adding additional visualization."
"The solution's licensing could be improved because its cost is heavy on the pockets."
"With Cube partition (v10.1 and above) scalability has not been an issue, but the Cube publish time, and temporary space consumption while the Cube is being published, has almost doubled during implementation of Cube partition."
"Version control would be a good addition."
"The repository should be improved."
"Pentaho Business Analytics' user interface is outdated."
"Deployment is not simple. It is not simple because we are dealing with a lot of data; we are dealing with a lot of storage. So, it's not a simple process."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"Pentaho, at the general level, should greatly improve the easy construction of its dashboards and easy integration of information from different sources without technical user intervention."
"Logging capability is needed."
"Another concern is that Pentaho is not customizable or interactive."
 

Pricing and Cost Advice

"It is my understanding that the cost is very low. It's not very expensive."
"I don't know the exact cost, but I believe Cognos is quite expensive, especially when it comes to the support consultants and the procedures that need to be applied."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"I rate the product price as four or five on a scale from one to ten, where one is a low price, and ten is a high price."
"It is quite pricy. I think Microsoft BI is cheaper. Tableau might also be cheaper, but it also depends on the usage. If you have very many users, Cognos can be a problem. It could be cheaper than Tableau but not for so many users. If you have a few thousand users, Tableau, which is generally quite expensive, can be cheaper than Cognos."
"The licensing costs are a little bit higher for IBM Cognos. I don't think there is any additional cost apart from the licensing charges."
"It is pretty expensive."
"The pricing and licensing policies are comparatively cheaper than other products in the market ."
"​The solution is scalable. A little expensive perhaps, but it is scalable.​"
"They need to work on their license structure. They are not competitive against somebody like SAP BusinessObjects. We had a quote that was almost a third the price, coming from SAP BusinessObjects, and it's not a better platform. It's not cheaper. They do concurrent user licensing, while MicroStrategy does named user licensing, and that was literally the only difference. But it made a $500,000 difference. They've got to do something to make themselves more competitive. Maybe it's assessing your business users and what you really expect them to use, and maybe giving a reduced price on that. But they are already giving us a 60% discount and they were still a million or so above, over a three-year time period. That doesn't account for synergies as we get from on-site resources that are already available, but I thought that that was a big, big deficit for them."
"We actually researched some of the other solutions. For options, price, and customer acceptance, this product has worked well for us.​"
"All BI software vendors' list prices are high. It's about a price that fits the customer's needs. And I think MicroStrategy has some flexibility in its pricing model where we can easily demonstrate a total cost of ownership comparison against any of the other players."
"It is expensive. We would like to extend it to many users, but we are currently restricting that because the cost is a constraint. If we are given a chance, we would love to expand it."
"There have been actual direct bottomline impacts in terms of extra revenue created from the reporting solutions."
"We have one of the best pricing available, but we can't disclose that information."
"Additional costs are associated with maintenance."
"We were lucky enough to find a Pentaho OEM partner who offered a data warehouse model and the ETL software for about 60K SGD per year."
"Free and commercial versions are available."
"Pentaho is expensive ."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Comparison Review

it_user6978 - PeerSpot reviewer
Jun 10, 2013
Jaspersoft vs. Pentaho – Which one to use & is there any need to purchase the commercial edition
Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same…
 

Top Industries

By visitors reading reviews
Educational Organization
57%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Financial Services Firm
18%
Computer Software Company
10%
Retailer
8%
Insurance Company
7%
Financial Services Firm
25%
Computer Software Company
14%
Educational Organization
8%
Government
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik ...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...
What do you like most about MicroStrategy?
The stability of the product is good.
What is your experience regarding pricing and costs for MicroStrategy?
For larger businesses, I think the pricing is logical, but for smaller companies, it can be a bit costly.
What needs improvement with MicroStrategy?
There is room for improvement in data visualization. Compared to other BI tools like Power BI, MicroStrategy is stron...
Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I wou...
What is your experience regarding pricing and costs for Pentaho Business Analytics?
The organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive wi...
What needs improvement with Pentaho Business Analytics?
The product to me is not as user-friendly as other players in the market. It also still needs improvement in the repo...
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
No data available
Pentaho, Kettle, Hitachi Pentaho Business Analytics
 

Overview

 

Sample Customers

More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
Allstate Insurance, Barneys New York, Boston Children's Hospital, Buenos Aires Department of the Treasury, Campbell Soup Company, DHL, eBay, eHarmony, Facebook, Four Seasons Hotels Inc., Godiva, Hard Rock International, LinkedIn, Netflix, Pfizer, SECO (Swiss Government Unemployment Agency), Starbucks, Texas A&M University, Thomson Reuters Markets, US House of Representatives, and the US Postal Service.
Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
Find out what your peers are saying about MicroStrategy vs. Pentaho Business Analytics and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.