The future of IBM Maximo: Work Centers and Inspections Can Transform Your Business

closeClose

Business Intelligence on Oracle Analytics Cloud

  • Tuition USD $2,316
  • Reviews star_rate star_rate star_rate star_rate star_half 486 Ratings
  • Course Code D105181GC10
  • Duration 3 days
  • Available Formats Virtual

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

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

Instructions were clear, lab exercises were pertinent and self-explanatory, topic was thoroughly covered in the presented course material.

The lady at the front really nice. Everthing was always stocked up: Helpful

Everything went well. Enrollment process was easy and I always felt welcomed throughout the whole experience.

Lab infraestructure is very suitable and works pretty good help to understand better the concepts exposed during the training.

The course material was laid out logically. There are a lot of aws services and concepts to cover in the three days but overall was a good learning experience.

10 options available

undo
  • Aug 17, 2020 Aug 19, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM CEST
    Enroll
    Enroll
  • Aug 31, 2020 Sep 2, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM MDT
    Enroll
    Enroll
  • Sep 28, 2020 Sep 30, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM CEST
    Enroll
    Enroll
  • Oct 12, 2020 Oct 14, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM MDT
    Enroll
    Enroll
  • Nov 9, 2020 Nov 11, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM CEST
    Enroll
    Enroll
  • Nov 23, 2020 Nov 25, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM MDT
    Enroll
    Enroll
  • Dec 21, 2020 Dec 23, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM CEST
    Enroll
    Enroll
  • Jan 4, 2021 Jan 6, 2021 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM MDT
    Enroll
    Enroll
  • Feb 1, 2021 Feb 3, 2021 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM CEST
    Enroll
    Enroll
  • Feb 15, 2021 Feb 17, 2021 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM MDT
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward