1 What Is Oracle Analytics Cloud?

Let’s first explore Oracle Analytics Cloud and how you can take advantage of its features.

Topics:

About Oracle Analytics Cloud

Oracle Analytics Cloud is a scalable and secure public cloud service that provides a full set of capabilities to explore and perform collaborative analytics for you, your workgroup, and your enterprise.

With Oracle Analytics Cloud you also get flexible service management capabilities, including fast setup, easy scaling and patching, and automated lifecycle management.

Features of Oracle Analytics Cloud

Built on a high-performance platform with flexible data storage, Oracle Analytics Cloud provides a complete set of tools for deriving and sharing data insights.

  • Data preparation: Analysts can ingest, profile, and cleanse data using a variety of algorithms.

  • Data flow: Analysts can prepare, transform and aggregate data, and then run machine-learning models at scale.

  • Data discovery: Subject matter experts can easily collaborate with other business users, blending intelligent analysis at scale, machine learning, and statistical modeling.

  • Data visualization: Analysts can visualize any data, on any device, on premises and in the cloud.

  • Data collaboration: Large organizations and small teams can share data more simply, without the need to manage or consolidate multiple versions of spreadsheets, and quickly perform ad hoc analysis of the spreadsheet data..

  • Data-driven: Application developers can utilize interfaces that enable them to extend, customize, and embed rich analytic experiences in the application flow.

With Oracle Analytics Cloud, you can take data from any source, and explore and collaborate with real-time data.

You can interact with your personal data, ingest and harmonize data sources, collate and manage disparate inputs, and handle data with coherence and consistency during organizational sharing.

As you visually research and discover, you can review and visualize both personal and corporate data, and gain insights at key stages of the iterative information cycle.

You can also perform role-based visualization, for example, as a Sales VP, Sales Manager, Marketing Analyst, or Services Manager.

You can initiate collaboration based on any data, and access real-time data with a variety of interface options, using a multidimensional engine.

You can display data in a choice of Oracle reports and dashboards.

About Oracle Analytics Cloud Products

Oracle Analytics Cloud offers you three product options.

Product Options

Product Options Oracle Cloud Infrastructure Managed By...
Oracle Analytics Cloud Oracle Cloud Infrastructure Oracle
Oracle Analytics Cloud Subscription Oracle Cloud Infrastructure Oracle
Oracle Analytics Cloud - Classic Oracle Cloud Infrastructure Classic You (Oracle User)

Differences Between Products

The main difference between Oracle Analytics Cloud, Oracle Analytics Cloud Subscription, and Oracle Analytics Cloud - Classic is the way you deploy and manage your services on Oracle Cloud.

Editions

All three editions (Standard, Enterprise, and Essbase) are available on Oracle Analytics Cloud, Oracle Analytics Cloud Subscription, and Oracle Analytics Cloud - Classic.

Edition Oracle Analytics Cloud Oracle Analytics Cloud Subscription Oracle Analytics Cloud - Classic
Standard

Data Visualization

Data Visualization

Data Visualization

Essbase

Essbase

Data Visualization

Essbase

Essbase

Data Visualization

Essbase

Enterprise

Data Visualization

Essbase

Business Intelligence

Business Intelligence (with Data Visualization)

Data Visualization

Essbase

Business Intelligence

Service Management

Service Management Oracle Analytics Cloud Oracle Analytics Cloud Subscription Oracle Analytics Cloud - Classic
Managed by You (Oracle User)

space

space

Check mark

You manage the service lifecycle and configuration, and have SSH access to the compute node VM.

Oracle–Managed
Check mark

Oracle provides you with lifecycle management and configuration. You can log service requests to Oracle Cloud support to request service updates.

Check mark

space

Customer Responsibility

space

space

space

Manage users and roles
Check mark
Check mark
Check mark
Create and size service
Check mark
Check mark
Check mark
Create database cloud service

space

space

Check mark
Administer database cloud service

space

space

Check mark
Back up and restore services Oracle schedules and manages backups Oracle schedules and manages backups
Check mark
Patch services Oracle schedules and applies patches Oracle schedules and applies patches
Check mark
Patch operating system Oracle schedules and applies patches Oracle schedules and applies patches
Check mark
Start and stop services

space

space

Check mark
Pause and resume services
Check mark

space

space

Monitor services Oracle has direct access to diagnostic logs for troubleshooting issues Oracle has direct access to diagnostic logs for troubleshooting issues
Check mark

Infrastructure

Infrastructure Oracle Analytics Cloud Oracle Analytics Cloud Subscription Oracle Analytics Cloud - Classic
Oracle Cloud Infrastructure
Check mark
Check mark

space

Oracle Cloud Infrastructure Classic

space

space

Check mark

Oracle Identity Cloud Service

Check mark
Check mark
Check mark

Load Balancer

Check mark

An Oracle-managed load balancer is automatically created and configured for your service.

Check mark

An Oracle-managed load balancer is automatically created and configured for your service.

Check mark

When you enable Oracle Identity Cloud Service as the identity provider, an Oracle-managed load balancer is created and configured automatically for your service.

Cloud Storage Required

Check mark

Uses Oracle Cloud Infrastructure Object Storage — A storage bucket is automatically created for your service.

Check mark

Uses Oracle Cloud Infrastructure Object Storage — A storage bucket is automatically created for your service.

Check mark

Uses Oracle Cloud Infrastructure Object Storage Classic — You can create the object storage container either before or while you set up your service.

Oracle Database Cloud Service Required

space

space

Check mark

You must set up a database service for Oracle Analytics Cloud - Classic schemas and organize a back up schedule.

Size Deployment by Shape

Check mark

Various Oracle Compute Unit (OCPU) sizing options.

Check mark

Various Oracle Compute Unit (OCPU) sizing options.

Check mark

Standard and high memory shapes.

The list of available shapes may vary by region.

Size Deployment by Number of Users

space

Check mark

space

Scale Up and Scale Down

Check mark

Only services you created with Business Intelligence or Data Visualization features. You can't scale services created with the Essbase option.

Check mark

Availability Domains

Check mark

Each region has multiple isolated availability domains, with separate power and cooling. The availability domains within a region are interconnected using a low-latency network. When you create a service, you can select the region where you want to deploy the service and Oracle automatically selects an availability domain.

Check mark

Each region has multiple isolated availability domains, with separate power and cooling. The availability domains within a region are interconnected using a low-latency network. When you create a service, you can select the region where you want to deploy the service and Oracle automatically selects an availability domain.

space

Standard, Essbase, and Enterprise Editions

Oracle Analytics Cloud is available in the Standard, Essbase, and Enterprise Editions.

Oracle Analytics Cloud - Standard Edition

With Standard Edition, you can:

  • Take control of your data

  • Create processes for business analytics application and data collection

  • Discover insights on the data that you provide

  • Prepare data through interactive data flows

  • Explore data through grammar-based visualization

  • Coordinate business analytics within your department or organization

Oracle Analytics Cloud - Essbase Edition

Essbase Edition offers all the features in the Standard Edition, and in addition, you can:

  • Explore and replicate data

  • Create scalable data flows including ingestion, transformation, and persistence

  • Execute data flows by using Apache Spark or Oracle Database Cloud

  • Create and manage Essbase applications from Microsoft Excel by using Cube Designer

  • Create connections and data sources for drill-through, data loads and dimension builds

  • Collect collaborative data, create scenarios, and perform what-if analysis using Smart View

  • Create transparent and replicated partitions

Oracle Analytics Cloud - Enterprise Edition

Enterprise Edition offers all the features in the Standard Edition and the Essbase Edition. In addition, you can:

  • Build data models, reports, and analytic dashboards in an enterprise business intelligence environment

  • Design and publish pixel-perfect reports from your enterprise data

  • Migrate content from your existing on-premises environment

  • Perform a sensitivity analysis to test various data scenarios

  • Use the Oracle Analytics Cloud Day by Day mobile application

  • Maintain live and optimized connectivity to on-premises data warehouses

Sample Scenarios

Here are some sample scenarios of your deployment of Standard, Essbase, and Enterprise Editions of Oracle Analytics Cloud.

Standard Edition

Sample Scenario Description

Self-Service Data Analysis

You can connect to specific data sources, perform data preparation activities, analyze data, discover insights, and tell data stories.

For example, you might create rough models and content, or projects to return to for monitoring and further analysis. Your primary focus here is on data preparation and interactive analytics of information.

Distribute and Share Analytic Content

You can collaborate and share content. This can be static content, such as PDFs and images that are shared with passive users, or interactive content shared with other analysts.

Interactive content can vary based on the specific business scenario, such as sharing an interactive story, collaborating in the creation of a story or a scenario for analysis, or sharing an application.

Perform Data Collection and Consolidation

You can collect data, adjust the data as necessary, collaborate with other analysts, and submit the results for approval.

Access Data from a Mobile Device

You can access, analyze, and share analytic content from mobile devices.

Essbase Edition

Sample Scenario Description

Explore Data Lakes

You can create data flows to visualize data in your data lakes.

Replicate Data in Data Lakes

You can replicate data from Oracle Service Cloud (RightNow) into Oracle Big Data Cloud Service, Oracle Database Cloud Service, and Oracle Database.

For example, you can replicate data from customer service records in Oracle Service Cloud into your data lake on Oracle Big Data Cloud Service and then perform further data preparation and analysis with data flows and data visualization projects.

Create and Manage Cubes from Excel

You can design, create, and modify fully functional cubes from Excel-based application workbooks.

You can design the cube within the application workbook, import the workbook to the cloud service to create a cube, load data, and calculate the cube.

You can also create cubes from tabular data, from any source system.

Drill Through to Source

You can define and execute drill through reports so that you can analyze additional detailed data retrieved from external data sources.

Perform What-if Analysis

You can create, manage, and analyze scenarios.

Forecast You can do top-down and bottom-up forecasting and allocations.
Integrate with Data Visualization You can build a cube from Data Visualization using data flows, and analyze the data in Data Visualization.

Enterprise Edition

Sample Scenario Description

Build Business Intelligence Data Models

You can create data models at the enterprise level, as a single, consistent source of data.

Build Enterprise Business Intelligence Reports and Dashboards

You can build and employ highly-formatted reporting content and comprehensive interactions for analytical dashboards at the enterprise level.

Publish Pixel-Perfect Reports

You can design pixel-perfect reports to publish analytical content at the enterprise level.

Migrate On-premises Business Intelligence

You can move your existing on-premises Oracle business intelligence applications and content directly to the cloud.

Model Data and Scenario-Based Analysis

You can explore data while looking for insights and perform sensitivity analysis to test various data scenarios.

Analyze Business Analytics Anywhere

You can use the Day by Day mobile application. An innovative app that infuses personalized analytics on the go, at the right time, and place. Day by Day learns what users are interested in, when and where they are interested in it and who they collaborate with.