Oracle BI 11g R1: Build Repositories|

Oracle BI 11g R1: Build Repositories

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.

Enquire for more information

By submiting, you agree to our terms and policy

Course Description

About the Course

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.

Learn To:

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.

Benefits to You

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.

Build Logical Business Models

This course will also teach you how to import schemas, design and build logical business models and expose business models to users in the Oracle BI user interface. While constructing the repository, you'll learn how to build physical and logical joins, simple measures and calculation measures.

Model Logical Dimension Hierarchies

You'll then extend the initial repository and learn how to model more complex business requirements. This includes logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions and time series data.

Implement Oracle BI Server Security

Oracle University instructors will also walk you through implementing the Oracle BI Server security and managing the Oracle BI Server cache. You'll learn how to set up a multi-user development environment and use Administration Tool wizards and utilities to manage, maintain and enhance repositories.

Advanced Course Topics

Finally, investing in this course will give you a chance to explore more advanced topics, like implicit fact columns, bridge tables, usage tracking, multilingual environments, write back and patch merge. An appendix is included, which covers architecture and the benefits of the Oracle Exalytics BI Machine.

Course Curriculum

Course # : 14254

Oracle BI 11g R1: Build Repositories

Exam : Oracle BI 11g R1: Build Repositories

Download Syllabus

Oracle BI 11g R1: Build Repositories

Objectives

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

Prerequisites

Required Prerequisite

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

Be Amazed with Online Learning Experience

Future is fast forwarding towards online learning & now it’s becoming easy for everyone to take a world class training from anywhere in the world. Listen from Learnfly Live recent alumni’s studying around the globe.

Paul Spranger

Very comprehensive materials with a clear presentation. I have been teaching digital forensics for over 10 years and I found this training to be very interesting and on-point

Rami Khalife

I have completed the course 20778 Analyzing data with Power BI. The instructor Mr. Abhishek Kumar delivered interactive sessions which were impressively informative. He went through the content in detail which showcased that he has a thorough knowledge of the subject matter. He set up a collaborative medium between instructor and students. You can ask questions and he will give you a presenter view where you can share what you have learnt.
Instructor Abhishek Kumar is a terrific subject expert. I will be happy to take more courses with Learnfly Live from this experience and recommend it to everyone as well. A job well done! I am now going to practice the content taught by Mr. Abhishek so that I can deliver it in my career pursuits.

Miaozi Guo

Cisco training has given me ample exposure to the field. The trainers were good and provided conceptual understanding for core concepts and technology. They supported me throughout the training and even guided me for job opportunities. I would surely recommend SkillCertified™ Live to everyone.

Uno Lapimaa

I've attended SkillCertified™ Live Microsoft SQL Server Self-Paced. It was very useful and enlightening. The training session was great – interactive as well as informative. Trainers were very helpful and offered personal assistance during the training and career guidance after it.