Oracle BI 11g R1: Build Repositories

Description

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

Radiant Teachlearning offers Oracle BI 11g R1: Build Repositories Training Program in Classroom and Virtual instructor Led/Online mode.

Duration: 5 days

Learning Objectives

Build and execute analyses to test and verify a dimensional business model.
Use the Oracle BI Adminstration Tool to administer Oracle BI Server.
Use the Oracle BI Administration Tool to build, manage and maintain an Oracle BI repository.
Build a dimensional business model to address business intelligence requirements.
Validate your work by creating and running analyses, and verifying query results using the query log.
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

Benefits to You

By taking this training program, professionals will walk away with the ability to transform your organization’s data into intelligence, which will optimize your day-to-day decision making. This new understanding will help professionals provide time-critical, relevant and accurate insights. Furthermore, professionals will learn skills that will help professionals become more efficient at building repositories.

Build Logical Business Models

This training program will also teach professionals way to import design, schemas and build logical business models and expose business models to users in the Oracle BI user interface. While constructing the repository, professionals will learn way to build logical and physical joins, simple measures and calculation measures.

Model Logical Dimension Hierarchies

Professionals will then extend the initial repository and learn way to model more complex business needs. This includes logical dimension hierarchies, multiple logical, aggregate tables, table sources, partitions and time series data.

Implement Oracle BI Server Security

Oracle University instructors will also walk professionals through executing the Oracle BI Server security and managing and maintaining the Oracle BI Server cache. Professionals will learn way to set up a multi-user development environment and use Administration Tool wizards and utilities to enhance, manage and maintain repositories.

Advanced Course Topics

Finally, investing in this training program will give professionals a chance to explore more advanced topics, such as implicit fact columns, usage tracking, bridge tables, multilingual environments, write back as well as patch merge. An appendix is included, which covers architecture and the advantages of the Oracle Exalytics BI Machine.

Pre-requisites

Required Prerequisite

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

Audience Profile

Administrator
Analyst
Architect
Developer
Implementer

Course Content

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

FAQs

Q: What knowledge should I have as a prerequisite?

A: One should be have :-

Knowledge about SQL design
Knowledge about Data Warehouse
Knowledge about Dimensional Modelling

Q: What does OBIEE stands for?

A: OBIEE stands for Oracle Business Intelligence Enterprise Edition.

Q: What are the three layers of BI repository?

A: The three layers are:-

Physical layer
Business model and mapping layer
Presentation layer

Q: What is meant by RPD file in BI?

A: The OBIEE repository database is known as RPD file defined because of OBIEE file extension. It contains metadata, security files and database connection information.

Q: What is the role of OBI administration tool?

A: The Oracle BI Administration Tool is the user interface into the layers in the repository discussed before.

Q: What’s the role of OBI reporting tool?

A: OBI tool produces and delivers the enterprise reports, scorecards, dashboards, ad hoc analysis.

Q: Why one should prefer Radiant Techlearning ?

A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.

Q: What if I/we have doubts after attending your training program?

A: Radiant team of experts would be available on the e-mail support@radianttechlearning.com to answer your technical queries even after the training program.

Q: Does this training program include any project?

A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.

Q: If I face technical difficulty during the session then is there any remedy for that?

A: Technical issues are unpredictable and might occur with us as well. Participants have to ensure that they have access to the required configuration with good internet speed.

Q: What is schedule of training program?

A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend. We provide you complete liberty to choose the schedule that suits to your need.