What OAC is and isn’t
Oracle Analytics Cloud (OAC) is Oracle’s next-generation analytics platform that combines:
- Self-service data visualisation (similar to Tableau or Power BI)
- Enterprise-grade semantic layer for governed analytics
- Machine learning predictions
- Embedded analytics for third-party applications
OAC is separate from OTBI. OTBI is built into Fusion Cloud for transactional reporting. OAC is a standalone service for broader analytics, including data from multiple sources, not just Fusion.
OAC deployment options
Oracle Analytics Cloud - Enterprise: full-featured, runs on OCI Oracle Analytics Cloud - Professional: lighter version, no semantic modelling Oracle Analytics Server: on-premise version with equivalent capabilities
Data sources OAC supports
- Oracle Fusion Cloud (via OTBI connector or direct DB)
- Oracle Autonomous Database, Oracle DB
- Spreadsheets (Excel, CSV upload)
- REST APIs and JSON files
- Third-party: Salesforce, SAP, Google Analytics
- On-premise via Data Gateway
Creating your first project
- New → Project → Select a Subject Area or upload a file
- Data panel shows dimensions and measures from your source
- Drag measures to the canvas to auto-create a chart
- Change chart type using the chart type picker
- Add filters via the filter bar
- Add a second visualisation for comparison
Key OAC concepts
Subject Area: a governed semantic model defining business metrics (like OBIEE RPD layers) Dataset: ad-hoc data file or query result for exploration Workbook: collection of visualisations and dashboards Project: older term for what is now called Workbook
Machine Learning in OAC
OAC includes built-in ML algorithms:
- Predict: forecasting future values on time-series data
- Cluster: automatic grouping of customers/transactions by similarity
- Explain: automated insight discovery (“what factors most influence revenue?”)
No coding required — access via right-click on a measure column.
Licensing note
OAC is a separately licensed service from Fusion Cloud. Confirm your organisation has OAC licences before building solutions that depend on it.