Looker vs. MicroStrategy Analytics

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Looker
Score 8.6 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
MicroStrategy Analytics
Score 8.5 out of 10
N/A
MicroStrategy Analytics is an enterprise business analytics and mobility platform. Key features include automatic big data analysis and reporting, data discovery and visualization, digital security credentials, and support for mobile devices.N/A
Pricing
LookerMicroStrategy Analytics
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
LookerMicroStrategy Analytics
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeRequiredNo setup fee
Additional DetailsMust contact sales team for pricing.Must contact sales team for pricing information.
More Pricing Information
Community Pulse
LookerMicroStrategy Analytics
Features
LookerMicroStrategy Analytics
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Looker
8.5
Ratings
4% above category average
MicroStrategy Analytics
10.0
Ratings
20% above category average
Pixel Perfect reports8.40 Ratings10.00 Ratings
Customizable dashboards8.90 Ratings10.00 Ratings
Report Formatting Templates8.20 Ratings10.00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Looker
8.4
Ratings
4% above category average
MicroStrategy Analytics
10.0
Ratings
22% above category average
Drill-down analysis8.10 Ratings10.00 Ratings
Formatting capabilities7.70 Ratings10.00 Ratings
Integration with R or other statistical packages8.60 Ratings10.00 Ratings
Report sharing and collaboration9.10 Ratings10.00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Looker
8.7
Ratings
5% above category average
MicroStrategy Analytics
10.0
Ratings
19% above category average
Publish to Web8.20 Ratings10.00 Ratings
Publish to PDF9.00 Ratings10.00 Ratings
Report Versioning8.50 Ratings10.00 Ratings
Report Delivery Scheduling9.10 Ratings10.00 Ratings
Delivery to Remote Servers00 Ratings10.00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Looker
6.9
Ratings
14% below category average
MicroStrategy Analytics
10.0
Ratings
23% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)8.00 Ratings10.00 Ratings
Location Analytics / Geographic Visualization8.00 Ratings10.00 Ratings
Predictive Analytics4.60 Ratings10.00 Ratings
Pattern Recognition and Data Mining00 Ratings10.00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Looker
8.2
Ratings
3% below category average
MicroStrategy Analytics
10.0
Ratings
16% above category average
Multi-User Support (named login)8.70 Ratings10.00 Ratings
Role-Based Security Model8.00 Ratings10.00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)8.00 Ratings10.00 Ratings
Report-Level Access Control8.00 Ratings10.00 Ratings
Single Sign-On (SSO)00 Ratings10.00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Looker
6.1
Ratings
25% below category average
MicroStrategy Analytics
9.7
Ratings
21% above category average
Responsive Design for Web Access7.30 Ratings10.00 Ratings
Mobile Application5.00 Ratings10.00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile7.20 Ratings10.00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Looker
-
Ratings
MicroStrategy Analytics
10.0
Ratings
25% above category average
REST API00 Ratings10.00 Ratings
Javascript API00 Ratings10.00 Ratings
iFrames00 Ratings10.00 Ratings
Java API00 Ratings10.00 Ratings
Themeable User Interface (UI)00 Ratings10.00 Ratings
Customizable Platform (Open Source)00 Ratings10.00 Ratings
User Ratings
LookerMicroStrategy Analytics
Likelihood to Recommend
8.7
(0 ratings)
10.0
(0 ratings)
Likelihood to Renew
9.5
(0 ratings)
9.9
(0 ratings)
Usability
8.8
(0 ratings)
3.2
(0 ratings)
Availability
10.0
(0 ratings)
9.0
(0 ratings)
Performance
6.0
(0 ratings)
9.0
(0 ratings)
Support Rating
8.8
(0 ratings)
2.2
(0 ratings)
Online Training
-
(0 ratings)
9.0
(0 ratings)
Implementation Rating
10.0
(0 ratings)
9.0
(0 ratings)
Configurability
10.0
(0 ratings)
9.0
(0 ratings)
Ease of integration
10.0
(0 ratings)
-
(0 ratings)
Product Scalability
10.0
(0 ratings)
9.0
(0 ratings)
Vendor post-sale
10.0
(0 ratings)
10.0
(0 ratings)
Vendor pre-sale
10.0
(0 ratings)
10.0
(0 ratings)
User Testimonials
LookerMicroStrategy Analytics
Likelihood to Recommend
When you need to create a centralised dashboard for multiple stakeholders that blends cross-channel reporting. As an SEO agency reporting for clients - Looker is a great solution. It's less appropriate depending on the intended users. For instance, in my experience Looker reports have been under-utilised because they're not accessed regularly, provide too much noise or often simple PDF reports are preferred
Read full review
MSTR is great for any organization that is looking for a way to deliver complicated data in an uncomplicated way. From business teams to marketing and finance, several departments benefit from using MSTR to keep track of KPIs enabling teams to make optimizations along the way. MSTR provides great visual representations of data enabling team members to distill thousands of data points into easily digestible charts and graphs
Read full review
Pros
  • It is very easy to start a new dashboard and configure what you want to display by just selecting/dragging from the list of available columns.
  • It is intuitive, mainly if you use other Google services like Google Sheets.
  • The look and feel is modern and nice.
  • It it very useful to have an immediate visual overview of the data in a spreadsheet.
Read full review
  • I think the dashboards are quite helpful to visualize on the spot data.
  • Creation of facts and attributes is simple - I have no programming experience and was still able to create and modify these items.
  • Scheduling reports to be run on a daily, weekly, or hourly basis is simple. It provides updated data on a timed basis with no need to go back into the program.
Read full review
Cons
  • I wish I could get more granular in the Google ad data, such as down to the campaign type, instead of having to see only all campaigns.
  • The setup can be time-consuming if you're not using the product regularly.
  • Editing the dashboard requires a few logins; I wish it was more seamless.
Read full review
  • Visual Insight have multiple limitations. Few of them are listed here - i)Cannot change default graph colors ii) text/graph formatting are very very limited iii)Add metric to Color by / Thresholds is not possible iv)one of the worst limitation of the VI in older versions is that it is not possible to create filters that apply only to a specific visualization. For example if there are 4 graphs in one dashboard & if you have filters then those filters would be applicable for all of them
  • Some formatting options are not there either on Web or Developer especially while dealing with a document. We have to use both Web & Developer to solve issues.
  • While connecting with MDX cube reporting loses a lot of features.
Read full review
Likelihood to Renew
We are very haooy with Looker, it provides us with all the funciomalities we need for both the day to day oerformance tracking and longer periods reporting. It is easy to use for account managers, configurable and customizable for soecialists and what is most imoortant, our clinets generally really love it
Read full review
I would always choose to renew MicroStrategy as long as they lead the market in features, functionality and price. The support of MicroStrategy is timely and professional, I frequently get answers to my questions within 24 hours and normally have solutions within 48 hours. Training available for MicroStrategy completely covers everything required to be able to expertly use MicroStrategy and understand data warehousing.
Read full review
Usability
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
Overall for most functions it is incredibly easy to use and understand - however more complicated features are very technical and require training skill. There is the possibility of creating reports that return inaccurate information if you do not have a solid understanding of the information.
Read full review
Reliability and Availability
No objections
Read full review
I've never had an issue with MicroStrategy not being available due to MicroStrategy application malfunction. It is very robust and only failures I've seen were due to user error or the platform the machine running the service failed some how.
Read full review
Performance
Somehow resources heavy, both on server and client. I recommned at least 50Mbs data rate and high performance desktop comouter to be abke to run comolex tasks and configure larger amount of data. On the other hand, the client does not need to worry when viewing, the performance is usually ok
Read full review
Being able to customize the performance based on the business need is extremely powerful. Proper configuration and understanding of the usage pattern is key, if the technical ability of the architect is not at top level, then the product will not be configured correctly which will lead to poor performance.
Read full review
Support Rating
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
[I feel as if] they answer the phone quickly, but can't answer any of your questions. Will get lost in a support ticketing system. Better off finding third-party online forums of MicroStrategy Analytics users huddled together trying to help each other do the most basic things.
Read full review
Online Training
No answers on this topic
I have attended many trainings offered by MicroStrategy; both distance and in-person training. I earned my CRD (Certified Report Developer) certification via the online training. I found the training to be well organized and concise. Overall I will definitely continue to increase my knowledge with MicroStrategy via the online training offering.
Read full review
Implementation Rating
Very satisfied, easy to implement
Read full review
We measured following KPI for the success
  • Increase in Business Feeds Loads
  • Reduction in Controllers Manual Work.
  • Conversion of Manual Work into Systematic Workflows.
  • Increase in Customer Spend
  • Reduction in Service costs
  • Reduction in time-to-market for new campaigns
  • Increase in cross sell and Up sell
  • Error reduction in customer Identification
  • Existing client retained
Read full review
Alternatives Considered
In my opinion, Looker is no Power BI. It is good, but I think Power BI is amazing. That said, in my experience, Power BI is nowhere near as easy to setup and report on Google services as Looker is. We plan to continue using Power BI for c-suite and corporate reporting, especially for internal databases, but will gladly use Looker for our marketing information for AdWords, Analytics, Search Console, and YouTube.
Read full review
[I feel like} Microsoft BI - MicroStrategy Analytics is worse in every way. Less templates, less canned reports, less third party integrations, less knowledgable consultants/employees, less core capability, much worse migration path to the cloud (Azure in Microsoft's case), and ultimately turned out to be higher cost when we had to start adding modules and pay for professional services to do even the most basic reporting Google Charts - Not as fare comparison since this is a free SaaS product, but when we couldn't get things working with MicroStrategy Analytics, we starting using Charts just to get data out the door for the company. Amazing how easy it is, and free. Provides WAY more robust capabilities in your web browser for free.
Read full review
Scalability
No answers on this topic
This software is extremely scaleable, one can add more core servers which performs as a load balancing. The configurations available to manage usage patterns and daily activity are as high a caliber as any other enterprise level software. This product can be installed on both a windows and unix platform allow for integration on a budget.
Read full review
Return on Investment
  • Other than some people not liking the numbers, I don't see any negative impacts; we haven't experienced that.
  • The reports help us unravel the story of our users and how they are sifting through our pages.
  • Our clients enjoy seeing the numbers to understand better what stands out on their sites.
  • The reports have helped us see what campaigns are working and where we need to tweak things.
  • The reports have enabled us to have better conversations with stakeholders about how their web pages should be modified, edited, etc., to reflect the data.
Read full review
  • MicroStrategy was helpful for reducing the amount of time we needed to spend number crunching large data sets, and in doing so, allowed me as the primary users to spend more time gleaning insights from the data that in turn informed our leadership team to make strategic decisions.
  • By creating numerous canned reports available to all members of the team through email distribution or basic access to the platform, we were able to reduce the time I spent showing people how to pull the data in Microsoft Excel by nearly 40% .
  • We ended up needing to make many changes to the way our DMP was feeding data into MicroStrategy due to incorrect reporting that caused complications in accounting and finance.
Read full review
ScreenShots

Looker Screenshots

Screenshot of a Looker dashboard with a geo chart.