oracle 200x118 wht
7829  Reviews star_rate star_rate star_rate star_rate star_half

Business Intelligence on Oracle Analytics Cloud Ed 1

The Business Intelligence on Oracle Analytics Cloud training provides step-by-step instructions for creating analyses and dashboards using Oracle Analytics Cloud. You’ll learn how to load data,...

Read More
$3,600 USD
Course Code BUS-INTEL-ANA-CLD
Duration 3 days
Available Formats Classroom

The Business Intelligence on Oracle Analytics Cloud training provides step-by-step instructions for creating analyses and dashboards using Oracle Analytics Cloud. You’ll learn how to load data, model data, build and modify analyses and dashboards, while configuring Oracle Analytics Cloud on mobile.

Learn How To:

  • Upload data from external sources
  • Explore data through data wrangling and visualizations
  • Load data using Data Loader and SQL Developer
  • Create and publish data models using Data Modeler
  • Explore data using Visual Analyzer
  • Build analyses and use views and graphs in analyses
  • Administer objects in the catalog
  • Troubleshoot issues with data loading, data modeling, analyses and dashboards
  • Configure Oracle Analytics Cloud on Mobile

Benefits to You

Taking this training will empower you with the knowledge and skills to transform your organization’s data into intelligence. With this intelligence, you'll be able to make better business decisions. You'll also be able to provide time-critical, relevant, and accurate insights.

Skills Gained

  • Build analyses and use views and graphs in analyses
  • Administer Business Intelligence Cloud Service objects in the catalog
  • Troubleshoot issues with data loading, data modeling, analyses, and dashboards
  • Configure Business Intelligence Cloud Service on Mobile
  • Load data using Data Loader and SQL Developer to Business Intelligence Cloud Service
  • Create and publish data models using Data Modeler in Business Intelligence Cloud Service
  • Explore data using Visual Analyzer using Business Intelligence Cloud Service

Who Can Benefit

  • Business Analysts
  • Business Intelligence Developer

Course Details

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