OBIEE online trainijg in hyderabad

DESCRIPTION

Data warehouse Concepts
- Data Warehouse
- Basics of Data Warehousing
- What is OLTP and OLAP?
- Difference between OLTP and OLAP
- Dimensional table
- Fact table
- Aggregate table
- Star schema
- Snowflake schema
- Star schema Vs. Snowflake schema
- Fact Vs. Dimension table
- Fact Vs. Aggregate Table
Overview of OBIEE
- Introduction to Siebel Analytics
- What is OBIEE?
- Introduction to OBIEE 10G
- Introduction to OBIEE 11G
- Advantages of OBIEE
- End to End Life Cycle of OBIEE
- Oracle BI Architecture 11g vs. 10g
- Oracle BI Components 11g vs. 10g
Installation of OBIEE
Repository & Catalog Basics
- Repository Basics
- What is Metadata & Catalog?
- Creating a Repository using BI Administration Tool
- Physical, Business Model and Mapping and presentation layers
- Properties of repository objects
- Online Mode and Offline Mode
- Answers, Dashboards, Administration
- Loading a Repository & Catalog into Oracle BI Server memory
- Administration files, Logs, Services, Folders
Building the Physical Layer of a Repository
- Importing data sources
- Setting up connection pool properties
- Defining keys and joins
- Examining physical layer object properties