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

Looker Studio vs Microsoft Power BI comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
BI (Business Intelligence) Tools (7th)
Looker Studio
Ranking in Reporting
13th
Average Rating
7.6
Number of Reviews
10
Ranking in other categories
No ranking in other categories
Microsoft Power BI
Ranking in Reporting
1st
Average Rating
8.0
Number of Reviews
312
Ranking in other categories
BI (Business Intelligence) Tools (1st)
 

Mindshare comparison

As of September 2024, in the Reporting category, the mindshare of IBM Cognos is 4.8%, down from 6.4% compared to the previous year. The mindshare of Looker Studio is 2.4%, down from 2.8% compared to the previous year. The mindshare of Microsoft Power BI is 26.1%, up from 25.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
 

Featured Reviews

AMOL JAJU - PeerSpot reviewer
Aug 30, 2024
Offers ad hoc analysis reports and good for operational dashboarding
I have many use cases. Now, we are not using building a queue, but we are using Cognos Analytics for dashboarding, operational dashboarding, and all. We are using normal standard reports and tabular reports. I think I don’t know the exact version of Cognos, but we use studios to build those…
JP
Aug 14, 2019
Easy to use and offers a plethora of query sources
We primarily use this solution for business reporting This has improved our organization by allowing people to see their data and develop visualizations themselves. The most valuable features of this solution are its ease of use and the plethora of query sources. There is a significant degree…
SK
Oct 29, 2020
Reasonably-priced and promotes collaboration through good shareability features
We use this solution to analyze financial statements from our partners. We build dashboards to see information on a product that is offered by one of our local telcos The most valuable feature is shareability, where we can publish work to the cloud and share it with team members. If you want to…

Quotes from Members

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

Pros

"Integration with Office can enable the 'download' mode of storytelling.​"
"Cognos is the best application with dashboards,batch reporting, jobs, events and ad-hoc reporting for business users."
"Previously, we were doing static reporting. Management would request a report, and it would take staff a week or more to provide it. With Cognos, we have dynamic reporting, and it has reduced both reporting and decision making times significantly. With the solution's dashboard, the company's management team has updated records at their fingertips. This means that they can directly access the data they need to make decisions."
"IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions."
"A positive feature is Report Studio, where we create beautiful, complex reports."
"The dashboarding offered by this solution is very valuable to us."
"Cognos' most valuable features are the bundled studios, simple UI, and advanced features like the ability to create data modules."
"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"I am impressed with the tool's scheduling mechanism, refresh mechanism, and different types of charts."
"The best thing about the tool is that it allows you to share information easily and dashboards with colleagues and teammates because it's all online. No matter where you are, as long as you have the Internet, you can connect and use these dashboards. Google made good documentation for this tool. There are many examples of how to use and create dashboards and videos on YouTube. So, I think it's easy to learn."
"I find it favorable regarding speed of development, ease of building, and flexibility."
"Data Studio integrates seamlessly with other Google products, and we can use it with other APIs if we like."
"Valuable features include advanced integrated analysis and easy implementation."
"The company dashboard is useful because we could share it via a link as a reminder for everyone to check it weekly. We observed the progress of our portfolio from last week to the current week, allowing us to compare revenues."
"This has improved our organization by allowing people to see their data and develop visualizations themselves."
"The solution is free so that is a good feature."
"Its connectivity with other Office applications, mostly with Excel, and the ability to deploy it very easily are the most valuable features. It comes sort of bundled with the cloud, so you don't need to set up a server and a standalone infrastructure. So, getting into the system or building something that you can deploy is very easy and very cheap. With other systems, you need to have a server, and you need to have a license for the server. The initial setup is very costly."
"The ease of integration and connectivity stands out as the most critical aspect, followed closely by the flexibility to customize reports and dashboards."
"Tech support is very helpful."
"Very intuitive and easy to use."
"Provides a full platform (database, ETL, reporting, analysis, and so on)"
"The capability to add custom visuals and create Power BI apps. You can package datasets, synchronization details, and dashboards into a single app."
"It is really flexible. The charts and reports are really nice. You have the flexibility of self-service."
"I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data."
 

Cons

"It would be nice to offer free online training on the tool for end-users."
"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."
"Most of our company's customers want to be able to deploy IBM Cognos on a web application and use it as a desktop application, which is not possible currently."
"Tableau and Power BI are faster than Cognos."
"I would like them to reinclude PowerPlay. One thing that I am missing in the current Cognos is what was formally named PowerPlay. They have basically removed PowerPlay from it, which is something that I fail to understand because it was the most wonderful tool for business intelligence that I've ever used. As far as I know, they don't provide this functionality anymore, so this is one thing that I dislike about Cognos."
"There are some small features that are missing. It would be nice if the graphics were better. You can use external sources for charts, but it's quite complex to use and not easy to implement. If you want a new chart, you can download it from multiple tools and implement it into IBM Cognos."
"The solution's support could be better."
"The high cost of a license makes it hard to scale up on a budget."
"The tool has a lot of room for improvement. It's not very professional and allows for only simple tasks like indicating KPIs or quick calculations. It lacks a good calculation-based language like Power BI's DAX, making it less suitable for professional use. Additionally, the variety of visualization tools is limited, and customization options are restricted."
"Stability and scalability an be improved for a full ten."
"When you physically install a product on one machine instead of the cloud, you have a better visibility, best icon quality, etc.. It's more of an issue with how we are adapting to the transition. We are still in the early moments of using this tool, and we need to go deeper to discover some improvements."
"The tool should come up with data modeling layer features that are present in other products like Power BI."
"It's not yet a replacement for a complete BI tool."
"Insisting on forums, blogs and community outreach in communications, and posting videos on an established calendar would be useful."
"The challenges with Google Data Studio are associated with the security part, making it an area where improvements are required."
"There is a significant degree of sophistication required to compete with Tableau or Cognos."
"Whenever you work on the same dashboard or on the same code, Microsoft Power BI doesn't have a good architecture that allows multiple people to work on the same project."
"Real-time refreshing for SAP BW would be nice. We know its on the radar for the development team at MS. ​"
"The integration with other solutions could be improved for reporting aspects."
"They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it."
"They asked you to pay if you want to synchronize more than eight times, you would have to go to a Power BI enterprise license, which is much more costly."
"The solution could be quicker at rendering data."
"One thing I would like to have is the scripting language, as they already have within Excel. It's already within a Microsoft business product, because Excel is the number one business product out there. So it would be nice to have the scripting capability in order to automate certain processes."
"The cost of the solution can get high."
 

Pricing and Cost Advice

"My company uses IBM Cognos with another IBM product, so I think only one license is used."
"The pricing and licensing policies are comparatively cheaper than other products in the market ."
"IBM Cognos price is on the higher side of the spectrum. However, with the features that it brings, such as correlation analysis, it's worth the money. They should look at the pricing more clearly because it's a little on the higher side."
"It is pretty expensive."
"IBM Cognos is priced reasonable. However, it is more expensive than Power BI and Tableau."
"The pricing of this product is meant for medium to large-scale enterprises."
"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."
"It's more expensive than similar solutions like Tableau and Power BI."
"The solution is free but the Google Looker is expensive."
"The product is available for free."
"The tool is free."
"I think the tool is cheap because you don't need to pay anything for using the tool. However, when connecting and analyzing other data sources, you should consider where to analyze this information because Google Data Studio doesn't handle much data well. You must also consider how you will connect this data to it. In this case, you might need to hire DevOps or a data team to help with these issues."
"The cost is quite affordable based on feature analysis."
"The Report Server is pretty expensive on-premise. But as long companies are happy to use the cloud version, that's very cost effective."
"Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable. It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version."
"The solution’s pricing is reasonable."
"I am satisfied with its price. Its price is very less as compared to Tableau and QlikView."
"The licensing can be complicated."
"It is a cheap solution for our needs."
"You don't need a license for development, but if you want to publish to external users, you need a license. The licensing is very costly, but I think that since the advantages and benefits of Power BI are so high, people are willing to pay. I can't blame them."
"Microsoft BI is very cost-effective and this is why we use it."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
800,688 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Top Industries

By visitors reading reviews
Educational Organization
59%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Computer Software Company
17%
Financial Services Firm
12%
Manufacturing Company
10%
Educational Organization
8%
Educational Organization
39%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
5%
 

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?
The tool does not have much documentation on the internet. It is not easy to resolve issues by finding the reason for...
What do you like most about Google Data Studio?
The company dashboard is useful because we could share it via a link as a reminder for everyone to check it weekly. W...
What needs improvement with Google Data Studio?
The tool has a lot of room for improvement. It's not very professional and allows for only simple tasks like indicati...
What is your primary use case for Google Data Studio?
The solution is a visualization tool that helps to make dashboards.
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...
Is Power BI a complete platform or only a visualization tool?
Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize info...
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are ...
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
Data Studio
SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
 

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.
Genesys, Shueisha
Accenture Adidas Aetna AIG Airbus Alibaba Allstate Amazon American Express Aon AT&T Audi Bank of America BASF Bayer Berkshire Hathaway Boeing Coca-Cola Comcast Cisco Coca-Cola Dell Disney Emirates Equinix FedEx Ford GE Google H&M Home Depot Honda IBM Intel JPMorgan Chase Kellogg's Kroger L'Oréal McDonald's Merck MetLife Microsoft Nike Oracle P&G PepsiCo Procter & Gamble Prudential Financial SAP Siemens Snapchat Spotify Starbucks Target Toyota T-Mobile Unilever Visa Walmart WeWork World Bank Xerox
Find out what your peers are saying about Looker Studio vs. Microsoft Power BI and other solutions. Updated: July 2024.
800,688 professionals have used our research since 2012.