OBIEE, OBIA, Informatica, DAC, OBIEE Administration.

Courses will be provided based on the students profile.  if he is very fresher to IT, classes would be taken care accordingly.  There would be 20-25 hours will be total course duration

• Over 10.6 years of strong experience in Design, Development, Administration and Support experience in OBIEE 10g/OBIEE11g/OBIEE12c and Data Analysis, RPD Data Modeling.

Informatica Power Center, DAC 11g

Good experience in Data Warehouse, Data Modeling using ERwin Tool & UNIX Shell Scripting. 

• Good experience in working with industries including Finance Analytics, Banking, Sales and Healthcare Domain, HR Analytics 

Certified OAC

 Introduction to OBIEE 11g, OBIEE 12c

• 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

 

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