TRAINING

Enroll Now

OBIEE Training  

This OBIEE 12c five-day course covers the entire gamut of Oracle's Flagship BI product. It includes developing reports and dashboards from scratch as well as the new features in 12c. Data Mashup and the Visual Analyzer are featured prominently. The course assumes no prior knowledge however users with 11g experience will benefit from learning the new features.

The course starts by covering basic reporting, dashboards and analysis including use of the new Visual Analyser tool; then, the focus moves onto the data and repository layer showing you how to create an BI Repository (RPD) against both transactional and data warehouse databases. The final day of the course covers systems management including the new Baseline Validation Tool, and takes attendees through OBIEE 12c underlying architecture including security and the installation process.

Prerequisites

There are no prerequisites.

Audience

This course is designed for Developers, Consultants, Project Managers, Tech Leads, and DBAs.

Data warehouse Concepts  

• Data warehouse
•  Data mart
•  Basics of Data Warehousing
•  What is OLTP and OLAP?
• Difference between OLTP and OLAP

Dimensional Modeling Overview

• Introduction to Dimensional Modeling
•   Dimensional table
•  Fact table
•  Aggregate table
•  Star schema
•  Snowflake schema
•  Star schema Vs. Snowflake schema
•  Fact Vs. Dimension table
•  Fact Vs. Aggregate Table
•  Types of Facts
• Types of Fact tables
•  Types of Dimensions
•  Level of Granularity
•  Grain of fact
•   Slowly Changing Dimensions( SCD )
•  Normalization
•   DE normalization

OBIEE Course Content

OBIEE Overview

• Introduction to Siebel Analytics
• Introduction to OBIEE 10 G
• What is Obiee?
• Advantages of Obiee
• End to End Life Cycle of Obiee
• Types of Reports
• Types of Applications
• Components OF Obiee
•  Client Components Of Obiee
•  Obiee Architecture
•  Difference between Obiee 10g and Siebel Analytics
•   Difference between Obiee 10g

Repository Basics

• What is Meta data?
• Creating a Repository using BI Administration Tool
• Physical, Business Model and Mapping, and presentation layers
• Properties of repository objects
• Online Mode and Offline Mode

Building the Physical Layer of a Repository

• Physical Layer from Relational Data Sources
•  Database Objects
• Setting Up and Properties of Connection Pools
• Physical Tables
•  Alias Tables
•  Physical Layer Folders
• Physical Joins
• Defining Physical Foreign Keys and Joins
•  Using Database
•  Viewing Data in Physical Tables or Columns
• Creating and Editing a Column in a Physical Table
•  Fragmented Data
• Primary Key and Foreign Key Relationships
• Complex Joins
• Opaque Views

Business Model and Mapping Layer

• Business Model Objects
• Duplicate Business Model and Presentation Catalog
• Creating and Administering Logical Tables
• Creating and Administering Logical Columns
• Creating and Administering Logical Table Sources (Mappings)
•  Dimensions and Hierarchical Levels
•  Process of Creating and Administering Dimensions
• Unbalanced (Ragged) and Skip-Level Hierarchies
•  Parent-Child Hierarchies
• Subject Areas for Logical Stars and Snowflakes
• Display Folders
•  Logical Joins 
•  Level Based Measures
• Aggregation Navigation
•  Time Series Function

Presentation Layer

• About the Presentation Layer
• Creating and Customizing the Presentation Layer
• Working with Subject Areas
•  Working with Presentation Tables and Columns
• Working with Presentation Hierarchies and Levels
• Setting Permissions for Presentation Layer Objects
• Creating Aliases (Synonyms) for Presentation Layer Objects
•  Controlling Presentation Object Visibility

Advantages of Caching Cache Manager

• Using the Cache Manager
• Monitoring and Managing the Cache
•  Purging and Maintaining Cache

Config Files 

• Nqs Config
• Nqs Server 
•  Nqs Query 
• Instance Config 

Variables

• Variable 
•  Repository Variables 
• Static and Dynamic
• Session Variables 
•  System and Non System Variables 
•  Initialization Blocks 
•  Row Wise Initialization

Security

• Data level Security 
• Object Level Security 
• Authentication 
• Authorization
•  Users and Groups

Types Of Authentication 

• LDAP Authentication
• External Table Authentication
• Database Authentication
•  Oracle BI Delivers and Database Authentication 
•  Oracle BI Server User Authentication

Analysis

• Types of Views
• Column  Properties
•  Filters

Dashboards

• Dashboard Page
• Dashboard Objects
•  Actions and Conditions
•  Kpi and Scorecard

Prompts

• Inline and Dashboard Prompts
•  Column Prompt
• Image Prompt"
•  Currency Prompt"
•  Variable Prompt

Administering Oracle Business Intelligence Presentation Catalog

• Maintaining the OracleBI Presentation Catalog
• Maintaining security
• Understanding security inheritance

Using Oracle Business Intelligence Delivers

• Building alerts
•  Building  Agents
•  Introduction to OracleBI Scheduler