Business Intelligence on Oracle Analytics Cloud 2024

Introduction to Oracle Analytics Cloud

• Objectives
• What Does It Take to Unlock Business Agility?
• Introducing Oracle Analytics Cloud
• Deep Discovery Through Rich Feature Set
• OAC Can Integrate Any Data Source Quickly
• Managed Data
• User Data
• Oracle Analytics Cloud Makes Any Time The Right Time For New Insights
• Features of Oracle Analytics Cloud
• Oracle Analytics Cloud Components
• Oracle Analytics Cloud Editions
• Provision an Instance
• Summary

Accessing and Organizing Content

• Objectives
• Finding and Exploring Your Content
• Renaming Items
• Adding Favorites
• Accessing Properties
• Sharing Items
• Assigning Ownership of Items
• Summary

Create Analyses and Apply Sorts

• Objectives
• Oracle Analytics Cloud Service
• Subject Areas
• Columns
• Hierarchies
• Oracle Analytics Cloud Service
• Creating Analyses
• Sorting Values in Views
• Access and Apply Multiple Sorts
• Summary

Views in Analyses

• Objectives
• Displaying Data in a Table
• Edit Analysis Properties
• Edit the Table
• Turn on Totals and Subtotals
• Access Table Properties
• Close the View Editor
• Add a Graph
• Displaying Data on a Graph
• Remove Views
• Edit the Graph
• Work with Pivot Tables
• Edit the Pivot Table
• Pivot Table Editor
• Expand Hierarchies in a Pivot Table
• Enable Grand Totals
• View Totals
• Sorting Controls
• Sorting Controls Right-Click Options
• Duplicate a Measure and Show Running Sums
• View Running Sums
• Duplicate a Measure and Show Relative Values
• View Relative Values
• Create Calculated Items
• Build the Calculated Item
• View the Calculated Item
• Calculated Item Versus Calculated Group
• Trellis View
• Create a Simple Trellis View
• Select Columns on the Criteria Tab
• Add a Simple Trellis
• Edit the Trellis
• Rearrange the Columns
• Create a Performance Tile
• Select the Measure Columns
• Add a Performance Tile
• Edit the Performance Tile
• Format the Performance Tile
• View Selector View
• Column Selector View
• Add Columns to the Column Selector View
• Selection Steps View
• Tree Map
• Tree Map Results
• Legend
• Ticker
• Advanced Ticker Options
• Summary

Formatting

• Objectives
• Column Styles
• Column Format
• Data Format
• Conditional Format
• Save as Default
• Format Containers
• Additional Format Options for Views
• Fixed Headers – Default
• Content Paging
• Advanced Data Formats – Numbers
• Advanced Data Formats – Dates
• Advanced Data Formats – Date Results
• Summary

Filters and Selection Steps

• Objectives
• Drill in Results
• Drill on Attribute Columns
• More Details Added
• View the Criteria Tab After Drilling
• Test Drill Behavior Without Editing the Query
• Drill on Hierarchal Columns
• Filters to Limit Data in Analyses
• Create a Filter
• Operators and Values
• Filter Menu
• Save as a Named Filter for Reusability
• The Results
• Use a Saved Filter in a New Analysis
• Group Filters to Limit Data in Analyses
• Selection Steps to Limit Displayed Members
• View Selection Steps
• Default Selection Steps
• Add a New Step – Select Members
• Keep Only
• Apply a Condition
• Condition Options
• Additional Options Available for Hierarchies
• Summary

Prompts and Variables

• Objectives
• Repository Variables
• Presentation Variables
• Create a Prompt Filter and Store the Selection in a Variable
• Select Columns on Criteria Tab
• Create a Filter Using a Presentation Variable
• Create a Column Prompt
• Specify Properties for the Column Prompt
• Verify the Column Prompt
• Reference the Variable in the Title View
• Test the Prompt
• Use a Presentation Variable to Edit a Formula
• Edit the Formula
• Create a Presentation Variable Prompt
• Test the Variable Prompt
• Summary

Use Master-Detail Views, Map Views, and Action Links

• Objectives
• Linking Views in Master-Detail Relationships
• Background Maps
• Map Layers
• Configure Maps
• Import and Configure Layers
• Import and Configure a Background Map
• Configure Zoom Levels
• Add a Map View
• Drill on a State to Add City Details to Map
• Edit Map Properties
• Bar Graph on Map Displayed
• Zoom to City Details
• Final Map View
• Interactive Analyses
• Create Inline Actions
• Add Actions to Analyses
• Add the Action by Editing Column Properties
• Add a Value Action
• Build the Action
• Multiple Actions
• Run the Analysis and Test the Action
• Summary

Expressions

• Objectives
• Aggregate Functions
• Apply an Aggregate Function – Avg
• Aggregate Function Results
• Running Aggregate Functions
• Apply a Running Aggregate – MSUM
• Running Aggregate Function Results
• Time Series Functions
• Use a Time Series Function – Periodrolling
• Time Function Results
• Use the Bin Function
• Bin Results
• Summary

Unions and Direct Data Warehouse Access

• Objectives
• Set Operators
• Create an Analysis and Add a Second Subject Area for a Union
• Build the Second Query
• Choose the Set Operator and View Results
• Direct Database Analysis Privileges
• Assign Privileges
• Create a Direct Database Query
• Write the Query
• View the Results
• Summary

Create Dashboards

• Objectives
• Introduction to Dashboards
• Overview of Dashboards
• Dashboard Pages and Page Options
• Personal and Shared Dashboards
• Create a Dashboard
• Personal Dashboard
• Shared Dashboard
• Dashboard Menu
• Summary

Add Content to Dashboards

• Objectives
• Access Dashboard Builder
• Dashboard Builder UI
• Using the Dashboard Builder Toolbar
• What Can You Add to a Dashboard Page?
• Add a Dashboard Page
• Rename and Edit Order of Pages
• Add a Subpage
• Additional Dashboard Properties
• Dashboard Properties
• Dashboard Properties: Dashboard Report Links
• Dashboard Properties: Dashboard Page Controls
• Tools Toolbar: Print Option
• Tools Toolbar: Page Report Links
• Tools Toolbar: Publish Page to Dashboard
• Adding Columns to a Dashboard Page
• Column Properties
• Adding Sections to a Dashboard Page
• Arranging Section Content Vertically
• Arranging Section Content Horizontally
• Section Properties
• Section Permissions
• Formatting the Section
• Conditionally Show a Section and Rename a Section
• Default Drill Behavior in a Section
• Drill in Place
• Analyses Properties
• Analyses Properties: Display Results
• Analyses Properties: Report Links
• Analyses Properties: Show View
• Adding Additional Content
• Text Object
• Folder Object
• Deleting Content from the Dashboard
• Deleting a Page from a Dashboard
• Summary

Add Actions to Dashboards

• Objectives
• Action Link
• Create an Inline Action Link
• Add a New Action
• Create an Inline Action Link – BI Content
• Creating an Inline Action Link – Results
• Create an Inline Action Link – Web Page
• Creating an Inline Action Link – Web Page Results
• Edit and Remove an Inline Action Link
• Save an Inline Action Link as a Named Action Link
• Action Link Menu
• Summary

Create Dashboard Prompts

• Objectives
• Dashboard Prompts
• Dashboard Prompts: Column Prompt
• Add a Column Prompt to a Dashboard
• Create the Column Prompt
• Select the Prompt Type
• Select the Prompt Column
• Configure the Prompt
• Save the Prompt
• Add the Prompt to the Dashboard
• Add Analyses to the Dashboard Page
• Test the Results
• Will a Prompt Affect an Analysis?
• Results of Prompts on Analyses
• Adding a Second Prompt
• Add a Second Prompt to an Existing Prompt Page
• Select the New Column and Configure Prompt
• Row Based Versus Column Based Layout
• Optionally include a Page Break
• Test the Edited Dashboard Prompt
• Scope of a Dashboard Prompt
• Prompt Buttons
• Summary

Customizations and Briefing Books

• Objectives
• Personal Saved Customizations
• Allow Customizations
• Access Customizations
• Save Customizations
• Apply Customizations
• Applied Customizations
• Edit Saved Customizations
• Clear Customizations
• Oracle BI Briefing Books
• Add Content to a New or Existing Oracle BI Briefing Book
• Add a Dashboard Page to a Briefing Book
• Add an Analysis to a Briefing Book
• Adding Content to a Briefing Book
• Edit a Briefing Book
• Download a Briefing Book in PDF
• Download a Briefing Book in Mime HTML
• Add a List of Briefing Books to a Dashboard Page
• Add a Folder Object to the Dashboard Page
• Edit Folder Properties
• Summary

Use a Wallet to Connect to an Autonomous Data Warehouse with SQL Developer

• Objectives
• Overview
• Retrieve the Wallet
• Navigate to the Data Warehouse
• Select the Autonomous Data Warehouse
• DB Connection
• Open SQL Developer
• Adding a Connection to the Source Database
• Summary

Migrating the On-Premises RPD to the Oracle Analytics Cloud Service

• Objectives
• Introduction
• Lift and Shift the RPD to the OAC instance
• Point the RPD to the ADW
• Saving the RPD and Consistency Check
• Upload the RPD to OAC
• Replace the Data Model
• Continue Using the Client Tool
• Creating New Analyses and Visualizations
• Summary

OAC Delivers

• Objectives
• OAC Delivers
• Prerequisites for Email and SMS Delivery
• Delivery Devices
• Delivery Profiles
• Alerts
• Agents
• Configure an Agent
• General Tab
• Schedule Tab
• Condition Tab
• Delivery Content Tab
• Recipients Tab
• Destinations Tab
• Actions Tab
• Summary

Administration

• Objectives
• Predefined Application Roles
• Application Roles Visualized
• Add Members to Application Roles
• Set System Privileges
• Select Users and Roles
• Monitor Sessions
• Monitor Users
• Analyze SQL Queries and Logs
• SQL Log
• Summary

Cache Management

• Objectives
• OAC Query Cache
• Advantages of Caching
• Cache Setting
• Clear the Cache Manually
• Set Caching Options for Your Analysis
• Cache Hit Conditions
• Identify Cache Hits
• Analyze the Log
• Build a Second Analysis to Hit the Cache
• Analyze the Log for Cache Hit
• Summary