Oracle BI 11g R1: Build Repositories Training

Live Online & Classroom Enterprise Certification Training

This Oracle BI 11 R1: Build Repositories training is based on OBI EE release 11.1.1.7. It helps you define & build dimensional models for business intelligence processing using the Oracle Business Intelligence Administration Tool; learn to build an Oracle Business Intelligence repository & more.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is 11g R1: Build Repositories Certification Training about?

This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository; you'll begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements.

By taking this course, you'll walk away with the ability to transform your organization’s data into intelligence, which will improve your day-to-day decision making. This new knowledge will help you provide time-critical, relevant and accurate insights. Furthermore, you'll develop skills that will help you become more efficient at building repositories.

What are the objectives of 11g R1: Build Repositories Certification Training ?

Build and run analyses to test and validate a repository
Build simple and calculated measures for a fact table
Create logical dimension hierarchies and level-based measures
Check the model and then model aggregate tables to speed query processing
Model partitions and fragments to improve application performance and usability
Use variables to streamline administrative tasks and modify metadata content dynamically
Use time series functions to support historical time comparison analyses
Set up security to authenticate users and assign appropriate permissions and privileges
Build the Physical, Business Model and Mapping, and Presentation layers of a repository
Apply cache management techniques to maintain and enhance query performance
Set up query logging for testing and debugging
Set up a multiuser development environment
Use the Administration Tool wizards and utilities to manage, maintain, and enhance repositories
Enable usage tracking to track queries and database usage, and improve query performance
Perform a patch merge in a development-to-production scenario
Describe Exalytics machine and the Summary Advisor tool used in the machine

Who is 11g R1: Build Repositories Certification Training for?

Application Developers
Business Analysts
Data Warehouse Analyst
Technical Consultant
Data Modelers
Reports Developer
Business Intelligence Developer
Data Warehouse Administrator

What are the prerequisites for 11g R1: Build Repositories Certification Training?

Suggested Prerequisite

Knowledge on Basic SQL
Knowledge on Dimensional modeling
Knowledge on Data warehouse design

Available Training Modes

Live Online Training

40 Hours

Classroom Training

5 Days

Course Outline Expand All

Expand All

Repository Basics

Using the Oracle BI Administration Tool

Creating a repository

Overview of Exalytics Machine

Loading a repository into Oracle BI Server

Exploring a repository's structure, features, and functions

Exploring Oracle BI architecture components

Installing the BI Client software

Building the Physical Layer of a Repository

Setting up Connection Pool properties

Creating alias tables

Printing the physical layer diagram

Examining physical layer object properties

Defining keys and joins

Importing data sources

Building the Business Model and Mapping Layer of a Repository

Building logical tables, columns, and sources

Examining business model object properties

Building measures

Building a business model

Defining logical joins

Printing the business model and mapping layer diagram

Building the Presentation Layer of a Repository

Creating presentation layer objects

Nesting presentation tables

Modifying presentation layer objects

Controlling presentation layer object visibility

Exploring presentation layer objects

Examining presentation layer object properties

Testing and Validating a Repository

Checking repository consistency

Uploading the repository through Enterprise Manager

Turning on logging

Inspecting the query log

Executing analyses to test the repository

Managing Logical Table Sources

Specifying logical content

Adding multiple logical table sources to a logical table

Adding Calculations to a Fact

Creating new calculation measures based on logical columns

Creating measures using functions

Creating new calculation measures based on physical columns

Creating new calculation measures using the Calculation Wizard

Working with Logical Dimensions

Creating level-based measures

Creating logical dimension hierarchies

Creating share measures

Creating parent-child hierarchies

Creating dimension-specific aggregation rules

Creating presentation hierarchies

Creating ragged and skipped-level hierarchies

Enabling Usage Tracking

Using usage tracking statistics to optimize query performance and aggregation strategies

Tracking and storing Oracle BI Server usage at the detailed query level

Creating the usage tracking tables

Setting up the sample usage tracking repository

Using Model Checker and Aggregates

Using the Aggregate Persistence Wizard

Testing aggregate navigation

Modeling aggregate tables to improve query performance

Setting the number of elements in a hierarchy

Using Model Check Manager

Using Partitions and Fragments

Exploring partition types

Modeling partitions in an Oracle BI repository

Using Repository Variables

Creating repository variables

Using the Variable Manager

Creating initialization blocks

Creating session variables

Using dynamic repository variables as filters

Modeling Time Series Data

Using Oracle BI time series functions to model time series data

Using time comparisons in business analysis

Modeling Many-to-Many Relationships

Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables

Setting an Implicit Fact Column

Selecting a predetermined fact table source

Specifying a default join path between dimension tables

Ensuring the correct results for dimension-only queries

Importing Metadata from Multidimensional Data Sources

Incorporating horizontal federation into a business model

Importing a multidimensional data source into a repository

Incorporating vertical federation into a business model

Adding Essbase measures to a relational model

Displaying data from multidimensional sources in Oracle BI analyses and dashboards

Security

Setting row-level security (data filters)

Setting up object permissions

Creating application roles

Exploring Oracle BI default security settings

Creating users and groups

Setting query limits and timing restrictions

Cache Management

Modifying cache parameters and options

Seeding the cache

Purging cache entries

Using Cache Manager

Inspecting cache reports

Restricting tables as non-cacheable

Exploring the Summary Advisor Tool

Setting up Summary Advisor

Running the aggregate script to create the aggregates

Running the Summary Advisor wizard to create the aggregate script

Using Administration Tool Utilities

Using the various Administration Tool utilities

Using BI Server XML API to create XML representation of repository metadata

Multiuser Development

Developing a repository using multiple developers

Setting up a multiuser development environment

Tracking development project history

Performing a Patch Merge

Applying a patch

Creating a patch

Making merge decisions

Comparing repositories

Equalizing objects

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

11g R1: Build Repositories Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree