COURSE COVERAGE

INTRODUCTION

Overview

This workshop covers using the Oracle Business Intelligence (BI) Administration Tool (11.1.1.7) to

build, modify, enhance, and manage an Oracle BI repository. You learned how to import metadata

from a data source, simplify and reorganize the imported metadata into a business model, and then

structure the business model for presentation to users who request business intelligence information via Oracle BI user interfaces.

Course Methodology

Hardware and Software Requirements

The following is a list of hardware and software requirements:

Have access to or have Installed Oracle Business Intelligence Enterprise Edition 11g.

Please note: This tutorial is built using Oracle Business Intelligence Enterprise Edition

11.1.1.7.0.

To complete this tutorial, you must have access to the schema that is included with Oracle Business Intelligence Suite Enterprise Edition Plus.

The Computer specification shouldn’t be less than a 6GB RAM with at least 100GB hard disk space. The workshop is a complete hands-on practical class.

Target Audience

Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Target Competencies

Participants are expected to have a knowledge or relational database design, adequate knowledge of data modeling and structured design, some basic knowledge of SQL.

Course Outline

Oracle BI Administration Tool Overview and building the Physical layer of a repository.

• Overview of Business Intelligence
• Architecture of Oracle Business Intelligence 11g
• Introduction to the Admin Tool in Business Intelligence
• Building the Physical Layer of a Repository
• Creating a New Repository
• Importing Metadata
• Verifying Connection
• Creating Aliases
• Creating Keys and Joins

Building the Business Model and Mapping Layer of a Repository             

• Creating a Business Model
• Examining Logical Joins
• Examining Logical Columns
• Examining Logical Table Sources
• Renaming Logical Objects Manually
• Renaming Objects Using the Rename Wizard
• Deleting Unnecessary Logical Objects
• Creating Simple Measures

Building The Presentation Layer of the Repository

• Creating a Subject Area
• Creating Presentation Tables
• Creating Presentation Columns
• Renaming Presentation Columns
• Reordering Presentation Columns

Testing and Validating Repository

• Checking Consistency
• Disabling Cache
• Loading the Repository
• Setting Up Query Log
• Creating and Running Analysis
• Checking the Query Log

Managing Logical Table Sources

• Opening the Repository in Offline Mode
• Adding a New Logical Table Source
• Creating Presentation Layer Objects
• Loading the Repository
• Creating and Running an Analysis
• Checking the Query Log

Creating Calculation Measure

• Opening the Repository in Offline Mode
• Creating a Calculation Measure Derived from Existing Columns
• Creating a Calculation Measure Using a Function
• Loading the Repository
• Creating and Running an Analysis
• Checking the Query Log

Creating Logical Dimensions With Level -Based Hierarchies

• Opening the Repository in Offline Mode
• Creating a Logical Dimension for Product
• Creating Logical Levels
• Associating Logical Columns with Logical Levels
• Setting Logical Level Keys
• Creating a Logical Dimension for Time
• Associating Time Logical Columns with Logical Levels
• Creating a Logical Dimension for Customer
• Setting Aggregation Content for Logical Table Sources
• Testing Your Work

Creating level-based Measures

• Opening the Repository in Offline Mode
• Creating Level-Based Measures
• Creating a Share Measure
• Testing Your Work

Creating Logical Dimension With Parent Child Hierarchy

• Opening the Repository in Offline Mode
• Importing Metadata and Define Physical Layer Objects
• Creating Logical Table and Logical Columns
• Creating a Logical Join
• Creating a Parent-Child Logical Dimension
• Defining Parent-Child Settings
• Creating Presentation Layer Objects
• Testing Your Work

Creating Logical Dimension With Ragged and Skipped-Level Hierarchy

• Importing Metadata and Define Physical Layer Objects
• Creating Logical Table and Logical Columns
• Creating a Ragged/Skipped Levels Logical Dimension
• Creating Presentation Layer Objects
• Testing Your Work

Using Aggregates and Initialization Blocks Variables

• Importing Metadata
• Creating New Logical Table Sources
• Setting Aggregate Content
• Testing Your Work
• Creating an Initialization Block
• Creating Variables
• Testing Your Work

Creating Time Series Measures

• Identifying a Logical Dimension as a Time Dimension
• Identifying Level Keys as Chronological Keys
• Creating a Measure Using the AGO Function
• Creating a Measure Using the TODATE Function
• Creating a Measure Using the PERIODROLLING Function

Creating Time Series Measures

• Identifying a Logical Dimension as a Time Dimension
• Identifying Level Keys as Chronological Keys
• Creating a Measure Using the AGO Function
• Creating a Measure Using the TODATE Function
• Creating a Measure Using the PERIODROLLING Function

Beginning the Analytic Process and Creating Analysis

• Logging In
• Favorites Menu
• Searching the Catalog (Basic Search)
• BI Client Installer
• Creating an Analysis and Using the Analysis Editor
• Filtering, Sorting, and Saving your Analysis
• Creating Selection Steps for your Analysis
• Formatting and Adding Totals to your Analysis

Adding Graph to an Analysis and Working with Pivot Tables and Master-Detail Linking

• Enhancing an Analysis by Adding a Graph
• Formatting the Graph
• Creating an Analysis with a Pivot Table View
• Formatting a Pivot Table and Adding Calculations
• Creating a Master-Detail Linking

Building Dashboards

• Exploring and Editing My Dashboard
• Creating a Dashboard
• Editing a Dashboard
• Saving a Customized Dashboard and Setting Preferences
• Exporting the Dashboard to Excel Spreadsheet
• Adding Performance Tile to Analysis
• Adding simple Tiles to an Analysis
• Working with Other View Types

Duration: 6 Saturdays (May 4, 11, 18, 25 June 1, 8)

Customize Your TrainingClass Session : 10:00am – 4:00pm each day including Breakfast and Lunch time