Oracle BI 12c: Create Analyses and Dashboards Ed 2 Course in Oman

Introduction

Explain Oracle Business Intelligence

Describe Oracle Business Intelligence Foundation Suite

Identify and describe the major components of the Oracle Business Intelligence 12c architecture Part 1

Identify and describe the major components of the Oracle Business Intelligence 12c architecture Part 2

Describe Oracle Essbase

Practice 2-1: Exploring Oracle BI Presentation Services Part 1

Practice 2-1: Exploring Oracle BI Presentation Services Part 2

Identify the important elements of analyses Part 1

Identify the important elements of analyses Part 2

Use Analysis Editor

Construct, modify, and save analyses by using the three avaliable types of columns Part 1

Construct, modify, and save analyses by using the three avaliable types of columns Part 2

Construct, modify, and save analyses by using the three avaliable types of columns Part 3

Apply advanced formatting to analyses

Practice 3-1: Creating and Formatting an Analysis Part 1

Practice 3-1: Creating and Formatting an Analysis Part 2

Practice 3-1: Creating and Formatting an Analysis Part 3

Practice 3-1: Creating and Formatting an Analysis Part 4

Practice 3-1: Creating and Formatting an Analysis Part 5

Practice 3-1: Creating and Formatting an Analysis Part 6

Practice 3-2: Controlling the Display of Columns Added to Analyses

Describe the use of filters in limiting the results of analyses

Design and Build Filters in Oracle Business Intelligence analyses

Use a saved analysis as a filter

Edit the SQL for a column filter in an analysis

Add filter prompts to an analysis

Practice 4-1: Adding Filters to Analyses Part 1

Practice 4-1: Adding Filters to Analyses Part 2

Practice 4-2: Adding an Inline Prompt to an Analysis

Practice 4-3: Using a Saved Analysis as a Filter

Practice 4-4: Editing SQL for a Column Filter

Create and saving selections Part 1

Create and saving selections Part 2

Create and saving selections Part 3

Create and save groups and calculated items

Practice 5-1: Using Selections, Groups, and Calculated Items to Manage Analysis Results Part 1

Practice 5-1: Using Selections, Groups, and Calculated Items to Manage Analysis Results Part 2

Practice 5-2: Adding Groups and Calculated Items to an Analysis Part 1

Practice 5-2: Adding Groups and Calculated Items to an Analysis Part 2

Practice 5-3: Including Selected Members Based on Family

Add Additional views of the data that is returned

Work with Compound Layouts

Modify and format views

Perform common tasks in views

Practice 6-1: Modifying and Formatting Views Part 1

Practice 6-1: Modifying and Formatting Views Part 2

Practice 6-1: Modifying and Formatting Views Part 3

Practice 6-1: Modifying and Formatting Views Part 4

Practice 6-1: Modifying and Formatting Views Part 5

Practice 6-2: Using the Table View Part 1

Practice 6-2: Using the Table View Part 2

Create and edit Pivot Tables Part 1

Override default aggregations rules in pivot tables

Format pivot tables

Show relative value of an item in a pivot table

Use calculations in a pivot table

Display running sums in a pivot table

Practice 7-1: Working with Pivot Tables Part 1

Practice 7-1: Working with Pivot Tables Part 2

Practice 7-2: Displaying Running Sums in Pivot Tables Part 1

Practice 7-2: Displaying Running Sums in Pivot Tables Part 2

Build a Trellis View

Build a Performance Tile View

Build a Treemap View

Build a Heat Matrix View

Use Master-Detail linking in views

Practice 8-1: Using the Trellis View Part 1

Practice 8-1: Using the Trellis View Part 2

Practice 8-2: Creating Performance Tiles

Practice 8-3: Creating a Treemap

Practice 8-4: Creating a Heat Matrix

Practice 8-5: Linking Views Together

Visualizing Data on Maps Part 1

Visualizing Data on Maps Part 2

Practice 9-1: Using Map Views

Distinguish between different types of dashboard objects

Build a Dashboard Part 1

Build a Dashboard Part 2

Build a Dashboard Part 3

Build a Dashboard Part 4

Practice 10-1: Adding Content and Pages to a Dashboard Part 1

Practice 10-1: Adding Content and Pages to a Dashboard Part 2

Practice 10-1: Adding Content and Pages to a Dashboard Part 3

Practice 10-1: Adding Content and Pages to a Dashboard Part 4

Add Dashboard Objects

Practice 11-1: Embedding Content in a Dashboard

Explain the Different Variables types supported by Oracle BI

Describe and build dashboard prompts Part 1

Describe and build dashboard prompts Part 2

Describe and build dashboard prompts Part 3

Describe and build dashboard prompts Part 4

Describe and build dashboard prompts Part 5

Practice 12-1: Create Dashboard Prompts and Variables Part 1

Practice 12-1: Create Dashboard Prompts and Variables Part 2

Practice 12-1: Create Dashboard Prompts and Variables Part 3

Practice 12-1: Create Dashboard Prompts and Variables Part 4

Practice 12-1: Create Dashboard Prompts and Variables Part 5

Identify the objects and components of Oracle Scorecards and Strategy Management

Identify Scorecard Document Types

Create a Scorecard and Key Performance Indicators Part 1

Create a Scorecard and Key Performance Indicators Part 2

Create a Scorecard and Key Performance Indicators Part 3

Practice 13-1: Measuring Results with KPIs Part 1

Practice 13-1: Measuring Results with KPIs Part 2

Practice 13-1: Measuring Results with KPIs Part 3

Practice 13-1: Measuring Results with KPIs Part 4

Practice 13-2: Building a Scorecard Part 1

Practice 13-2: Building a Scorecard Part 2

Practice 13-2: Building a Scorecard Part 3

Practice 13-2: Building a Scorecard Part 4

Practice 13-2: Building a Scorecard Part 5

Develop and Visualize reports using Visual Analyzer

Explain BI Ask

Describe Data Mashup

Practice 14-1: Using Visual Analyzer Part 1

Practice 14-1: Using Visual Analyzer Part 2

Practice 14-1: Using Visual Analyzer Part 3

Practice 14-1: Using Visual Analyzer Part 4

Practice 14-2: Data Mashup in Visual Analyzer

Set up Smart View

Work with views in Smart View Clients

Copy and paste Oracle BI content inro Microsoft Office

Create and publish BI Catalog content from Smart View

Practice 15-1: Working with Oracle BI Views in Smart View Clients Part 1

Practice 15-1: Working with Oracle BI Views in Smart View Clients Part 2

Practice 15-1: Working with Oracle BI Views in Smart View Clients Part 3

Practice 15-1: Working with Oracle BI Views in Smart View Clients Part 4

Practice 15-1: Working with Oracle BI Views in Smart View Clients Part 5

Practice 15-2: Creating and Publishing Views Using the View Designer Part 1

Practice 15-2: Creating and Publishing Views Using the View Designer Part 2

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

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

Describe subpages

Practice for Lesson 16-1: Creating a Basic Mobile App Part 1

Practice for Lesson 16-1: Creating a Basic Mobile App Part 2

Practice for Lesson 16-1: Creating a Basic Mobile App Part 3

Practice for Lesson 16-1: Creating a Basic Mobile App Part 4

Configure Delivery Devices and Delivery Profile

Build Alerts

Create Agents Part 1

Create Agents Part 2

Create Agents Part 3

Use Conditions

Practice 17-1: Creating and Running an Agent

Describe the use of roles in administering permissions

Administer Oracle Business Intelligence Presentation Catalog permissions Part 1

Administer Oracle Business Intelligence Presentation Catalog permissions Part 2

Administer system privileges

Explain Oracle BI Briefing Books

Work with Favorites

Practice 18-1: Administering Presentation Catalog Objects and Managing Permissions with Users and Roles Part 1

Practice 18-1: Administering Presentation Catalog Objects and Managing Permissions with Users and Roles Part 2

Practice 18-2: Working with Oracle BI Briefing Books Part 1

Practice 18-2: Working with Oracle BI Briefing Books Part 2

Practice 18-3: Working with Favorites

Create Direct Database Analyses

Edit XML and SQL on the Advanced Tab

Practice 19-1: Changing Direct Database Analysis Privileges

Practice 19-2: Creating and Executing a Direct Database Analysis

Practice 19-3: Modifying XML and SQL

SQL Syntax and Semantics

Aggregate Functions

Time Series Functions

Advance Analytics Functions

Practice 20-1: Performing Various Aggregate, Running Aggregate, and Time Series Functions Part 1

Practice 20-1: Performing Various Aggregate, Running Aggregate, and Time Series Functions Part 2

Practice 20-1: Performing Various Aggregate, Running Aggregate, and Time Series Functions Part 3

Practice 20-2: Performing Conversion Functions

Practice 20-3: Performing Advance Analytics Internal Logical SQL Functions Part 1

Practice 20-3: Performing Advance Analytics Internal Logical SQL Functions Part 2