About us   Registration   Site map    
 
         
   
      New user|Forgot password  
 
   
 
 
Select Your Country to check the Schedule for this Course
Country:  
Time Zone:
   
PAYMENT METHODS
PAYPAL GOOGLE CHECKOUT
Course Name Course Code
OBIEE 77
Course Contents

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

 

 

 

 

 

 

 

PAYMENT METHODS
PAYPAL GOOGLE CHECKOUT