Azure Analysis Services vs. Looker

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure Analysis Services
Score 8.5 out of 10
N/A
Azure Analysis Services delivers enterprise-grade BI semantic modeling capabilities with the scale, flexibility, and management benefits of the cloud. Azure Analysis Services helps transform complex data into actionable insights. Azure Analysis Services is built on the analytics engine in Microsoft SQL Server Analysis Services.N/A
Looker
Score 8.2 out of 10
N/A
Looker is a BI application with an analytics-oriented application server that sits on top of relational data stores. It includes an end-user interface for exploring data, a reusable development paradigm for data discovery, and an API for supporting data in other systems.N/A
Pricing
Azure Analysis ServicesLooker
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Azure Analysis ServicesLooker
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeRequired
Additional DetailsMust contact sales team for pricing.
More Pricing Information
Community Pulse
Azure Analysis ServicesLooker
Top Pros

No answers on this topic

Top Cons

No answers on this topic

Features
Azure Analysis ServicesLooker
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Azure Analysis Services
8.7
9 Ratings
7% above category average
Looker
8.1
96 Ratings
1% below category average
Pixel Perfect reports8.99 Ratings7.680 Ratings
Customizable dashboards8.78 Ratings8.895 Ratings
Report Formatting Templates8.59 Ratings7.981 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Azure Analysis Services
8.9
9 Ratings
10% above category average
Looker
8.1
96 Ratings
0% above category average
Drill-down analysis9.07 Ratings8.293 Ratings
Formatting capabilities8.98 Ratings7.494 Ratings
Integration with R or other statistical packages8.98 Ratings8.039 Ratings
Report sharing and collaboration9.09 Ratings8.696 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Azure Analysis Services
9.0
9 Ratings
8% above category average
Looker
8.6
92 Ratings
3% above category average
Publish to Web9.19 Ratings8.576 Ratings
Publish to PDF8.98 Ratings8.782 Ratings
Report Versioning9.48 Ratings8.262 Ratings
Report Delivery Scheduling9.09 Ratings8.982 Ratings
Delivery to Remote Servers8.78 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Azure Analysis Services
9.1
8 Ratings
12% above category average
Looker
6.8
93 Ratings
17% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)9.37 Ratings8.191 Ratings
Location Analytics / Geographic Visualization9.18 Ratings7.580 Ratings
Predictive Analytics8.77 Ratings4.66 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Azure Analysis Services
9.3
9 Ratings
9% above category average
Looker
8.5
92 Ratings
0% below category average
Multi-User Support (named login)9.38 Ratings8.987 Ratings
Role-Based Security Model9.39 Ratings8.380 Ratings
Multiple Access Permission Levels (Create, Read, Delete)9.29 Ratings8.687 Ratings
Single Sign-On (SSO)9.58 Ratings00 Ratings
Report-Level Access Control00 Ratings8.428 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Azure Analysis Services
8.8
8 Ratings
10% above category average
Looker
5.8
68 Ratings
31% below category average
Responsive Design for Web Access8.58 Ratings6.765 Ratings
Mobile Application9.54 Ratings5.01 Ratings
Dashboard / Report / Visualization Interactivity on Mobile8.56 Ratings6.559 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Azure Analysis Services
8.9
8 Ratings
12% above category average
Looker
-
Ratings
REST API8.97 Ratings00 Ratings
Javascript API8.77 Ratings00 Ratings
iFrames9.06 Ratings00 Ratings
Java API8.98 Ratings00 Ratings
Themeable User Interface (UI)8.65 Ratings00 Ratings
Customizable Platform (Open Source)9.24 Ratings00 Ratings
Best Alternatives
Azure Analysis ServicesLooker
Small Businesses
BrightGauge
BrightGauge
Score 9.0 out of 10
BrightGauge
BrightGauge
Score 9.0 out of 10
Medium-sized Companies
Reveal
Reveal
Score 9.9 out of 10
Reveal
Reveal
Score 9.9 out of 10
Enterprises
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure Analysis ServicesLooker
Likelihood to Recommend
9.1
(10 ratings)
8.4
(97 ratings)
Likelihood to Renew
-
(0 ratings)
9.0
(4 ratings)
Usability
-
(0 ratings)
8.8
(12 ratings)
Support Rating
-
(0 ratings)
8.8
(14 ratings)
User Testimonials
Azure Analysis ServicesLooker
Likelihood to Recommend
Microsoft
We would have many technical issues and glitches with previous similar providers but found that Azure Analysis Services can simply handle our workload and memory better. I remember we lost an account due to cloud issues not fully saving or corrupting some files. Granted, this is rare with any cloud but haven't had that issue with the same load of memory with Azure Analysis Services.
Read full review
Google
Quick dashboards from Google Sheets - Easier to do the graphs than in Google Sheets - Operational dashboards to be used in the day-to-day work - It is good both for retrospective data and to do a pulse check of the current status - Better for not giant amounts of data and not multiple data sources. - If you need a lot of graphs to be displayed on the same page, it can be a bit glitchy during configuration (then the use works fine).
Read full review
Pros
Microsoft
  • Providing role based access or we can say privilege based on the role to the user if it is integrated with Azure active directory and hence securing the access to sensitive data.
  • We use to run different type of analytics services to get the better result which is hectic if done manually or with human efforts.
  • We also use to collect bulk of data with the help of this tool and run customized test cases for better efficiency of result and better decision making. The result are very crucial and helps in taking big decision.
  • It supports different or we can say heterogeneous database vendors like the Oracle, SQL, and hence make the task easy.
Read full review
Google
  • Filtering - you can filter across different dimensions and metrics to get a more specific "cut" of data
  • Refreshing - data automatically ingests into Looker which allows reports to be updated and backfilled in real time
  • Conditional Reporting - you can leverage Looker's reporting features to flag when a given metric or KPI falls below or above a specified threshold. For example, if you had a daily sales benchmark in a SAAS organization, you could use Looker to flag whenever daily sales falls above or below the benchmark
Read full review
Cons
Microsoft
  • There is very least content available on Microsoft docs and the Internet to get through with AAS.
  • i faced lots of connection issues while implementation.
  • The need for serious platform experience or expertise.
Read full review
Google
  • Looker is less graphical or pictorial which makes it less attractive
  • Consumes a lot of memory when there are multiple rows and columns, impacts performance too
  • At times when we download huge chunks of raw data from Looker dashbords, the time taken to prepare the file is enormous - The user fails to understand if Looker has frozen or if the data is getting prepared in the background for downloading. In turn, user ends up triggering multiple downloads
Read full review
Likelihood to Renew
Microsoft
No answers on this topic
Google
We've been very happy with Looker so far, and all teams in the organization are starting to see its value, and use it on a frequent basis. It has quickly become our accessible "source of truth" for all data/metrics.
Read full review
Usability
Microsoft
No answers on this topic
Google
Looker is relatively easy to use, even as it is set up. The customers for the front-end only have issues with the initial setup for looker ml creations. Other "looks" are relatively easy to set up, depending on the ETL and the data which is coming into Looker on a regular basis.
Read full review
Support Rating
Microsoft
No answers on this topic
Google
Never had to work with support for issues. Any questions we had, they would respond promptly and clearly. The one-time setup was easy, by reading documentation. If the feature is not supported, they will add a feature request. In this case, LDAP support was requested over OKTA. They are looking into it.
Read full review
Alternatives Considered
Microsoft
The platform has vast number of features and modules. The UI is sleek and once you get to use to it, you will be able to do a lot of stuff. Also support for data sources is more in Azure Analysis Services.
Read full review
Google
Looker is an off-the-shelf, free tool for Google business users. Other than the internal cost of time to build, we had no costs to set up what we needed to do. Knowledge sharing internally and using templates greatly reduced this cost, making the overall cost very low.
Read full review
Return on Investment
Microsoft
  • Azure Analysis Service scale resources to match our business needs.
  • Helps us to govern, deploy, test and deliver our BI solution with confidence.
  • Stores our business data and clients data in a safe place where it's easy to access and visible to all our teams.
Read full review
Google
  • Allowing others to self-serve their own analytics and connect it to Looker simply and easily has helped unblock the central data team so they can instead focus on validated dashboards whilst stakeholders manage their day-to-day analysis themselves. Countless engineering hours have been freed up by not having to manage every user permission for each BI tool; we have a BYOBI approach; Bring Your Own BI
  • Creation and management of a semantic layer (LookML =Looker Modeling Language ) allows peoples sandboxes and production databases to become clutter free. Minor adjustments, conditional fields, and even some modelling can all be done in LookML which doesn't need oversight or governance from the central data team.
  • LookML, specifying drilldown fields and their sub-queries, as well as generally creating dynamic parameters with Liquid are all great features, but can have a steep learning curve. it may take some time to understand how to create this middle layer correctly, or even pose a risk of inheriting complex code from another source which can be unmaintainable if it becomes too big. Some level of governance is recommended if Looker is used by a large number of editors.
Read full review
ScreenShots

Looker Screenshots

Screenshot of a Looker dashboard with a geo chart.