Oracle BI EE 10g

Learn To:

·         Identify the analytical business challenge and the solution provided by Oracle BI products

·         Navigate a Oracle BI Analytics Intelligence Dashboard

·         Describe the role of key components in the architecture

·         Build queries in Oracle BI Answers

·         Working with Views, Charts and Pivot Tables

·         Create and modify Oracle BI Interactive Dashboards

·         Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository

·         Use the Oracle BI Administration Tool to administer Oracle BI Server

·         Build a dimensional business model to address business intelligence requirements

·         Use Oracle BI Answers to build and execute queries to test and verify a dimensional business model

Course Content:

1)      Oracle Business Intelligence Enterprise Edition: Overview

Define and describe business analytics and business intelligence

Identify the analytical business challenge and the solution provided by Oracle BI products

Define and describe data warehousing and data modeling

Identify and describe the Oracle BI Enterprise Edition products used to support business intelligence requirements

2)      Exploring the Oracle BI Enterprise Edition User Interface

Use Oracle BI Answers to construct, modify, and save analytics requests

Navigate a Oracle BI Analytics Intelligence Dashboard

3)      Oracle BI Enterprise Edition Architecture

Identify the major components that make up the Oracle BI Enterprise Edition architecture

Describe the role of key components in the architecture

Describe the relationships among the components

4)      Working with Oracle Business Intelligence Answers

Introduction to OracleBI Answers

Working with requests in OracleBI Answers

5)      Filtering Requests in Oracle Business Intelligence Answers

Introduction to filters in Answers

Adding filter prompts to requests

Using saved requests as filters

6)      Views and Charts in Requests

Introduction to Answers views and charts

Creating a column selector view

7)      Showing Results with Pivot tables

Introduction to pivot tables

Formatting pivot tables

Setting aggregation rules and building formulas

8)      Creating Interactive Dashboards

Introduction to Dashboards and pages

Dashboard Editor UI elements

Composing Dashboard elements

9)      Configuring Interactive Dashboards

Types of Dashboard content

Embedding content in Dashboards

10) Administering Oracle Business Intelligence Presentation Catalog

Maintaining the OracleBI Presentation Catalog

Maintaining security

Understanding security inheritance

11) Using Oracle Business Intelligence Briefing Books

Using OracleBI Briefing Books

Creating and editing OracleBI Briefing Books

12) Repository Basics

Oracle BI architecture components

Repository structure, features, and functions

Using the Oracle BI Administration Tool

Creating a repository

Loading a repository into Oracle BI Server memory

13) Building the Physical Layer of a Repository

Importing data sources

Setting up connection pool properties

Defining keys and joins

Examining physical layer object properties

Creating alias and select tables

14) Building the Business Model and Mapping Layer of a Repository

Building a business model

Building logical tables, columns, and sources

Defining logical joins

Building measures

Examining business model object properties

15) Building the Presentation Layer of a Repository

Exploring Presentation layer objects

Creating Presentation layer objects

Modifying Presentation layer objects

Examining Presentation layer object properties

16) Adding Multiple Logical Table Sources

Adding multiple logical table sources to a logical table

Specifying logical content

17) Adding Calculations to a Fact Table

Creating new calculation measures based on existing logical columns

Creating new calculation measures based on physical columns

Creating new calculation measures using the Calculation Wizard

18) Creating Dimension Hierarchies and Level-Based Measures

Creating dimension hierarchies

Creating level-based measures

Creating share measures

Creating rank measures

19) Modeling Aggregates

Purpose of aggregate tables in dimensional modeling

Modeling aggregate tables to improve query performance

Testing aggregate navigation

Using the aggregate persistence wizard

20) Using Partitions and Fragments

Purpose for segmenting data into partitions and fragments

Partition types

Modeling partitions in an Oracle BI repository

21) Repository Variables

Session variables

Repository variables

Initialization blocks

Using the Variable Manager

Using dynamic repository variables as filters

22) Security

Creating users and groups

Setting permissions for users and groups

Authenticating using a external database

Authenticating using database authentication

Setting query limits and timing restrictions

Setting filters to personalize information