Microsoft Power BI vs ThoughtSpot comparison

Microsoft and ThoughtSpot are both solutions in the BI (Business Intelligence) Tools category. Microsoft is ranked #1 with an average rating of 7.9, while ThoughtSpot is ranked #17 with an average rating of 7.5. Additionally, 93% of Microsoft users are willing to recommend the solution, compared to 87% of ThoughtSpot users who would recommend it.

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Microsoft Power BI and ThoughtSpot based on real PeerSpot user reviews.

Find out in this report how the two BI (Business Intelligence) Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Microsoft Power BI vs. ThoughtSpot Report (Updated: October 2024).

Buyer's Guide

Microsoft Power BI vs. ThoughtSpot

October 2024

Download the complete report

Helped 816,192 peers since 2012

Categories and Ranking

IBM Cognos

Featured Reviews

Carlos Larrad Salgado

Deputy Director Operations Management Control at Mapfre

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.

Read full review

Amol Rane

Solutions Architect M365 at Sogeti UK

Supports AI initiatives in terms of predictive analytics

The only issue is with permissions. Sometimes, despite granting granular permissions, dashboards are visible to people who shouldn't have access. It's difficult to understand why the permissions slip out. Sometimes dashboards are visible to stakeholders even though they should not have permission. It's a bit difficult to understand why the permissions slip out. The dashboards lack a user-friendly appearance, and the permissions should be easier to understand. At this point, we have to go through a lot of details. It takes a lot of time to understand the permissions, so if there were better options available within the Power BI setup, it would be quite beneficial, especially for admins. So, there should be a more user-friendly dashboard appearance and easier-to-understand permissions.

Read full review

Anthony Fiorino

SVP, Head of Enterprise Data Mgmt & Data Intelligence at a financial services firm with 5,001-10,000 employees

You can drill down into any data right out of the box, with a straightforward deployment, and great support

The most valuable feature is probably the core functionality itself, which is the ability to search and drill down into any data right out of the box. Of course, there's data modeling needed, and things like that, but I can throw it at a set, and I can get up and running in a matter of hours. If a new group comes to me and says, "Hey, I've heard about ThoughtSpot. I have some data and I want to be able to do some analytics, do some profiling, do some BI against it." In a couple of hours, I connect to their source and I just do it. Now for a production product, we have to model and perform it over time, but at least I can get people up and running extremely fast with a tool that's intuitive and easy to use.

Read full review

Quotes from Members

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

Pros

"It is a stable product."

"The Report Studio that is aimed at professional report writers."

"One of the strong suits of Cognos is its robust corporate reporting capability."

"IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions."

"It has a very powerful edit feature which allows users to back out of changes (undo) without forcing them to recreate entire reports."

"Stability-wise, I rate the solution a ten out of ten."

"The initial setup was straightforward."

"IBM Cognos improves the effectiveness of the sales team."

More IBM Cognos pros

"The DAX coding language is good for creating formulae."

"It is easy to work with and very chic."

"I also find connecting to different data sources is quite simple. Other solutions we were using before were complicated."

"Good reporting and data analysis tool that's user-friendly, easy to deploy, stable, and scalable."

"The product is user-friendly."

"The initial setup is simple to do."

"Provides data feeds for enterprise KPI reporting."

"Technical support has been great."

More Microsoft Power BI pros

"It is easy to set up the solution."

"I like ThoughtSpot's search capabilities. You can also create custom analytics even if you aren't an experienced data analyst. We have users with no data analytics experience making some of the dashboards we've created, copying components, and customizing them to their specific use cases."

"ThoughtSpot takes the modifying of existing reports out of our hands."

"The scalability is good."

"The initial setup was very straightforward."

"The ability to do ad hoc explorations of data has been most valuable."

"It's easy to drill down or expand data to get more details right out of the box."

"I would say the return on investment is good. Whatever we invested, we got results. We have been finding it easy to use and onboard new use cases."

Cons

"It would be better if it is was easier to implement without extensive training for it."

"Chart quality: many other competitors have charts and graphics that look much better and that provide dynamic effects. Cognos doesn't."

"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."

"They should provide improved visual reporting."

"The performance is a bottleneck and something that can be improved."

"It would be nice to offer free online training on the tool for end-users."

"The visualization aspect needs to be improved and I believe, this is being resolved in upcoming versions."

"They were lacking in the initial phases of development in the area of big data, and they still need to improve that aspect of the product."

More IBM Cognos cons

"When you go to the cloud, its licensing is not intuitive. It is a little bit complex. When you have to purchase a new license, it is difficult to understand on their website what exactly you need to pay and how you can group. It is something that is applicable to all Microsoft products. They're not always so simple and clear when it comes to licensing. Their support can also be better in terms of explaining how they resolved an issue and what steps they took to resolve it. They are able to resolve the issue, but they can be better at explaining the approach they took to resolve the issue. It could have something in the direction of machine learning. It can have some kind of integration with machine learning where you can ask for some reports with natural language."

"Anything they can do to improve enterprise collaboration is going to help people get set up and utilize the solution."

"The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective."

"I found data cleaning in the solution to be quite difficult. If I could add a feature, I'd include Excel's Flash Fill function. This allows you to set a formula for one row and column and automatically apply it to thousands of rows, making data sorting much easier."

"The solution could use a faster speed on certain interactions and a refresh of the dashboards."

"We would like improvements made to the paginated reports so that it produces quality similarly to SSRS."

"I would like to see some AI incorporated into this solution in the future."

"There's always room for improvement for Microsoft Power BI, especially for the UX and the menus to make it more accessible to business users."

More Microsoft Power BI cons

"If I want to order columns, this feature is not there."

"The one area of the solution that I do hear needs improvement is on the visualization front."

"The most difficult thing I found is that it only deals with the files and does not have direct connectivity to databases."

"ThoughtSpot is a fairly new product, so some usability aspects aren't as mature as we'd like them to be. One example is their organizational methodology, like how objects are organized in their dashboards inside the product. They're all on a flat list, which works if you've got five or 10 dashboards. However, it's insufficient when you're a large enterprise with multiple groups looking at the same dashboards. It isn't organized well."

"The dashboards could give you more ability to fine tune the appearance. You get a great deal more control over how something looks in Power BI than you do in ThoughtSpot."

"A customized visualization is lacking in this product."

"I would like to see more flexibility in adding the pins. Currently, we have four different sizes in which I can add pins, but I would like to be able to resize my pins."

"In terms of features, I'd like to be able to pivot data - for example, going from rows to columns. It's not easy to do."

Pricing and Cost Advice

"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."

"My company uses IBM Cognos with another IBM product, so I think only one license is used."

"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."

"It's more expensive than similar solutions like Tableau and Power BI."

"The solution is affordable."

"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."

"Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."

More IBM Cognos pricing and cost advice

"The only other cost, besides the licensing fee, would be to cover support."

"Power BI is subscription-based, and you have three options. The Pro edition, which is the standard one, is about $9 per user. The Premium edition, which provides AI and cloud capabilities but at a limited size, is for small to medium enterprises. It is about $20 per user. For large enterprises, such as manufacturing facilities, there is an option for the capacity. The capacity subscription is about $4,000 per capacity level. They also have an option for the on-premises version, but it is not common to see someone going for the on-premises version. The on-premises version requires a specific license that is attached to SQL Server. I believe it is about $17,000, but I'm not sure about it."

"It's straightforward licensing."

"It would be better if the price was cheaper."

"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."

"Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."

"The price of Microsoft BI is reasonable. Other solutions such as SAP Cloud are more expensive."

"Pricing, that's where Microsoft beats Tableau. It is priced much cheaper."

More Microsoft Power BI pricing and cost advice

"I give the pricing a six out of ten."

See which vendors are best for you

Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.

See recommendations

816,192 professionals have used our research since 2012.

Comparison Review

it_user79932

Senior Manager - BI Head at NVidia

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…

Read full review

Top Industries

By visitors reading reviews

Educational Organization

56%

Financial Services Firm

Computer Software Company

Government

Educational Organization

41%

Financial Services Firm

Computer Software Company

Manufacturing Company

Financial Services Firm

24%

Computer Software Company

11%

Manufacturing Company

10%

Healthcare Company

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 ...

See all answers

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.

See all answers

What needs improvement with IBM Cognos?

I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...

See all answers

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...

See all answers

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...

See all answers

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 ...

See all answers

What do you like most about ThoughtSpot?

It's easy to drill down or expand data to get more details right out of the box.

See all answers

What is your experience regarding pricing and costs for ThoughtSpot?

I like the pricing structure. I get billed by how much data I put in, not how many people are looking at the data. It...

See all answers

What needs improvement with ThoughtSpot?

We'd like more flexibility with the calendar as our fiscal year does not align with the calendar year. We have to loa...

See all answers

Comparisons

Tableau vs IBM Cognos

Compared 10% of the time

Oracle Hyperion vs IBM Cognos

Compared 10% of the time

Amazon QuickSight vs IBM Cognos

Compared 8% of the time

SAP BusinessObjects Business Intelligence Platform vs IBM Cognos

Compared 7% of the time

SAP Analytics Cloud vs IBM Cognos

Compared 5% of the time

More IBM Cognos Competitors

Tableau vs Microsoft Power BI

Compared 17% of the time

Domo vs Microsoft Power BI

Compared 10% of the time

Amazon QuickSight vs Microsoft Power BI

Compared 8% of the time

KNIME vs Microsoft Power BI

Compared 6% of the time

MicroStrategy vs Microsoft Power BI

Compared 2% of the time

More Microsoft Power BI Competitors

Tableau vs ThoughtSpot

Compared 28% of the time

Looker vs ThoughtSpot

Compared 13% of the time

Databricks vs ThoughtSpot

Compared 8% of the time

Amazon QuickSight vs ThoughtSpot

Compared 8% of the time

Apache Superset vs ThoughtSpot

Compared 6% of the time

More ThoughtSpot Competitors

Product Reports

Buyer's Guide

IBM Cognos

November 2024

Download IBM Cognos product report

Buyer's Guide

Microsoft Power BI

November 2024

Download Microsoft Power BI product report

Buyer's Guide

ThoughtSpot

October 2024

Download ThoughtSpot product report

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics

SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI

No data available

Learn More

IBM

Microsoft

ThoughtSpot

Overview

IBM Cognos Business Intelligence provides a wide range of tools to help you analyze your organization's data. IBM Cognos BI allows businesses to monitor events and metrics, create and view business reports, and analyze data to help them make effective business decisions.

IBM Cognos applies techniques to describe, summarize, and compare data, and draw conclusions. This allows users to see trends and discover anomalies or variances that may not be evident by simply reading data. Data sources that contain information from different areas of a business can be stored in separate packages. Users can see only information that they have been granted access to, based on their group or role.

IBM Cognos BI consolidates the following business intelligence functions into a single web-based solution:

IBM Cognos Insight: Create personal and managed workspaces for data analysis. Using these interactive workspaces, you can share insight results with managers. Cognos Insight supports write-back, and you can also use these workspaces to capture and integrate management goals, commitments, and forecasts.
IBM Cognos Workspace: With IBM Cognos Workspace, you can create rich, interactive workspaces using IBM Cognos content as well as data from external sources. You can view and open your favorite workspaces and reports, edit content in your workspaces, and share your workspaces via email.
IBM Cognos Analytics: IBM Cognos Analytics utilizes built-in AI and intuitive searches which helps users to quickly create the visualizations and a wide range of reports. Cognos Analytics provides cognitive and managed self-service, enabling you to gain insights from controlled and trusted data.
IBM Cognos Report Studio and IBM Cognos Query Studio: Easily create structured and query reports. IBM Cognos allows users to create application and report templates. In addition, report authors can reuse report objects to apply filters, fields, and styles to reports. Users can set the language of the user interface and report content according to the user's native language.
IBM Cognos Event Studio: Receive notifications of events that occur within your organization in real time. Event Studio enables the creation of agents that detect the occurrence of business events, failures, or anomalies, based on the change of specific events or data conditions. Notification can be sent via email, publication in the portal, or by triggering reports.
IBM Cognos Connection: This is the Web portal for IBM Cognos BI and is the central area for accessing all the IBM Cognos functions. In the web portal, users can schedule and distribute reports, create tasks, administer the server and the access permissions, and more.

Reviews from Real Users

IBM Cognos stands out among its competitors for a number of reasons. Two major ones are its powerful analysis tool and its reporting capabilities.

Prasad B., a senior software engineer at a financial services firm, notes, “The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report. We can receive automated reports as well. They are easy to schedule on a weekly or monthly basis. It is very fast. I mean in means of report output, it's very fast compared to the actual clients involved.”

Microsoft Power BI is a powerful tool for data analysis and visualization. This tool stands out for its ability to merge and analyze data from various sources. Widely adopted across different industries and departments, Power BI is instrumental in creating visually appealing dashboards and generating insightful business intelligence reports. Its intuitive interface, robust visualization capabilities, and seamless integration with other Microsoft applications empower users to easily create interactive reports and gain valuable insights.

ThoughtSpot is a powerful business intelligence tool that allows easy searching and drilling into data. Its ad hoc exploration and query-based search features are highly valued, and it is easy to set up, stable, and scalable.

The solution is used for reporting purposes, self-service BI, and embedding into other applications for customers to do self-service analytics. It helps businesses with metrics, KPIs, and important insights by sourcing data from various sources into one golden source and visualizing it in an easy way for the business to consume. The pricing model is ideal, charging for data rather than the number of users.

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.

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

Primary Capital Mortgage, Sterling Backcheck, RichRelevance, Rambus, Batteries Plus Bulbs

Buyer's Guide

Microsoft Power BI vs. ThoughtSpot

October 2024

Free Report: Microsoft Power BI vs. ThoughtSpot

Find out what your peers are saying about Microsoft Power BI vs. ThoughtSpot and other solutions. Updated: October 2024.

DOWNLOAD NOW

816,192 professionals have used our research since 2012.

See our Microsoft Power BI vs. ThoughtSpot report.

See our list of best BI (Business Intelligence) Tools vendors.

We monitor all BI (Business Intelligence) Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.