Business Intelligence on Oracle Cloud

Course Details
Code D96909GC10
Tuition (USD): $2,325.00 • Virtual (3 days)

No hands on lab environment for the TOD course format

The Business Intelligence on Oracle Cloud training provides step-by-step instructions for creating analyses and dashboards using Oracle Business Intelligence Cloud Service. You’ll learn how to load data, model data, build and modify analyses and dashboards, while configuring Business Intelligence Cloud Service 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 Business Intelligence Cloud Service 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. This course supports Oracle Business Intelligence Cloud Service.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Skills Gained

  • Explore data using Visual Analyzer using Business Intelligence Cloud Service
  • 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

Who Can Benefit

  • Business Analysts
  • Business Intelligence Developer

Course Details

Introduction to Business Intelligence Cloud Service

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

Visual Analyzer 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, Removing and Deleting 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

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

Building Analyses by Using Business Intelligence Cloud Service

  • Creating and Formatting Analyses
  • Filtering Analyses
  • Adding Graphs and Working with Pivot Tables
  • Views in Analyses and Sorting Values in Views
  • Drilling in Results
  • Linking Views in Master-Detail Relationships
  • Visualizing Data by Using Map Views
  • Interactive Analyses

Building Dashboards by Using Business Intelligence Cloud Service

  • Creating Dashboards and Dashboard Prompts
  • Adding Content to Dashboard
  • Adding Actions to Dashboard

Creating Dashboard Prompts

  • Adding a Column Prompt to a Dashboard
  • Adding a Second Prompt
  • Adding a Hidden Prompt to a Dashboard

Organizing and Managing Dashboard Content, Saving Personal Customizations

  • Personal Saved Customizations
  • Organizing Content Using Briefing Books
  • Deleting Dashboard Pages

Configuring Web Services Mobile

  • Oracle BI Cloud Service Web Services
  • Configuring Oracle BI Cloud Service on Mobile

Loading Data to Business Intelligence Cloud Service

  • Loading Data from Files with Data Loader
  • Loading Data with Oracle BI Cloud Service Data Sync
  • Loading Data into BI Cloud Service using SQL Developer
  • Migrating On-Premises RPD to Oracle BI Cloud Service

Modeling Data by Using Business Intelligence Cloud Service

  • Introduction to Data Modeler
  • Creating Variables and Derived Attributes
  • Building and Publishing a Model

Troubleshooting

  • Troubleshooting Data Loading Issues
  • Troubleshooting Data Modeling Issues
  • Troubleshooting Issues with Analyses and Dashboards
  • Troubleshooting Issues with Projects
Course Details
Code D96909GC10
Tuition (USD): $2,325.00 • Virtual (3 days)