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