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

Microsoft Power BI vs Sigma comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 1, 2025

Review summaries and opinions

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

Categories and Ranking

Microsoft Power BI
Ranking in BI (Business Intelligence) Tools
1st
Average Rating
8.0
Reviews Sentiment
7.3
Number of Reviews
321
Ranking in other categories
Reporting (1st)
Sigma
Ranking in BI (Business Intelligence) Tools
18th
Average Rating
7.6
Reviews Sentiment
8.5
Number of Reviews
6
Ranking in other categories
Data Visualization (14th)
 

Mindshare comparison

As of May 2025, in the BI (Business Intelligence) Tools category, the mindshare of Microsoft Power BI is 21.4%, down from 22.2% compared to the previous year. The mindshare of Sigma is 1.3%, up from 0.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Q&A Highlights

PS
Apr 29, 2023
 

Featured Reviews

Shoury Priyanshu - PeerSpot reviewer
Facilitates seamless data aggregation with some outdated visual elements hindering user appeal
Real-time data integration is an area for improvement. Although I've worked on several solutions involving real-time integration, it's not very user-friendly and often lags, especially with over a million data rows. This makes Power BI difficult to manage as loading times can reach one or two minutes, which is problematic today. There are challenges with scalability, requiring multiple pages in dashboards to manage these issues. Visualization could be improved as it appears outdated. Users, especially newcomers, find it unappealing and not user-friendly.
Russell Rothstein - PeerSpot reviewer
Modern dashboards and reports enhance decision-making and presentations
I would love to be able to create my own reports in Sigma, as I can do in Salesforce. Either we are not using it properly, or the software is too complicated. It would be great if there was a way for me to create reports without relying on a data analyst. I'm interested in the upcoming AI co-pilot to enable natural language generation of visualizations and reports. Also, the marketing materials did not match what I feel we've received. Regarding pricing, Sigma's pricing doesn't allow more people to have the ability to create their own reports. We have very few admin or report creator licenses, while everyone else is on a view-only mode.

Quotes from Members

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

Pros

"It integrates with all of the Microsoft tools."
"MS SQL & SQL Server Analysis Services."
"Ability to extract data from a variety of sources and systems."
"It's a powerful platform."
"Management reporting solution that's very stable and scalable."
"Considering that it's Microsoft, it can be integrated with the Power Platform, which is also Microsoft-based, like SharePoint, Power apps, Power Automate, and Power BI, which is the most user-friendly."
"The solution makes it easy for me to develop reports and publish them."
"It allows individuals to do the analysis themselves​."
"The tool's interface is easy to use. The functions listed as a part of the menu items are easy to use."
"The most valuable aspect for me is having real-time data."
"The most valuable feature of Sigma is the detailed reports."
"The most valuable feature of Sigma is the detailed reports."
"Sigma is a great software for non-technical business users. If someone's familiar with pivot tables or Excel or Google Sheets, they should be able to pick up Sigma pretty quickly. There is a very low bar for onboarding."
"I find the collaborative features, such as commenting, to be very valuable."
"Sigma serves as the visualization and reporting front end."
 

Cons

"The DAX features need some improvement. It's not as easy as Excel. They need more DAX formulas."
"I would like to see a feature that connects with a Machine Learning platform like a RapidMiner or Azure Machine Learning Studio. It would be great to have a Machine Learning application link to connect."
"It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."
"The reporting could be a bit better."
"The default parameters of the prompt could be improved by including a dynamic option."
"The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files."
"I would like to see the product offer more graphics to impact different audiences."
"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."
"I would like to see better visualization options. That would allow me to build out more visually pleasing dashboarding in Sigma."
"The only minor area for improvement lies in handling highly complex visualizations."
"Sigma could have better reports."
"Sigma could have better reports."
"Sigma lacks a versioning feature to track changes. There is a need for better structuring, like a folder system, to organize diagrams efficiently."
"The product's roadmap regarding introducing new features in the solution or new versions of the tool can be made better in the future."
"Either we are not using it properly, or the software is too complicated. It would be great if there was a way for me to create reports without relying on a data analyst."
 

Pricing and Cost Advice

"We are end-users, and we don't take care of the prices and accounting. We get a product and pay the fee to our internal service provider, but its price should be reasonable. Otherwise, they wouldn't have bought it."
"I used the tool's free version."
"Costs less than most competing solutions."
"We have premium licenses, but you can use it for free. You can share the content with anyone else, so you can use it for free."
"Microsoft BI is considered to be competitively priced when compared to other similar solutions in the market."
"It is a cheap solution for our needs."
"It is somewhere in the middle in terms of price. Licensing is quite clear."
"I'm not very familiar with the licensing aspect, as it operates in the cloud as a SaaS (Software as a Service) model. Essentially, you pay based on cloud cost models, which might include hourly rates or similar billing structures introduced by Microsoft. Many organizations utilize it and pay for its services, somewhat like Office 365. It's a cloud-based platform that provides the necessary services, including support, for development, and you pay accordingly for the usage."
"The retail price is set at one thousand dollars per creator per year."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
851,823 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…
 

Answers from the Community

PS
Apr 29, 2023
Apr 29, 2023
This market comparison chart....https://www.gartner.com/doc/re...;ct=230130&st=sb
See 2 answers
Ronald Chavez - PeerSpot reviewer
Apr 29, 2023
The two are similar, it is cars but of different brands; I ask 1-) the users use Windows 2-) you have Office 365 3-) They will use Excel for the data. If you answer yes to the 3, better BI due to integration, and learning is easier for the user. If they are non-Microsoft databases, investigate on the provider's side, for example, SAP, IBM, etc. I have trained end users in Power BI. I know that Power BI has the majority of connectors. I hope my comment is helpful. Regards
Ronald Chavez - PeerSpot reviewer
Apr 29, 2023
This market comparison chart....https://www.gartner.com/doc/re...;ct=230130&st=sb
 

Top Industries

By visitors reading reviews
Educational Organization
37%
Financial Services Firm
8%
Computer Software Company
7%
Government
5%
Computer Software Company
16%
Financial Services Firm
16%
Manufacturing Company
11%
Healthcare Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

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 would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
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 information, control users accessing information, the configuration of governance po...
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 fully customizable and very user-friendly. This solution is very stable. Oracle ...
What do you like most about Sigma?
The tool's interface is easy to use. The functions listed as a part of the menu items are easy to use.
What is your experience regarding pricing and costs for Sigma?
The pricing of Sigma is a concern, as it restricts our ability to provide more users with report-creating capabilities due to the high cost of admin or report creator licenses. Most users have view...
What needs improvement with Sigma?
I would love to be able to create my own reports in Sigma, as I can do in Salesforce. Either we are not using it properly, or the software is too complicated. It would be great if there was a way f...
 

Comparisons

 

Also Known As

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

Overview

 

Sample Customers

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
Snowflake, Fivetran ,Autodesk, Flowspace, Super League Gaming, Zumper, Clover, Volta, Olivela
Find out what your peers are saying about Microsoft Power BI vs. Sigma and other solutions. Updated: April 2025.
851,823 professionals have used our research since 2012.