OBIEE Server Admin (O1047) Training Course

Training Course Objectives

Deliver meaningful real-time metrics, measurements and facts to your business users when you master the components in Oracle's Business Intelligence Enterprise Edition (OBIEE). Our instructor-led courses cover the key elements in the OBIEE suite, including tools to build interactive dashboards, perform ad hoc analysis, configure information deliveries, alerts and produce reporting. This Administration course teaches the attendee how to set up and administer the three layers of an Oracle BI Repository - the Physical layer, the Business layer, and the Presentation layer. Attendees will learn to import schemas, design and build logical business models, and expose business models to users in Oracle BI Answers. Business users, data architects and developers - every member of your team will contribute to the success of your next BI project.

Whether you are planning to implement OBIEE and want to evaluate the product or you've implemented OBIEE and want to get the most from out of your investment, iTrain OBIEE courses are built to give you the knowledge and skills you need.

Who Should Attend

• Database Administrators
• Data Warehouse Administrators
• BI Developers
• BI Power Users
• Business Analysts
• Data Modelers

Training Course Prerequisites

• OBIEE Reports Dashboards (O1046)
• Oracle SQL
• Knowledge of DB Modelling and Design

Training Course Duration

5 Days

Training Course Contents

Objectives

• Learn how to use physical database objects as data sources
• Learn how to convert those physical sources into a Business Model
• Learn how to expose the business model to the user community
• Learn how to implement a security model
• Learn about caching for enhanced performance
• Learn how to use advanced features of the tool

OBIEE Server and Repository

• Configuration of the Oracle BI Server environment
• Prerequisites- Hardware and Software Requirements for - Installing Oracle BI EE
• Installing and configuring OBIEE
• Physical Repository Design
• Adding Multiple Sources of Data source
• Compare oracle database data with ms excel datasheet
• Metadata Layer Design
• Building Presentation layer
• Dimensions, Facts and Measures
• Mapping to Star and Snowflake Schemas
• Creating Repository
• Repository Management
• Multi User Development in OBIEE
• Merging Multiple Repositories in OBIEE
• Using Catalog Manager
• About NQSConfig.ini and key configuration files in OBIEE
• Using Aggregates and the Aggregate persistence wizard
• Using Alias tables and Dynamic Physical Tables
• Initialization Blocks
• Session Variables and Repository Variables
• Time Series Data
• Dimension Hierarchies and Level Based Measures
• Calculations on Fact Tables
• Exploring Logical Join types

Security Concepts and Setup

• Security and User Management Caching
• Cache Management in OBIEE
• Catalog Setup
• Documentation
• Configuration of BI Delivers
• Configuring OBI Scheduler Tables
• Configuring OBI Scheduler
• Testing iBot

Next Available Dates

• 13th Sep 2010  Manchester
• 20th Sep 2010  Leeds
• 18th Oct 2010  Leeds
• 25th Oct 2010  Edinburgh