Business Intelligence on Oracle Analytics Cloud

  • Tuition USD $2,316
  • Reviews star_rate star_rate star_rate star_rate star_half 839 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.

Does the course schedule include a Lunchbreak?

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.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

The course was very thorough and the instructor ensured that all the students were on the same page.

The training class was very well organized and the instructor, Joel, did an excellent job. He was very knowledgable and engaging and was very good at making things make sense.

Registration process was smooth. Follow-up reminders and content was timely. Great execution!

Good course that covers all aspects of DB2. Gives very good starting point to enable anyone to work efficiently within DB2 environment.

It would be nice if we could have got the slides/text with comments that were made in the class so it helps with relating to questions we had.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward