Duration : 40 Hours
Prerequisites
– Basic SQL
– Data warehouse design
– Database design
– Dimensional modeling
– Oracle BI: Create Analyses and Dashboards

Course Overview

In this course  you will learn how to use the tools and components of the Business Intelligence Foundation Suite. But the difference is that this course is intended for individual whose major role is to define and build dimensional models used for business intelligence processing. This course will teach you how to use the Oracle Business Intelligence Administration Toll to build and Oracle Business Intelligence repository and perform administrative tasks in a more efficient way. You will also learn how to validate your work by using Oracle Business Intelligence query tools to build reports and verify query result.

Course Content

OBIEE – Build Repositories

  • 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
  • Adding Multiple Logical Table Sources
  • Adding Calculations to a Fact Table
  • Creating Dimension Hierarchies and Level-Based Measures
  • Using Aggregates
  • Using Partitions and Fragments
  • Using Repository Variables
  • Modeling Time Series Data
  • Modeling Many-to-Many Relationships
  • Configuring Oracle Business Intelligence data and metadata to support multilingual environments
  • Setting an Implicit Fact Column
  • Integrating Third-Party Reporting Tools with Oracle BI Server
  • Creating Repositories Using Multidimensional Data Sources
  • Security
  • Cache Management
  • Setting Up and Administering Usage Tracking
  • Multi-user Development
  • Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories

Schedule A Training

Name *

Company Name*

Number

Email*

Training Location*

Prefered Start Date

Your Message