Looker vs Oracle Analytics Cloud

Last Updated:

Our analysts compared Looker vs Oracle Analytics Cloud based on data from our 400+ point analysis of Business Intelligence Tools, user reviews and our own crowdsourced data from our free software selection platform.

Looker Software Tool

Product Basics

Looker is a web-based analytics solution that offers businesses the ability to explore, discover, visualize and share data insights. Enterprises can view data sources and drill down into data to better understand their business and metrics.

Using a simple proprietary modeling language, this system helps define data relationships while bypassing SQL. It facilitates data literacy and accessibility, irrespective of technical skill levels. It was acquired by Google on June 6, 2019, for $2.9 billion.
read more...

Oracle Analytics Cloud is a public cloud service on which you can build and run reporting and analytics solutions. It can also manage data from Oracle Database and Oracle Autonomous Data Warehouse. Pairing it with Oracle Data Integration can help you move and transform data at scale. But that’s not all. You can build and deploy analytics applications even with non-Oracle systems. However, the level of integration and capabilities may differ.

You’ll need an Oracle Cloud account, and a free trial is available. Oracle customizes the view for you, whether you’re a web app developer, account admin or cloud architect. Workbooks and dashboards enable data exploration. You can set it up so the system sends reports to selected users on schedule. Governed analytics is available; your data stays secure. Annotations, export options and integration with social platforms are other capabilities.

Two pricing tiers are available. The Professional edition has self-serve analytics, direct source connections and dataflows for preparing content. It costs $16 per user monthly.

The Enterprise edition lets you enrich data, connect to private sources and build semantic models. You can track usage and set encryption keys, all at a cost of $80 per user monthly. Opt for a user or consumption model based on OCPUs (Oracle CPUs).

The user reviews were an interesting read. I haven’t seen many products with such strongly divided opinions. In all positive reviews, over 70% of the users voted for a specific feature, indicating a high level of user satisfaction and perceived value. On the flip side, over 87% of users said price and a steep learning curve were blockers to successful adoption.

read more...
$2,900 Monthly
Get a free price quote
Tailored to your specific needs
$16/User, Monthly
Get a free price quote
Tailored to your specific needs
Small 
i
Medium 
i
Large 
i
Small 
i
Medium 
i
Large 
i
Windows
Mac
Linux
Android
Chromebook
Windows
Mac
Linux
Android
Chromebook
Cloud
On-Premise
Mobile
Cloud
On-Premise
Mobile

Product Assistance

Documentation
In Person
Live Online
Videos
Webinars
Documentation
In Person
Live Online
Videos
Webinars
Email
Phone
Chat
FAQ
Forum
Knowledge Base
24/7 Live Support
Email
Phone
Chat
FAQ
Forum
Knowledge Base
24/7 Live Support

Product Insights

  • Real-Time Data: Keep up to date on the most recent numbers through real-time updates to dashboards and other visualizations.
  • Local Database: Uses an organization’s proprietary database to collect data — no need to rely on parallel data pipelines or data extracts.
  • Self-Service BI: Explore data through the self-serve function and then refine the automatically generated visualizations. Create custom dashboards to reflect specific KPIs based on the business’ specific needs.
  • Virtual Schema: Create live connections to over 35 SQL databases through a code-based virtual query-time schema. Keeps data visualizations secure and up-to-date.
  • Embedded Analytics: Embeddable through SSO, it can deploy into third-party solutions like a CRM or ERP as an embedded iframe or through Javascript. Empowers other software solutions with BI capabilities including reliable data, self-service analytics, actionable insights and intuitive dashboards.
read more...
  • Leverage ML: According to our research, Oracle Analytics Cloud gets the top score of 76 for augmented analytics. The Explain and AutoML functionalities and one-click predictions give it an edge over other competitors like Qlik Sense and
  • Generate Reports: Oracle Analytics Cloud scores 93 in our analyst rankings with instant and planned reports that are interactive and accept conditional formatting. Plus, it supports text and voice searches even on the mobile app.
  • Monitor Usage: Track expenses with the Billing tab on the Oracle Cloud Console. Keep tabs on usage with a dedicated tool, Oracle Cost Analysis, included with your Oracle Cloud subscription.
  • Try for Free: Sign up for a free Oracle Cloud trial and get access to the Autonomous Database and Object Storage. You’ll need to sign in with your credit card details. The vendor deducts a token account verification amount from your card, which they return promptly. For me, it was annoying as they deducted it again three days later. Get $300 credits for 30 days to use the Analytics Cloud, Data Integration and the Container Engine for Kubernetes.
read more...
  • Automated Modeling: Connects to relational databases and automatically generates models from the database schema.
  • Intuitive Visualizations: Generates visualizations in real time directly from the specified data source. Choose from an expansive library of visualization options like bar graphs, pie charts, Sankey diagrams, spider web charts, sunburst graphs, chord diagrams, heatmaps, funnels, treemaps and many more.
  • Time Zone Handling: Incorporates data seamlessly into the visualization, regardless of what time zone it is coming from.
  • LookML Data Modeling Language: Create scalable, reusable data models through the proprietary SQL-based data modeling language LookML.
  • Pre-Built Analytics Code: Use its Blocks feature as a starting point for building data analytics models with customizable code blocks. Includes optimized SQL patterns, custom visualization options, pre-built data models and more.
read more...
  • Deployment: Install and run anywhere, including as a hybrid solution. Scale the instance depending on your workload — deploy OCPUs in multiples of two, extending up to 52. Or pause it when idle. Though identity management is available, there is the option to use one’s own SSO provider. Admins can set user, group and role-based permissions.
  • Connectivity: Make decisions based on data; connect to social media feeds, data lakes and IoT sources. Store and process data at scale, irrespective of its volume, velocity and variety. Get started as soon as you log in with over 40 readymade connectors.
  • Direct Query: Oracle Analytics Cloud uses live queries and data caching to fetch responses. Each has its downside. Live connections are heavier on the system, and you might have to compromise on data freshness with data caching. A combination of both might be best. Consider live queries for critical KPIs and data caching for less frequent queries.
  • Data Preparation: Enrich data from the interface — get data quality insights as you work. Remove the grunt work — create reusable flows for transforming data you can test, share and schedule. Add custom calculations or write regular expressions in the dataset editor.
  • Semantic Data Modeling: Engage business, dev and data teams in meaningful discussions. Give them data views with a presentation layer that simplifies metrics. Hide the physical data structure with a logical one that speaks the business language. Give stakeholders the power to explore data independently.
  • AI/ML: Boost productivity with embedded machine learning and natural language insights every step of the way. Display quick forecasts, trend lines and clusters from a popup menu with one click. View the basic facts, key drivers and anomalies with the Explain option. Hit the ground running with recommendations on dimensions, measures and attributes to use when you don’t know where to start.
  • Oracle Analytics Publisher: Generate reports from any dataset or semantic model. Create formatted documents unique to your business, be it shipping labels, checks, letters or PDF forms.
  • Data Visualizations: Put your best foot forward with suitable charts and graphs that convey your message effectively. Modify them to answer users’ questions better. Choose from over 45 visualization types, or build your own using extensions from its vast library.
  • Embedded AI On Mobile: Get real-time alerts and intelligent recommendations on mobile. The Oracle Analytics mobile app captures your preferences and location. Upload datasets just like on the desktop or create a workbook from existing data. Powerful searches enable access to your favorite worksheets; add them to your home screen for a quick view. Use voice-enabled searches and listen to the results as a podcast.
read more...

Product Ranking

#4

among all
Business Intelligence Tools

#10

among all
Business Intelligence Tools

Find out who the leaders are

Analyst Rating Summary

we're gathering data
89
we're gathering data
88
we're gathering data
82
we're gathering data
100
Show More Show More

Analyst Ratings for Functional Requirements Customize This Data Customize This Data

Looker
Oracle Analytics Cloud
+ Add Product + Add Product
Advanced Analytics Augmented Analytics Data Management Data Pre-processing Data Transformation Data Visualization Embedded Analytics Capabilities Geospatial Visualizations And Analysis Mobile Capabilities Platform Capabilities Reporting 88 82 100 100 100 100 71 100 79 83 98 0 25 50 75 100
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
69%
31%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
69%
23%
8%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
71%
0%
29%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
71%
0%
29%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
78%
0%
22%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%

Analyst Ratings for Technical Requirements Customize This Data Customize This Data

we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
96%
0%
4%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%

User Sentiment Summary

Great User Sentiment 1836 reviews
Great User Sentiment 719 reviews
88%
of users recommend this product

Looker has a 'great' User Satisfaction Rating of 88% when considering 1836 user reviews from 5 recognized software review sites.

84%
of users recommend this product

Oracle Analytics Cloud has a 'great' User Satisfaction Rating of 84% when considering 719 user reviews from 4 recognized software review sites.

5.0 (20)
n/a
4.4 (1070)
4.0 (228)
4.6 (141)
n/a
n/a
4.1 (59)
4.4 (371)
4.3 (316)
4.1 (234)
4.3 (116)

Awards

we're gathering data

SelectHub research analysts have evaluated Oracle Analytics Cloud and concluded it earns best-in-class honors for Augmented Analytics, Data Pre-processing and Geospatial Visualizations and Analysis.

Augmented Analytics Award
Data Pre-processing Award
Geospatial Visualizations and Analysis Award

Synopsis of User Ratings and Reviews

Reporting: Looker features strong reporting features that offer a degree of granularity and scheduling that 100% of users who mention reporting evaluate as a strong benefit.
Support: Of the users who say they’ve contacted customer support, 95% say the team’s quick and informative responses are a plus.
Data Accessibility: All users who mention accessibility to data say Looker does this well, distributing insights to employees across departments and teams with ease, with 100% of users mentioning this feature believing it is a benefit.
Show more
User-Friendly: Citing its interface, about 91% of users agreed that a drag-and-drop UI makes it easy to use.
Machine Learning: Around 86% of users who discussed augmented analytics were impressed with its ML capabilities.
Integrations: Approximately 84% of users who mentioned connectivity said the platform worked well with other systems, especially Oracle products.
Functionality: According to 83% of users who reviewed capabilities, it has all the required features to support data tasks.
Data Visualization: Around 73% of users who mentioned visualization praised the platform for its storytelling features.
Show more
Learning Curve: About 74% of users who touch on the platform’s ease of use say that the confusing documentation, lack of training opportunities and difficulty of using programming language make Looker a tough tool to pick up as a beginner.
Setup: Of the users who mention implementation, 81% say that setting up the platform is difficult, with integrations not being as plug-and-play as competitors and assistance from IT necessary to the setup process.
Speed: Approximately 87% of users who comment on the platform’s speed say that it is slow to render certain queries and often takes a while to load.
Functionality: About 78% of users who talk about Looker’s features say that they are left wanting many functions and find the ones that it does have limited in customization or too complex to use easily.
Show more
Price: About 88% of reviews citing pricing said that it’s too expensive.
Adoption: Approximately 87% of users who discussed onboarding said there’s a significant learning curve.
Show more

Looker is a forerunner in the business intelligence field for a reason; it generates reports that include easy sharing via link, automatic scheduling and a level of granular detail that allows for deeper analysis below the surface. It excels in its filter and drill-down features and creates unique URLs when users make changes to data, leading to enhanced sharing. However, one of its biggest strengths could also be considered one of its biggest weaknesses: its proprietary programming language, LookML which is used to construct SQL queries in the platform. While a flexible and powerful data querying language, of course, LookML isn’t the most accessible to non-technical users, which means that Looker requires an IT or data team to access its full capabilities and has a steep learning curve. Users also note that its data visualizations, while simple and easy to understand, are quite basic and lacking in customization options, particularly in comparison to competitors. Some users say that it may be more appropriate for internal reporting than presentation to shareholders and end-users because of its bare-bones visualization options. However, Looker truly shines when used by enterprises, with its scalability and data accessibility making it a stellar solution that can align departments and provide thousands of users access to data insights. Its price point reflects this, with its pricing being prohibitive to startups as about 88% of users who comment on its cost remark. Overall, Looker is a solid pick for larger businesses that have a team of power users who can maximize its functionality and set it up to deliver to employees across an entire organization.

Show more

Oracle Analytics Cloud is among the vendor’s many data services, including a business intelligence suite and a data intelligence platform. Besides, Oracle offers bespoke solutions for HCM, supply chain and customer experience. What differentiates Oracle Analytics is that extra dash of augmented capabilities.Embedded BI is where it truly shines, giving you natural language insights with a single click. This feature extends to its mobile app, and it outperforms many leading platforms with natural language queries and podcasts on mobile.According to our researchers, Oracle Analytics Cloud has fewer out-of-the-box features than its competitors, such as Power BI and Qlik Sense. Plus, licensing becomes complex when combining the database, middleware and analytics applications.It’s common for large vendors to offer specialized platforms, but the downside is that they can be out of reach of small organizations. But there’s a silver lining. Many vendors offer customized solutions, so we advise reaching out to the vendor for quotes.Users appreciate its regular updates, but some report initial bugs due to its relative newness. Despite a positive user experience, the learning curve can be steep. Some users found technical support slow and inadequate, as did I. They took two business days to get back to me when I needed assistance with my account.Oracle Analytics, though a robust platform, is suitable for mid- and large organizations. If you seek a powerful, scalable platform, consider opting for a trial, but be prepared for sticker shock, especially if you’re new to the Oracle ecosystem.

Show more

Screenshots

Top Alternatives in Business Intelligence Tools


Cognos Analytics

Domo

GoodData

Grow

Logi Symphony

Looker Studio

MicroStrategy

Oracle Analytics Cloud

Power BI

Qlik Sense

QuickSight

SAP Analytics Cloud

SAS Visual Analytics

Sisense

Spotfire

Tableau

Related Categories

Head-to-Head Comparison

WE DISTILL IT INTO REAL REQUIREMENTS, COMPARISON REPORTS, PRICE GUIDES and more...

Compare products
Comparison Report
Just drag this link to the bookmark bar.
?
Table settings