Oracle BI 11g: Build Repositories

  • Overview

    This course acquaints participants with the techniques of building and validating the 3 layers of Oracle Business Intelligence repository.

    Oracle BI (Business Intelligence) repository stores the metadata that is utilized by Oracle BI Server. This metadata may be imported from several databases, as well as data sources. This is based upon special business needs and requirements. The metadata is later organized, customized and simplified, so that it can be presented to the presentation layer.

    Students are posed to cater to a fictitious organization's business requirements.. For this they need to use Oracle BI Administration Tool for designing an easy repository. While constructing repositories, users build physical, as well as logical joins. They also develop calculation measures and simple measures.

    The course imparts the skills required for importing schemas, and designing and developing logical business models. Students learn the way of authenticating work by designing and operating analyses, as well as validating query results with the help of query log. You additionally get the exposure to model complex business issues like aggregate tables, multiple logical table sources, time series data etc.

    Oracle BI 11g: Build Repositories course provides proficiency in advanced terminologies, such as patch merge, usage tracking, implicit fact columns, write back, bridge tables and multilingual environments.

    Other than this, participants learn how to utilize the wizards and utilities of Administration Tool to administer, uphold and augment repositories. They understand the execution of Oracle BI Server security, as well as the management of Oracle BI Server cache. Candidates also get trained in configuring a multi-user development environment.

    Course Objectives

    • Develop and implement analyses to examine and authenticate a dimensional business model
    • Build a dimensional business model to cater to business intelligence requirements
    • Utilize the Oracle Business Intelligence Administration Tool to manage Oracle BI Server
    • Utilize the Oracle Business Intelligence Administration Tool for constructing, administering and sustaining an Oracle BI repository
    • Identify and Apply Best Practices and Repository design principles
    • Identify best practices for end user query performance

    Course Details / Exam(s)

    Schedule for Oracle BI Suite 11g R1: Build Repositories Training Boot Camp
    Course Content Regular Track
    Fast Track
    Oracle BI Suite 11g R1: Build Repositories 6 5
    Total 6 5
    • Basic SQL
    • Data warehouse design
    • Database design
    • Dimensional modeling
    Recommended Courses and Certification:
    Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle BI 11g: Build Repositories at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.
  • Students Reviews
    Matee And Mpakanyane  Koenig IT Training Student

    We enrolled for Career Enabler Oracle Database Administrator which included SQL/PL SQL 10g, Oracle Database Administration 1 and 2 and 10g Upgrade to 11g. We would like to show our profound and...

    Read MoreMatee And Mpakanyane United Arab Emirates
    Nana Ama Afaribea Owusu Boateng Koenig IT Training Student

    My first day of training at the center, I met with my trainer who took me through the agenda for my 51-day stay in India. My trainer, as I would say, really "knows his stuff". Not only is he...

    Read MoreNana Ama Afaribea Owusu BoatengGhana
    Mac-Effort Kwaku Adadey Koenig IT Training Student

    First, I would just like to thank God for giving me the opportunity to train at Koenig in Oracle EBS Financial Management and Supply Chain Management Implementation Specialist. The experience I must...

    Read MoreMac-Effort Kwaku AdadeyGhana
    Gilberto Calunga Koenig IT Training Student

    I'm Gilberto Calunga. My experience of the Oracle WebLogic Training with Koenig was excellent. My trainer had very good knowledge. He was an experienced and a very helpful person, so it was...

    Read MoreGilberto CalungaAngola
    Carlos Da Silva Koenig IT Training Student

    I came to Koenig Delhi for training on Oracle Database 11g: Data Warehousing Fundamentals. It was my first time in Delhi and I had one of the best training experiences with Koenig Solutions. Thanks...

    Read MoreCarlos Da SilvaMozambique
    View All Testimonials
  • Schedule & Course Fees
  • Enquire Now