We Provide Quality OBIEE Training

We Provide quality OBIEE Training

Course Content:

Data warehouse Concepts:

• DATA AND TYPES OF DATA
• OLTP (ONLINE TRANSACTION PROCESSING)
• OLAP(Online Analytical Processing)
• Difference between OLAP and OLTP
• Data warehouse
• Data Mart
• Basics of Data Warehousing
• Dimensional Modeling Overview
• Types of Tables
• Dimensional table
• FactTable
• Aggregate Table
• Difference between Fact and Dimension Tables
• Difference between Fact and Aggregate Table
• Schema and Types of Schema
• StarSchema
• Snowflake Schema
• Mixed or Fact Constellation
• Difference between Starand SnowFake Schema
• Types of Facts
• Types of Fact Tables
• Types of Dimensions
• Factless Fact Table
• Level of Granularity
• Grain
• SCD TYPE'S

OBIEE Overview:

• Introduction to Nquire
• Introduction to Siebel Analytics
• Introduction to OBIEE 10 G
• Introduction to OBIEE 11 G
• What is Obiee?
• End to End Life Cycle of Obiee
• Advantages of Obiee
• End to End Life Cycle of Obiee
• Types of Reports
• Types of Applications
• Components OF Obiee
• Client Components Of Obiee
• Types of Servers
• Obiee Architecture
• Difference between Obiee 10g and Siebel Analytics
• Difference between Obiee 10g and Obiee 11g
• Obiee11.1.1.7 new features

Repository Basics:

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

Physical Layer:

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

Business Model and Mapping Layer:

• Business Model Objects
• Duplicate Business Model and Presentation Catalog
• Logical Tables
• Logical Columns
• Logical Table Sources (Mappings)
• Dimensions and Hierarchical Levels
• 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
• Fragmented Content, Where Cluase, Logical Levels

Presentation Layer:

• About the Presentation Layer
• Subject Areas
• Presentation Tables and Columns
• Presentation Hierarchies and Levels
• Permissions for Presentation Layer Objects
• Creating Aliases (Synonyms) for Presentation Layer Objects
• Implicit Fact Column
• Nested Folders
• Controlling Presentation Object Visibility

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
• Presentation Variable
• Request Variable

Cache:

• Restricting tables as non-cacheable
• Using Cache Manager
• Inspecting cache reports
• Purging cache entries
• Modifying cache parameters and options

Variable:

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

Security:

• Authentication
• Authorization
• Authorization Types
• Data level Security
• Object Level Security
• Authentication Types
• LDAP Authentication
• External Table Authentication
• Application Roles
• Users and Groups

Analysis:

• Types of Views
• Column Properties
• Filters
• Manage Session
• Advanced Tab
• Actions and Conditions
• Scorecards, KPI, KPI Watchlist

Prompts:

• Inline and Dashboard Prompts
• Column Prompt
• Image 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

MUDE (Multiuser Development Environment)

Catalog manager

Write Back, Usage Tracking

Moving from development to Test to Production

Other Feature we provide:

• FAQS
• Real-time Repositories
• Concentration on performance tuning
• Real time scenarios
• Certification guidance
• Resume preparation
• Sample resumes
• Interview & certification FAQS
• How to face the interview
• Class notes which is useful for who is trying for job
• Project preparation