OBIEE Certification

We Provide quality OBIEE Training

Course Content:

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 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

Utilities and Wizards

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

MUDE(Multiuser Development Environment)

Catalog manager

Other Feature we provide:

• FAQS
• Realtime 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