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
Reviews Sentiment
5.8
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
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
A robust solution for powerful data analytics
I need some reliable references or resources because it's proven quite challenging to obtain information about MicroStrategy in Italy. It's frustrating not to have access to pricing details because, when discussing analytics tools in general and specifically mentioning MicroStrategy to potential customers, I can't provide them with essential information about pricing, licensing, cloud options, on-premises solutions, and more. Overall, it is a good product and I would rate it nine out of ten.
Sayan König - PeerSpot reviewer
Flexible, easy to understand, and simple to set up
The repository should be improved. There should be the possibility to have versioning, to make it combinable with some Git repositories or something like that, to check out the processes and make sure it has a traceable history. The solution could really be improved. There are too many bugs in our version.

Quotes from Members

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

Pros

"Security administration tools are powerful and flexible."
"IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions."
"Self-service is possible through the use of dashboards, which are also very intuitive. Stories can be used to pin snapshots, tell the story for meetings, etc."
"Stability-wise, I rate the solution a ten out of ten."
"IBM Cognos improves the effectiveness of the sales team."
"The main difference that I like about Cognos compared to other solutions is its data splitting functionality. We have all our company data inside the Cognos environment and so we prefer to split the information Cognos itself. It's more efficient this way."
"Integration with Office can enable the 'download' mode of storytelling.​"
"This solution allows you to input a wide range of file formats."
"There are people who are using MicroStrategy as transaction services."
"We have been using it mostly for grid reports and its exporting features."
"I like the user interface and the experience has been great."
"It drives us away from Excel. For what it is for, it is good. You can't run a business on Excel."
"Having the intelligence server sit in the middle is huge for us. It is going to save us a lot of time, make our work a lot simpler, make it easier for deployment, and getting the reports in the hands of our users sooner."
"The platform can be easily monitored. You have quite a good overview of tasks which are being run."
"The single stack solution will always be more profitable, scalable, and elastic for organizational needs."
"It is scalable and integration-friendly."
"We were able to install it without any assistance from tech support."
"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."
"The initial setup is pretty straightforward."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"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."
"Easy to use components to create the job."
 

Cons

"It would be better if it is was easier to implement without extensive training for it."
"We would like to see development of the product's UI function, to make it more of a UI tool that can be configured as required."
"I would like for the platform to become more standard. If we make a development on our report and our dashboard, it will not be used in another solution. That means there is no portability for the developers."
"The data uploads that we do, such as Excel files, have a lot of restrictions. If we can make it a bit more user-friendly, allowing us to have more flexibility it would be a great help."
"The technical support team’s response time is slow and needs to be improved."
"It is a costly product; it is comparatively expensive."
"One thing that we really want is the ability to have data portrayed on an image. Cognos is not able to do it at the moment, and that's becoming a requirement from the business side: having an image and then plotting your dataset on top of the image as a map."
"Cognos charts are not as fast as those of the other tools, even with DQM (dynamic query mode)."
"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 pricing could be lower because it is costly."
"I would like to see a single standalone application to control everything from the administration perspective, and also to develop new applications."
"​The product is designed for enterprise. A lightweight version would be easier for a smaller workgroup.​"
"When we come to them with a problem, they might know more of a generalized solution, but not one targeted to our industry."
"The interface you can design in MicroStrategy is great, but I feel it needs to be refreshed, add a bit more functionality. I would like to see more capabilities on the mobile side, to bring it on par with apps that you see in the App Store."
"Currently, the client view looks completely different depending on what you are building."
"The implementation itself was pretty straightforward. The tricky part was understanding MicroStrategy's licensing model, which was a bit convoluted back then."
"Another concern is that Pentaho is not customizable or interactive."
"The repository should be improved."
"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."
"Version control would be a good addition."
"Pentaho Business Analytics' user interface is outdated."
"Logging capability is needed."
 

Pricing and Cost Advice

"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."
"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."
"IBM Cognos offers competitive pricing similar to other BI vendors in the market."
"It's more expensive than similar solutions like Tableau and Power BI."
"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."
"Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."
"There is some additional licensing that we needed to purchase because we were touching data outside of our core data platform. The cost was approximately $25,000 for the additional licenses, which were approximate 45 licenses. For the application itself, updates, and the core platform it was approximately $50,000. Giving a total cost of $75,000 annually for our usage of IBM Cognos."
"On a scale from one to ten where one is low pricing and ten is high pricing, I would rate this solution at eight."
"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."
"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."
"Now, the price is high."
"It would be nice if there was a sticker price that says, "This software costs this amount of money." But I think that's just indicative of all software vendors. A lot of people are in it to make money, commissions, so it's just the nature of the business. But I would like to see more transparency, more equality, on pricing. Some people get better deals than others, I think."
"They offer yearly as well as perpetual licenses."
"The solution’s licensing cost is expensive."
"For larger businesses, the pricing is logical."
"We actually researched some of the other solutions. For options, price, and customer acceptance, this product has worked well for us.​"
"Free and commercial versions are available."
"Pentaho is expensive ."
"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."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
816,192 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
56%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Financial Services Firm
18%
Computer Software Company
10%
Retailer
8%
Manufacturing Company
6%
Financial Services Firm
24%
Computer Software Company
14%
Government
7%
Educational Organization
7%
 

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 a need to improve the automatic generation of metrics in MicroStrategy, as currently everything must be done...
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.
816,192 professionals have used our research since 2012.