Training Course:
Oracle BI Repository Design and Administration

Course Title:Oracle BI Repository Design and Administration
Training Mode:Instructor-led in-class training course
Duration:16 hours
Computer Lab:yes

Brief introduction

Learn how to design and create the semantic BI layer that will enable self-service data analysis and ensure consistency of delivered information across your organisation 


Regardless of the information governance model in place, information professionals responsible for the design, build, deployment and maintenance of corporate data analysis capability are feeling the pressure to deliver more information assets in the shortest period of time possible.

The advanced semantic layer structure provides a single version of facts for all system users and applications and provides transparent views of corporate information to all stakeholders and participants in the analytical processes. A Common Information Model provides authorised users with consistency of semantics across various business units, subject areas, analyses and reports. It allows the implementation of a common organisation-wide business and technical language, which is essential for the effective discovery, access, use and sharing of information.

This course will enable BI administrators and specialists to deliver information models that allow the query process to become a natural process by enabling analysts to structure queries in the same intuitive fashion as they would ask business questions.  It will teach participants to define complex business measures in calculations, expressed in business terms and deliver a consistent dashboard view for the relevant KPIs, enabling flexible and fast data exploration and discovery and supporting rapid visual analysis in a consistent manner and in accordance to establish information governance practice.

Learning Objectives
  • Understand the concept and benefits of the Common Enterprise Information Model
  • Understand the fundamental concepts of dimensional modelling
  • Understand the process of creating a repository and using Physical, Business Model and Presentation Layers
  • Learn how to build simple calculated measures for a fact table
  • Learn how to create logical dimension hierarchies and level-based measures
  • Learn why and how to model aggregate tables to speed query processing
  • Learn techniques and good practices to improve BI performance and usability
  • Learn how to streamline administrative tasks
  • Learn how to implement security protocol
  • Learn about a multiuser development environment
  • Business Analysts
  • Data Warehouse Analyst
  • Technical Consultant
  • Data Modelers
  • Report Developer
  • BI Specialist
  • Working knowledge on Dimensional modelling
  • Basic experience in SQL scripting
  • Knowledge of Data Warehouse design

Introduction to Common Enterprise Information Model

  • Information Governance
  • Concept of BI Semantic Layer

Dimensional Model

  • Introduction to dimensional model
  • Kimball vs Inmon Approach
  • Star Schema Design
  • Facts
  • Dimensions
  • Hierarchies
  • KPIs

Overview of Oracle BI Platform

  • Oracle BI repository concepts, structure and features
  • Oracle BI platform architecture components
  • Introduction to Web Catalog
  • Introduction to Repository
  • Using the Oracle BI Administration Tool

Introduction to Physical Layer

  • Physical Layer overview
  • Importing Data Sources
  • Configuring Connection Pools
  • Physical Tables
  • Physical Model Diagram
  • Defining keys and joins
  • Object properties
  • Alias Tables
  • Demo: Import Data into Physical Layer
  • Lab: Import Data into Physical Layer

Introduction to Business Model and Mapping Layer

  • Business Model and Mapping Layer overview
  • Building a business model
  • Logical Tables
  • Logical joins
  • Logical expressions
  • Configuring measures
  • Adding calculations to a Fact
  • Business Model Diagram 

Introduction to Presentation Layer

  • Presentation Layer overview
  • Subject Areas
  • Folders
  • Presentation Layer objects

Extending Information Model

  • Conformed Dimensions
  • Non-conformed Dimensions
  • Degenerate Dimensions
  • Creating stories

Advanced Information Model Features

  • Calculated Columns
  • Modelling aggregate tables
  • Aggregate Navigations
  • Security
  • Partitions and Fragments
  • Cache Management
  • Usage Tracking
  • Multiuser Development
Related Training