OBIEE

1	Data Warehouse Concepts	Characteristics of Data warehouse. What is Data warehousing? Principles of Data warehouse. Benefits of DWH. Difference between OLTP and DWH. Architecture of DWH. Approaches of Data warehousing. DWH Lifecycle
2	Data Base	RDBMS Concepts Normalization and DE normalization Techniques DB Modeling SQL (Operators, Functions, Sub Queries, Joins)
3	Data Modeling	Dimensional Table and Types With Hierarchies Fact Table and Types Factless Fact Table Slowly Changing Dimensions TYPE of OLAP's
4	Schemas	Star Flake Schema Snow Flake Schema
5	OBIEE	OBIEE Introduction OBIEE 10g Vs 11g Components of OBIEE Advantages of OBIEE
6	OBIEE 11g Installation	Installation Prerequisites Points of Caution while installing Understanding the need for RCU Installation best practices Difference between Simple and Enterprise Install
7	OBIEE Admin Tool and RPD Modeling	Understanding Online and Offline modes of RPD Creating Repository Using Administration  Tool Repository Basics Building Physical Layer of Repository Building Physical Model and BMM Layer of a Repository Building the Presentation Layer of a Repository Aggregate Persistence and Aggregate Tables Dimension Lookups Hierarchical Tables and Parent Child Hierarchy Modeling a Ragged Hierarchy Dimension Creating Time Series Measures Testing , Validation of a Repository Creating Calculated Measures Creating Dimension Hierarchies Organizing Presentation Layer Working with Initialization Blocks and Variables ( Session and Repository Variables) Adding Multiple Sources Executing Direct Database Requests Working with Aggregates
8	Dashboard and Analysis	Creating and Editing Analysis Creating Interactive Dashboards using Analysis Creating query and chart Working with Filters Working with Pivot Table Building Views and Charts in Requests Creating and Configuring  Interactive Dashboards Creating and Configuring Dashboard Prompts Configuring Action  Links Creating and understanding KPI,KPI Watch lists and Scorecards Oracle BI for MS-Office Sending Alerts Using Delivers    Using Job Manager
9	Architecture And Security Features	Understanding OBIEE 11g Architecture Role of Weblogic Server and Enterprise Manager Admin and managed Server Authentication & Authorization Creating Application Roles Creating Users , Groups, Web Catalog groups LDAP Integration Object & Data Level Security Implementation Web catalog Level Security Implementation

  

  >> BI Introduction 
 >> BI Connection Error
 >> OBIEE 10g and 11g Architecture