Oracle Analytics Cloud (OAC) Cheat Sheet

Back to Business IntelligenceUpdated 2026-05-15

Oracle Analytics Cloud is Oracle's cloud-based analytics and business intelligence platform delivering self-service data visualization, augmented analytics with AI/ML, semantic modeling, and enterprise reporting. It provides a drag-and-drop canvas for creating interactive visualizations, data flow-based ETL capabilities, Oracle Machine Learning model integration, augmented analytics through Explain and Smart Insights, and pixel-perfect reporting via Analytics Publisher. OAC connects to Oracle Cloud and on-premises data sources, supports real-time and batch analytics, and offers AI-powered automation including conversational AI Agents that understand business context. The platform centralizes governed data access through semantic models (RPD), enables embedding visualizations in applications via APIs and iFrames, and delivers comprehensive security with role-based access control—positioning it as Oracle's unified analytics solution for cloud-first enterprises.

What This Cheat Sheet Covers

This topic spans 15 focused tables and 163 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.

Table 1: Visualization Types and Chart PaletteTable 2: Data Visualization Canvas and DesignTable 3: Data Flow and ETL TransformationsTable 4: Machine Learning and AI IntegrationTable 5: AI Agents and Conversational AnalyticsTable 6: Semantic Modeling and RPDTable 7: Data Connections and SourcesTable 8: Analytics Publisher (Pixel-Perfect Reports)Table 9: Custom Calculations and AggregationsTable 10: Dashboard Interactivity and FiltersTable 11: Collaboration and SharingTable 12: Security and Access ControlTable 13: Performance and OptimizationTable 14: Embedding and IntegrationTable 15: Administration and Maintenance

Table 1: Visualization Types and Chart Palette

Visualization	Example	Description
Bar and Column Charts	`Revenue by Region → Bar` `Sales Trend → Column`	Display categorical comparisons using horizontal (bar) or vertical (column) rectangles; support stacked, 100% stacked, and grouped variations.
Line and Area Charts	`Revenue over Time → Line` `Cumulative Sales → Area`	Show trends and changes over continuous intervals; area charts add shading beneath lines to emphasize magnitude.
Scatter and Bubble	`Sales vs Profit (Size=Quantity)`	Display correlations between two or three numeric variables; bubble size represents third dimension.
Pivot Table	`Product ↓ × Region → Sales`	Summarize and aggregate data in rows and columns with subtotals; supports drill-down hierarchies and swappable dimensions.
Table	`Customer Name, Order Date, Amount`	Display detailed records in tabular format; consumers can add/remove columns dynamically; supports data bars for visual emphasis.
Heatmap	`Sales by Month × Product (intensity)`	Use color intensity to show measure magnitude across two categorical dimensions; quick pattern recognition.
Pie and Donut Charts	`Market Share by Segment`	Show part-to-whole relationships as slices of a circle; donut variant adds central space for annotations.
Funnel	`Lead → Prospect → Opportunity → Deal`	Visualize sequential stages in a process with decreasing values; identifies drop-off points.

Table 1: Visualization Types and Chart Palette

Visualization	Example	Description
Bar and Column Charts	`Revenue by Region → Bar` `Sales Trend → Column`	Display categorical comparisons using horizontal (bar) or vertical (column) rectangles; support stacked, 100% stacked, and grouped variations.
Line and Area Charts	`Revenue over Time → Line` `Cumulative Sales → Area`	Show trends and changes over continuous intervals; area charts add shading beneath lines to emphasize magnitude.
Scatter and Bubble	`Sales vs Profit (Size=Quantity)`	Display correlations between two or three numeric variables; bubble size represents third dimension.
Pivot Table	`Product ↓ × Region → Sales`	Summarize and aggregate data in rows and columns with subtotals; supports drill-down hierarchies and swappable dimensions.
Table	`Customer Name, Order Date, Amount`	Display detailed records in tabular format; consumers can add/remove columns dynamically; supports data bars for visual emphasis.
Heatmap	`Sales by Month × Product (intensity)`	Use color intensity to show measure magnitude across two categorical dimensions; quick pattern recognition.
Pie and Donut Charts	`Market Share by Segment`	Show part-to-whole relationships as slices of a circle; donut variant adds central space for annotations.
Funnel	`Lead → Prospect → Opportunity → Deal`	Visualize sequential stages in a process with decreasing values; identifies drop-off points.