Oracle BI 12c: Create Analyses and Dashboards

Course code

OBI12CAD

Duration

5 Days, 40 Acad. Hours

Download pdf

Course Overview

Objectives

Prerequisites

Course Outline

Course Overview

Course overview

This Oracle BI 12c: Create Analyses and Dashboards course for Release 12.2.1 provides step-by-step instructions for creating Oracle BI analyses and dashboards in business intelligence applications. You’ll begin by building basic analyses to include in dashboards, with more complexity as the course progresses.

Objectives

Course Objectives

Build and use views and charts in analyses
Perform pre- and post-aggregate filtering using filters, groups, and selections
Create mobile applications with Oracle Business Intelligence Mobile App Designer
Add geographical mapping to analyses
Use Key Performance Indicators and Scorecards to analyze trends and meet business objectives
Use BI Mobile to access BI Content
Create and modify Interactive Dashboards
Use hierarchical columns in analyses and views
Create guided navigation links within Interactive Dashboards
Use Delivers to configure Agents to get the results of analyses and deliver them to subscribers
Create and modify Oracle Business Intelligence analyses using Analysis Editor
Perform administration tasks related to the development and configuration of Interactive Dashboards
Administer analyses and other Oracle BI objects
Use Oracle Hyperion Smart View for Office to integrate Oracle BI analysis and Interactive Dashboard content into Office documents
Combine analysis criteria across multiple subject areas and execute direct database queries

Prerequisites

Basic knowledge of Microsoft Office Applications

Audience

End Users
Application Developers
Business Analysts
Developer
Technical Consultant
Functional Implementer
Business Intelligence Developer
Technical Administrator

Course Outline

Course Topics

1. Introduction to Oracle Business Intelligence Enterprise Edition

Introduction to Oracle BI EE
Oracle BI 12c Highlights
Oracle BI 12c Architecture

2. Working with Oracle Business Intelligence Analyses

Adding basic formatting
Working with analyses in Oracle BI
Introduction to Oracle BI Analysis Editor
Setting analysis properties
Oracle BI column types
Using advanced formatting

3. Filtering Data for Analyses

Adding prompts to analyses
Using saved analyses as filters
Dynamic filtering
Creating, editing, and grouping filters
Introduction to filters and selections

4. Selecting and Grouping Data for Analysis

Creating calculated items
Including advanced SQL clauses in your analysis
Creating selection steps
Creating direct database analysis requests
Creating groups

5. Advance Visualization in Analysis

Working with views in Compound Layouts
Performing common view tasks
Introduction to views, graphs, and editors
Creating and editing graphs

6. Showing Results with Pivot Tables

Using hierarchical columns
Building calculations and displaying running sums
Showing an item’s relative value
Creating, arranging, and formatting a pivot table
Setting aggregation and using totals
Sorting in pivot tables

7. Working with Additional Views in Analyses

Creating simple and advanced trellis views
Creating performance tile views
Linking master-detail views
Working other view types like Treemap and Heat Matrix

8. Visualizing Data on Maps

Oracle spatial components
Managing map data
Other applications and points of integration for map views
Interacting with map views
Creating and editing Map views

9. Creating Oracle Business Intelligence Dashboards

Publishing dashboard pages
Using the Dashboard Builder
Exploring dashboard object properties and options
Creating and editing dashboards
Creating personal customizations and using other page options

10. Configuring Oracle Business Intelligence Dashboards

Embedding content in dashboards
Exploring types of dashboard content

11. Creating Dashboard Prompts and Variables

Adding variable prompts to a dashboard
Creating additional prompt page and setting page preferences
Adding a named dashboard prompt to a dashboard
Understanding variables
Adding a hidden named dashboard prompt to a dashboard

12. Scorecards and Key Performance Indicators

Editing scorecards and KPIs
Objects and components of Oracle Scorecard and Strategy Management
Creating scorecard documents
Scorecard document types
Creating scorecards and KPIs
Key Performance Indicator (KPI) overview

13. Visual Analyzer, BI Ask, and Data Mashup

Creating Visual Analyzer Projects
Adding and rearranging the Visualizations
Data Mashups
BI Ask

14. Working with BI Content in Smart View

Creating and publishing views using the View Designer
Federating data from multiple data sources
Inserting BI views in to Smart View clients
Working with Views in Smart View Clients
Customizing BI data in MS Office
Copying and pasting views between Smart View clients

15. Oracle Business Intelligence Mobile

Navigating the Oracle BI mobile application
Oracle BI Mobile Security Toolkit
Downloading and using the Oracle BI mobile application
Working with BI content
Working with favorites and local content

16. Using Oracle Business Intelligence Delivers

Adding an Alert Section to a dashboard
Configuring an Agent
Subscribing to an Agent
Using Analysis and KPI conditions to deliver content with Agents
Configuring delivery devices and adding delivery profiles

17. Administering the Presentation Catalog

Working with Oracle BI Briefing Books
Setting object permissions
Setting system privileges
Managing security using roles
Oracle BI and catalog security overview
Understanding security inheritance
Archiving catalog items

18. Direct Database Analysis

Creating and Executing a Direct Database Analysis
Changing Direct Database Analysis Privileges
Direct Database Analysis Overview

19. Expressions

Advance Analytics Internal Logical SQL Functions
Running Aggregate Functions
Advance Analytics External Logical SQL Functions
SQL Syntax and Semantics

Back to trainings (Oracle)

Request the training

Oracle BI 12c: Create Analyses and Dashboards

Course code:

OBI12CAD

Duration:

5 Days, 40 Acad. Hours

Apply

Download pdf