Business Intelligence on Oracle Analytics Cloud Ed 1

Topics

• Introduction to Cloud Computing and Oracle Analytics Cloud Services
  • Cloud Computing Overview
  • Introduction to Oracle Analytics Cloud
• Accessing and Organizing Content
  • Finding and Explorin Your Content
  • Renaming Items
  • Sharing Items
• Create Analyses and Apply Sorts
  • Managing Columns and Hierarchies
  • Create Analyses
  • Sorting Values in Views
  • Access and Apply Multiple Sorts
• Views in Analyses
  • Displaying Data in a Table
  • Edit Analysis Properties
  • Work with Totals and Subtotals
  • Working with Pivot Tables
  • Calculated Item Versus Calculated Group
  • Trellis View, Tree Map, Ticker
• Formatting
  • Column Styles
  • Column Format
  • Conditional Format
  • Advanced Data Formats
• Filters and Selection Steps
  • Drill In Results
  • Create a Filter
  • Group Filters to Limit Data in Analyses
  • Apply a Condition
• Prompts and Variables
  • Repository Variables
  • Presentation Variables
  • Create a Prompt Filter
  • Create a Column Prompt
  • Create a Presentation Variable Prompt
• Use Master Detail Views, Map Views and Action Links
  • Linking Views in Master Details Relationships
  • Background Maps
  • Add a Map View
  • Interactive Analyses
  • Create Inline Actions
• Working with Expressions
  • Aggregate Functions
  • Time Series Functions
  • Use the Bin Function
• Unions and Direct Data Warehouse Access
  • Set Operators
  • Create Additional Subject Area and Queries for a Union 
• Create Dashboards and Add Content to Dashboard
  • Introduction to Dashboards
  • Dashboard Pages and Page Options
  • Personal and Shared Dashboards 
  • Using Dashboard Builder
  • Drill In Place
• Using Filters to Limit Data in Analyses
  • Using Filters to Limit Data in Analyses 
  • Grouping Filters to Limit Data in Analyses 
  • Deleting Dashboard Pages
• Using Master-Detail Views, Map Views, and Action Links
  • Linking Views in Master-Detail Relationships
  • Map Views 
• Creating Dashboards
  • Introduction to Dashboards
  • Creating Personal Dashboard 
  • Creating Shared Dashboard 
• Adding Content to Dashboards
  • Using Dashboard Builder
  • Dashboard Builder Tools 
  • Dashboard Properties 
• Adding Actions to Dashboards
  • Create inline Action Link
  • Edit and Remove Action Link
  • Action Link Menu
    
• Create Dashboard Prompt
  • Create Column Prompt
  • Managing Multiple prompts
  • Prompt Buttons
    
• Create and Publish Model
  • Overview of Data Modeler
  • Create Fact and Dimensional Tables
  • Create a Time Dimension
  • Create Hierarchies and Calculated Measures
  • Synchronize Model with Database
    
• OAC Developer Client Tool
  • Install and Configure
  • Create a Data Model
  • Create a Business Model
  • Create Joins and Hierarchies
  • Differences Between Data Modeler & Developer Client

• Business Intelligence Cloud Service Overview
• Introduction to BI Cloud Service

Data Visualization on OAC Overview

• Accessing Visual Analyzer
• Adding Data Source
• Different Objects Within Visual Analyzer
• Adding Data Elements to Visualizations
• Creating Visualization
• Modifying the Visualization

Uploading and Blending Data

• Characteristics of External Sources
• Uploading Data from External Sources
• Adding File-Based Data
• Blending Data
• Refreshing Data
• Updating Details of Data

Managing Data Sources, Controlling Sharing of Data

• Controlling Sharing of Data
• Removing Data
• Deleting Data
• Managing Data Sources

Data Wrangling

• Data wrangling functions
• Applying Data Wrangling Functions for Date Column
• Applying Data Wrangling Functions for Measures
• Applying Data Wrangling Functions for Attributes

Data Visualizing Content and Adding Data Elements to Visualizations

• Adding Data Elements to Visualizations
• Adjusting the Canvas Layout
• Changing Visualization Types and Properties
• Reverse Visualization Edits
• Refresh Visualization Content

Exploring Data Using Filters, Sorting, Drilling, and Selecting

• Creating Filters
• Applying Range Filters
• Applying List Filters
• Applying Date Filters
• Building Expression Filters
• Exploring Data Using Drilling, Sorting, and Selecting

Creating Calculated Data Elements and Building Expressions

• Creating Calculated Data Elements
• Composing Expressions
• Expression Editor Reference
• SQL Operators
• Conditional Expressions

Linking Visualizations and Building Stories

• Synchronizing Visualizations
• Capturing Insights
• Shaping Stories
• Edit Insights
• Include and Exclude Insights
• Rearranging Insights
• Sharing Stories

Using Visualization Types

• Creating a Line Chart
• Creating a Performance Tile

Creating Analyses and Sorts

• Creating and Editing Analyses
• Formatting Columns
• Sorting Values in Views

Views in Analyses

• Displaying Data on a Graph
• Working with Pivot Tables
• Creating Calculated Items

Using Filters to Limit Data in Analyses

• Using Filters to Limit Data in Analyses
• Grouping Filters to Limit Data in Analyses
• Deleting Dashboard Pages

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

• Linking Views in Master-Detail Relationships
• Map Views

Creating Dashboards

• Introduction to Dashboards
• Creating Personal Dashboard
• Creating Shared Dashboard

Adding Content to Dashboards

• Using Dashboard Builder
• Dashboard Builder Tools
• Dashboard Properties

OAC Cloud Web Services and Configuring Analytics on Mobile

• Introduction to RESTful Web Services
• Architecture of Oracle Database Cloud RESTful Web Services
• Creating a RESTful Service