Oracle BI Suite 11g R1: Build Repositories Training & Certification Courses
 800 Ratings

Enquire Now


 
Loading...  

Processing data, please wait...

Live Chat
Oracle #1 Training Partner
Oracle #1 Training Partner
Official Curriculum
Official Curriculum
Guarantee to Run the Classes
Guarantee to Run the Classes
Hello Koenig

Overview

In this Oracle BI 11g R1: Build Repositories course, you will learn 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.

Course Objective

  • 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

Target Audience

  • Administrator
  • Analyst
  • Architect
  • Developer
  • Implementer

This course prepares you for Exam 1Z0-591-JPN.

Need more info ? Email info@koenig-solutions.com  or   Enquire now!

Schedule & Prices

Delivery Mode Location Course Duration Fees Schedule
Instructor-Led Online Training (1-on-1) Client's Home/Office5 Days $ 4,210 As per mutual convenience (4-Hours Evenings & Weekends Possible
Classroom Training * Dubai 5 Days $ 4,910
9-13 Jun 2019,
7 Jul -11 Jul 2019,
4 Aug -8 Aug 2019
Delhi, Bangalore, Dehradun (Rishikesh), Goa, Shimla, Chennai 5 Days $ 2,010
3 Jun -7 Jun 2019,
10 Jun -14 Jun 2019,
17 Jun -21 Jun 2019,
1 Jul -5 Jul 2019,
8 Jul -12 Jul 2019,
15 Jul -19 Jul 2019,
29 Jul -2 Aug 2019,
5 Aug -9 Aug 2019,
12 Aug -16 Aug 2019
Fly-Me-a-Trainer Client's Location5 Days On Request As per mutual convenience

Oracle BI Suite 11g R1: Build Repositories Benefits

  • Repository Basics
  • Building the Physical Layer of a Repository
  • Building the Business Model and Mapping Layer of a Repository
  • Building the Presentation Layer of a Repository
  • Testing and Validating a Repository
  • Managing Logical Table Sources
  • Adding Calculations to a Fact
  • Working with Logical Dimensions
  • Using Aggregates
  • Using Partitions and Fragments
  • Using Repository Variables
  • Modeling Time Series Data
  • Modeling Many-to-Many Relationships
  • Localizing Oracle BI Metadata and Data
  • Setting an Implicit Fact Column
  • Importing Metadata from Multidimensional Data Sources
  • Security
  • Cache Management
  • Enabling Usage Tracking
  • Multiuser Development
  • Configuring Write Back
  • Performing a Patch Merge
Need more info ? Email info@koenig-solutions.com  or   Enquire now!
Delhi
Bangalore (Bengaluru)
Goa
Shimla (Himalayas)
Chennai
Dehradun
Dubai
USA Singapore
All rights reserved. ©1997 - 2019, Koenig Solutions Pvt. Ltd.
PMP® is a registered trademark of the Project Management Institute.
Koenig Solutions Pvt. Ltd. is rated 4.4 stars by www.facebook.com/KoenigSolutions based on 107 reviews

Please Input Captcha Below

Submit