Oracle BI 12c: Create Analyses and Dashboards

This lesson provides a course overview.

Lessons:

• Introductions

• Training Site Information

• Audience

• Course Goal

• Course Objectives

• Methodology

• Schedule

This lesson provides foundational information to set the context for the remainder of this course. An understanding of the architecture components and the role of Oracle Business Intelligence in the enterprise prepares you to work with the tools included.

Lessons:

• What Is Business Intelligence?

• Oracle BI Components

• Oracle Business Intelligence Enterprise Edition

• BI System Components

• Oracle BI 12c Highlights

• BI Presentation Services

• Prebuilt Functions

• Oracle BI Presentation Server and Catalog

• Oracle Mobile BI

• BI Server

• OBIEE 12c In-Memory Analytics

• Oracle BI Repository

• Visual Exploration for Everyone

• Data Sources

• Rich Data Mashup

• Oracle BI EE Terminology

• Oracle BI 12c Architecture

• Essbase: Overview

• Lab:

• Exploring Oracle BI Presentation Services

This lesson explores the use of Oracle BI Analysis Editor which enables you to create and edit analyses to explore and interact with information.

Lessons:

• Identify the important elements of analyses

• Apply advanced formatting to analyses

• Use Analysis Editor

• Lab:

• Construct, modify, and save analyses by using the three available types of columns

• Creating and Formatting an Analysis

• Controlling the Display of Columns Added to Analyses

This lesson describes the usage and features of filter within analyses.

Lessons:

• Describe the use of filters in limiting the results of analyses

• Lab:

• Design and build filters in Oracle Business Intelligence analyses

• Adding Filters to Analyses

• Add filter prompts to an analysis

• Adding an Inline Prompt to an Analysis

• Use a saved analysis as a filter

• Using a Saved Analysis as a Filter

• Edit the SQL for a column filter in an analysis

• Editing SQL for a Column Filter

This lesson describes how to implement selections and groupings to limit the data that is returned in the analyses.

Lessons:

• Create and save selections

• Lab:

• Create and save groups and calculated items

• Using Selections, Groups, and Calculated Items to Manage Analysis Results

• Including Selected Members Based on Family Relationships

• Adding Groups and Calculated Items to an Analysis

This lesson describes how to implement advanced views and compound layouts in analyses.

Lessons:

• Add additional views of the data that is returned by an analysis

• Perform common tasks in views

• Modify and format views

• Lab:

• Work with Compound Layouts

• Modifying and Formatting Views

• Using the Table View

This lesson describes how to create interactive pivot tables within analyses.

Lessons:

• Create and edit pivot tables

• Display running sums in pivot tables

• Override default aggregation rules in pivot tables

• Lab:

• Format pivot tables

• Working with Pivot Tables

• Show relative value of an item in a pivot table

• Displaying Running Sums in Pivot Tables

• Use calculations in pivot tables

This lesson describes how to use additional views in analyses.

Lessons:

• Build a Trellis view

• Lab:

• Build a Performance Tile view

• Using the Trellis View

• Build a Treemap View

• Creating Performance Tiles

• Build a Heat Matrix View

• Creating a Treemap

• Use Master–Detail linking in views

• Creating a Heat Matrix

• Linking Views Together

This lesson describes how to add and work with geographical maps.

Lessons:

• Add geographical maps

• Lab:

• Work with geographical maps

• Using Map Views

This lesson describes the creation and use of dashboards.

Lessons:

• Distinguish between different types of dashboard objects

• Lab:

• Build a dashboard

• Adding Content and Pages to a Dashboard

This lesson describes how to configure custom dashboards.

Lessons:

• Describe and use dashboard content other than analyses

• Lab:

• Embedding Content in a Dashboard

This lesson describes the nature of Oracle BI variables and how they can be used to customize analyses.

Lessons:

• Explain the different variable types supported by Oracle BI

• Lab:

• Describe and build dashboard prompts

• Overview

This lesson describes how to create and manage scorecards.

Lessons:

• Identify the objects and components of Oracle Scorecard and Strategy

• Create a Scorecard

• Management

• Lab:

• Identify Scorecard Document Type

• Measuring Results with KPIs

• Create and measure Key Performance Indicators

• Building a Scorecard

This lesson describes how to use Visual Analyzer within analyses.

Lessons:

• Develop and visualize reports using Visual Analyzer

• Lab:

• Explain BI Ask

• Using Visual Analyzer

• Describe Data Mashup

• Data Mashup in Visual Analyzer

This lesson describes how to use smart view to create and publish analyses reports to Microsoft Office documents.

Lessons:

• Set up Smart View

• Lab:

• Work with views in Smart View Clients

• Working with Oracle BI Views in Smart View Clients

• Copy and paste Oracle BI content into Microsoft Office

• Creating and Publishing Views Using the View Designer

• Create and publish BI Catalog content from Smart View

This lesson describes how to use Mobile App Designer to create basic mobile apps and pages. Lessons:

• Use Oracle BI Mobile App Designer to create basic mobile apps and tile pages

• Lab:

• Describe subpages

• Creating a Basic Mobile App

• Describe navigation pages

• Designing Apps with Tile Pages

This lesson describes how to add and configure delivery devices.

Lessons:

• Configure delivery devices

• Create and use conditions

• Add delivery profiles

• Lab:

• Build alerts

• Creating and Running an Agent

• Create agents

This lesson describes the management processes of roles and privileges within the presentation catalog.

Lessons:

• Describe the use of roles in administering permissions

• Work with Favorites

• Administer Oracle Business Intelligence Presentation Catalog permissions

• Lab:

• Administer system privileges

• Administering Presentation Catalog Objects and Managing Permissions with Users and Roles

• Explain Oracle BI Briefing Books

• Working with Oracle BI Briefing Books

• Working with Favorites

This lesson describes how to create direct database analysis through SQL and XML.

Lessons:

• Create direct database analyses

• Lab:

• Edit XML and SQL on the Advanced tab

• Changing Direct Database Analysis Privileges

• Modifying XML and SQL

• Creating and Executing a Direct Database Analysis

This lesson describes how to use SQL aggregate, time series and analytical funtions.

Lessons:

• SQL Syntax and Semantics

• Lab:

• Aggregate functions

• performing Various Aggregate, Running Aggregate, and Time Series Functions

• Time series functions

• Performing Conversion Functions

• Advance analytics functions

• Performing Advance Analytics Internal Logical SQL Functions