Business Intelligence on Oracle Cloud

Duration: 3 Days

What you will learn

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.

Audience

Business Analysts
Business Intelligence Developer

Course Objectives

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

Course Topics

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