Oracle Analytics
Darshika Srivastava
Associate Project Manager @ HuQuo | MBA,Amity Business School
About?Oracle Analytics Clou
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.
Description of the illustration acs_getstarted1-gif.gif
You can interact with your own data, ingest and harmonize data sources, collate and manage disparate inputs, and handle data with coherence and consistency during organizational sharing.
As you research and discover information, you can review and visualize your own data with 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.
Description of the illustration acs_getstarted2-gif.gif
You can initiate collaboration based on any data, and access real-time data with a variety of interface options, using a multidimensional engine.
Description of the illustration acs_getstarted3-gif.jpg
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?(Gen 1 and Gen 2)Foot?1 Oracle
Oracle Analytics Cloud?Subscription Oracle Cloud Infrastructure?(Gen 1) Oracle
Oracle Analytics Cloud - Classic Oracle Cloud Infrastructure Classic You (Oracle User)
Footnote?1?The way you deploy and manage?Oracle Analytics Cloud?on?Oracle Cloud Infrastructure?(Gen 1 or Gen 2) depends on the region and start date of your subscription. See?How Do I Set Up a Cloud Service?
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
Service Management
Infrastructure
Editions
Several editions are currently available: Professional and Enterprise. The features available with each edition depend on the product option and regions accessible to you.
Edition Oracle Analytics Cloud Oracle Analytics Cloud?Subscription Oracle Analytics Cloud - Classic
Professional
Data Visualization
Data Visualization
Data Visualization
Essbase?Foot?2
Enterprise
Business Intelligence (includes Data Visualization)
Essbase?Foot?3
Data Visualization?Foot?4
Business Intelligence (includes Data Visualization)
Business Intelligence (includes Data Visualization)
Essbase
Data Visualization
Footnote?2?Essbase isn't available with Oracle Cloud accounts created after 12th December 2019.
Footnote?3?Essbase isn't available with Oracle Cloud accounts created after 12th December 2019.
Footnote?4?Data Visualization-only deployments aren't available with Enterprise Edition in Oracle Cloud accounts created after 2nd March 2020. Subscribe to Professional Edition if you want only Data Visualization.
Note:
Oracle Analytics Cloud – Essbase?Edition isn't available in Oracle Cloud accounts created after 12th December 2019. Instead,?Oracle Essbase?is available on?Oracle Cloud Marketplace. See:?https://docs.oracle.com/en/database/other-databases/essbase/index.html
Any Oracle Cloud account created before 12th December 2019 that includes?Oracle Analytics Cloud – Essbase?Edition, remains unchanged.
Service Management
Service Management Oracle Analytics Cloud Oracle Analytics Cloud?Subscription Oracle Analytics Cloud - Classic
Managed by You (Oracle User)
You manage the service lifecycle and configuration, and have SSH access to the compute node VM.
Oracle–Managed
Oracle provides you with lifecycle management and configuration. You can log service requests to Oracle Cloud support to request service updates.
Customer Responsibility
Manage users and roles
Create and size service
Create database cloud service
Administer database cloud service
Back up and restore services Oracle schedules and manages backups Oracle schedules and manages backups
Patch services Oracle schedules and applies patches Oracle schedules and applies patches
Patch operating system Oracle schedules and applies patches Oracle schedules and applies patches
Start and stop services
Pause and resume services
Monitor services Oracle has direct access to diagnostic logs for troubleshooting issues Oracle has direct access to diagnostic logs for troubleshooting issues
Infrastructure
Infrastructure Oracle Analytics Cloud Oracle Analytics Cloud?Subscription Oracle Analytics Cloud - Classic
Oracle Cloud Infrastructure?(Gen 2)
Oracle Cloud Infrastructure?(Gen 1)
Oracle Cloud Infrastructure Classic
Oracle Identity Cloud Service
Load Balancer
An Oracle-managed load balancer is automatically created and configured for your service.
An Oracle-managed load balancer is automatically created and configured for your service.
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
Uses?Oracle Cloud Infrastructure Object Storage?— A storage bucket is automatically created for your service.
Uses?Oracle Cloud Infrastructure Object Storage?— A storage bucket is automatically created for your service.
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 Classic Cloud Service?Required
You must set up a database service for?Oracle Analytics Cloud - Classic?schemas and organize a back up schedule.
Size Deployment by Shape
Various Oracle Compute Unit (OCPU) sizing options.
Various Oracle Compute Unit (OCPU) sizing options.
Standard and high memory shapes.
The list of available shapes may vary by region.
Size Deployment by Number of Users
Only on Oracle Cloud Infrastructure (Gen 2).
Scale Up and Scale Down
Availability Domains
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.
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.
Professional and Enterprise Editions
Oracle Analytics Cloud?is currently available in Professional and Enterprise Edition.
Oracle Analytics Cloud - Professional Edition
Oracle Analytics Cloud - Enterprise Edition
Oracle Analytics Cloud?- Professional Edition
With Professional 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
Use the?Oracle Analytics Day by Day?mobile application
Oracle Analytics Cloud?- Enterprise Edition
Enterprise Edition offers all the features in Professional Edition and 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 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 Professional and Enterprise Editions of?Oracle Analytics Cloud.
Professional 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 workbooks to return to for monitoring and further analysis. Your primary focus here is on data preparation and interactive analytics of information.
Distribute and share analytics 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.
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.
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 business intelligence applications and content directly to the cloud.
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.Ord