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

Looker vs Microsoft Power BI vs SAS Visual Analytics comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Mindshare comparison

Embedded BI
BI (Business Intelligence) Tools
Data Visualization
 

Featured Reviews

Kishore Jhunjhunwala - PeerSpot reviewer
A cloud solution for operational reporting but is expensive
Some basic feature that is available in other reporting tools is missing. Looker has the ability to show more than 5,000 rows for operational reporting. Some reporting tools allow users to scroll down to see more than 5,000 rows, but in Looker, you have to download the entire dataset. Looker should consider adding a scroll-down option to allow users to view large datasets on screen without downloading them. Looker has some options for granting users access as viewers. However, viewers cannot download the entire dataset. Only superusers can download the whole dataset on the Explore screen. This is a big limitation, as you cannot give any user viewer access. You can give access to superuser access, which is a cost to the company.
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.
Danna Nemeth - PeerSpot reviewer
Provides ease of use and has advanced data visualization capabilities
The initial setup can be complex and depends on the specific environment and licensing. It typically requires some time and effort to configure properly. It can be deployed as a SaaS solution or on-premises. It typically requires an installer and someone knowledgeable in business analytics and data management. Generally, it does not require extensive maintenance, though occasional upkeep might be necessary.

Quotes from Members

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

Pros

"We can centralize all our data models."
"Looker allows you to generate the most optimal SQL queries in a DC through UI actions. We had signed a contract with Google Cloud to use BigQuery. That was the primary reason we adopted Looker. It works better with BigQuery than any other BI platform. We also like how this tool was developed. It was designed with an eye toward microservices architecture."
"I would rate the stability a ten out of ten. I didn't face any issues with stability."
"The product is easy to use."
"The stability of Looker has been good since I have been using it. However, it depends on what components are being used."
"It's quite effortless to navigate through various applications and review their updated data in real-time."
"It is a pretty stable solution because it is a cloud-based product."
"With Looker, I have experienced benefits in terms of usability and shareability."
"Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports."
"One of the most valuable aspects of this tool is its ease of use and the ability to easily share information with others."
"The product can go easily go and extract data and it can put it into any format."
"Its ease of use is most valuable."
"Two valuable most features are the ability to create columns and create measures."
"Allows business users with a mission to solve their own problems, without an IT person."
"It integrates with all of the Microsoft tools."
"ou can pull reports, visualize them in real-time, and connect them to a variety of other data sources."
"The product is stable, reliable, and scalable."
"The flexibility of the configuration is valuable to me."
"What I really love about the software is that I have never struggled in implementing it for complex business requirements. It is good for highly sophisticated and specialized statistics in the areas that some people tend to call artificial intelligence. It is used for everything that involves visual presentation and analysis of highly sophisticated statistics for forecasting and other purposes."
"It's quite easy to learn and to progress with SAS from an end-user perspective."
"I like SAS Visual Analytics for its ability to provide an initial understanding of data through exploration, even before deep analytics."
"I would rate the overall solution a ten out of ten."
"We've found the product to be stable and reliable."
"It provided the capability to visualize a bunch of data in an organized way."
 

Cons

"The visualization capability of the product is limited."
"The integration with different databases must be improved."
"The product does not have documented material."
"Looker doesn't connect to Excel, which is a huge disappointment because a lot of data is presented in Excel. Also, it can't consume data directly from REST APIs, which is necessary. Looker needs to expand its horizons when it comes to data sources. The inability to connect to different data sources is hampering our use cases. Currently, it only has an ODBC connection that connects to a database. It needs to connect to other data sources, such as Excel, APIs, and different platforms."
"The main area of concern in Looker is probably related to blending the data from the different sources, including the data present internally in the company and on the cloud."
"Integrations with other BI tools could be better."
"It needs to be more user-friendly."
"Stability needs improvement."
"Microsoft BI's visualization could be better. Though Power BI's visualization has steadily improved over the years, it's not on the level tools like Tableau and SAS or some of the more expensive products on the market."
"The setup took a lot of tinkering with InfoSec to allow us to do stuff."
"I have observed issues regarding stability."
"When I create measures, sometimes the error messages aren't clear. It makes me spend more time searching for solutions. I need the error messages to be more specific. So, I would like clearer error messages when creating measures."
"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."
"Integration with artificial intelligence would help. Humans take time to review the data and eliminate errors. Artificial intelligence based on machine learning and understanding can bring the same functionality."
"The visualization aspect, while being the most visible to business users, also happens the be the weakest point in the entire Microsoft BI stack."
"There are some limitations in Power BI; you have to work in the Power BI base. However, if you want something not out-of-the-box and you want something custom, you have to do a lot of work."
"The visualization should be better in SAS Visual Analytics. It is easy to use but when compared to other solutions it is lacking and the support is not very good."
"Some capabilities are missing compared to Power BI, especially when working with spreadsheet types."
"There is room for improvement in anti-money laundering prevention and operation monitoring, as well as operation monitoring surveillance."
"In Brazil, there are few documents, courses, and other resources for studying and implementing the tool."
"The licensing ends up being more expensive than other options."
"The integration aspects of the solution could be improved."
"There are a few little things that are predefined and can be done out of the box immediately. There is no business intelligence application that is predefined, which is something some customers or prospects would love to have. Small and mid-sized companies would struggle with it because they prefer something standard that has been predefined by somebody else."
"The deployment isn't smooth. Deploying Visual Analytics on the cloud takes a lot of work, or you can use some providers that give you SAS as a service. For example, there is a provider called SaasNow. They host SAS Visual Analytics and the license. You can buy the license and deploy it there without the hassle of installation because deploying the software isn't easy."
 

Pricing and Cost Advice

"Looker is expensive and could be made better by reducing it."
"It's not cheap, but it's not expensive for big companies."
"I do not have to make any payments to use the solution."
"It is cheap."
"The price of Looker usually depends on the solution's provider, but it is usually cheaper than the other products in the market. Looker is offered at different prices for different companies."
"We have enterprise licenses and some of the other tools or features come as a package and others you have to purchase separately."
"Price is the best feature of Power BI! You get a lot of value for the price. If you know how to use it, it's a great BI solution for your money."
"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."
"For my primary use case, i.e. teaching students, the free version of Power BI is adequate."
"MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution."
"The solution’s pricing is reasonable."
"We pay on a monthly basis which is approximately $10 per user on the Microsoft Power BI Pro license. At the moment we are still down at 400 users, but once we reach 500 users, we will move to the premium edition. The premium is $5,000 for unlimited users. Currently, with the 40 users, the cost is roughly $500."
"No comment on pricing."
"The product is quite expensive."
"It was licensed for corporate use, and its licensing was on a yearly basis."
"It's approximately $114,000 US dollars per year."
"SAS Visual Analytics is expensive, as is the rest of the platform."
"I work with the tool's free version...The tool's corporate version is very expensive and requires a monthly hire."
"Licensing is simple."
"The cost of the solution can be expensive. There is an additional cost for users."
"Visual Analytics is expensive for a small company like mine. You also need to deploy it on a server or cloud, so you pay for the license as well as the cost of the cloud or the server that you will deploy on."
report
Use our free recommendation engine to learn which Embedded BI solutions are best for your needs.
862,077 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
Financial Services Firm
14%
Computer Software Company
13%
Educational Organization
8%
Manufacturing Company
7%
Educational Organization
14%
Financial Services Firm
11%
Computer Software Company
9%
Government
8%
Financial Services Firm
21%
Government
11%
Computer Software Company
10%
University
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Looker?
With Looker, I have experienced benefits in terms of usability and shareability.
What is your experience regarding pricing and costs for Looker?
I do not have to make any payments to use the solution. In the beginning, Looker may work fine for its users. If adva...
What needs improvement with Looker?
The visualization capability of the product is limited. From an improvement perspective, the product should have more...
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 ...
What do you like most about SAS Visual Analytics?
The most solution's notable aspect, in my view, is the ability to integrate various data sources and harness advanced...
What is your experience regarding pricing and costs for SAS Visual Analytics?
It's about an average of five. It's easy to scale, but it comes with cost.
What needs improvement with SAS Visual Analytics?
In terms of configuration, I would like to see AI capabilities since many applications are now integrating AI. It may...
 

Also Known As

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

Overview

 

Sample Customers

Yahoo!, Etsy, Kohler, Hipcamp, Hubspot, Kickstarter, Venmo, Dollar Shave Club, 600+ customer
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
Staples, Ausgrid, Scotiabank, the Australian Institute of Health and Welfare, the Blue Cross and Blue Shield of North Carolina, Oklahoma Gas & Electric, Xcel Energy, and Triad Analytics Solutions.
Find out what your peers are saying about Salesforce, MicroStrategy, Qlik and others in Embedded BI. Updated: June 2025.
862,077 professionals have used our research since 2012.