Data Warehouse Concepts

1. Why we need Data Warehouse?
2. What is Data Warehouse?
3. Data Warehouse Architecture
4. What is Data Acquisition?
5. Types of Tables
6. What is Schema and types of Schemas
7. What is Datamart?
8. Data Warehousing Approces?

Common Concepts of OBIEE 10g and OBIEE 11g
OBIEE 11g Introduction:

1. Why Oracle BI?
2. What is Oracle BI?
3. History of Oracle BI
4. Oracle BI Architecture 11g vs 10g
5. Oracle BI components 11g vs 10g

OBIEE 11g & 10g Practitioner Level

1. Repository Basics
2. Building the Physical Layer of a Repository
3. Building BMM layer of a Repository
4. Testing Repository
5. Working with Multiple Logical Table Sources
6. Adding Calculations of Fact table
7. Creating Dimensional Hierarchies & Level based Measures

OBIEE 10g & 11g Specialist Level

1. Using Aggregate Tables
2. Using Partitions and Fragments
3. Variables(Repository, Session, Presentation & Request)
4. Modeling TimeSeries Data & Time based Measures
5. Configuring Many to Many Relationships (Bridge & Helper Table)
6. Deploying Oracle BI Application to Multiple Countries
   
   • Localizing Oracle BI Metadata
   • Localizing Oracle BI Data
7. Setting Implicit Fact Column
8. Third Party Reporting Toll Integration
9. Creating Repositories From Multi Dimensional Data Sources
10. Security
    
    • Authentication and Authorization
    • Creating Users and Groups
    • Object Level Security
    • Data Level Security
11. Administration of Usage Tracking
12. Multi-User Development Environment (MUDE)
13. Utilities
14. Cache Management
15. Optimizing Query Performance
16. Repository Design Principles
17. Model First
18. Cluster Servers
19. Disconnected Analytics
20. Alias, Circular Joins & Opaque Views or Select Tables

OBIEE 11g & 10g Learner Level Presentation Services or Analytics

1. Introduction to Presentation Services
2. What is Web Catalog & Instance of Config file
3. Shared Folders, Myfolders, Shared Filters, My Filters, My Briefing Books

Answers

1. Working with OBI Answers
2. OBI Column Properties
3. Drill
4. Navigation
5. Conditional Formatting
6. OBI Formulas
7. OBI Filters
8. OBI Sorting
9. OBI Views
10. OBI Request Level Prompts
11. Cascading Prompts
12. Combining with Similar Requests
13. Direct Database Request
14. Presentation Catalog Permissions (Full Control, No Access, Change/Delete, Read, Traverse Folder)
15. Presentation Catalog Privileges (Granted, Denied)

Dashboards

1. Creating Oracle Business Intelligence Interactive Dashboards
2. Working with Dashboard Objects
3. Section
4. Link or Image
5. Embedded Content
6. Text
7. Folder
8. Guided Navigation Link (Static, Conditional and Section)
9. Briefing Book Navigation Link
10. BI Publisher Report
11. Working with Dashboard Prompts
12. What is Dashboard Prompts
13. Types of Dashboard Prompts
14. Page Level Prompts
15. Dashboard Level Prompts
16. Presentation Variables
17. Request Variable

Delivers (iBots in 10g)

1. Introduction to Oracle Bi Delivers
2. Developing IBOTS
3. Configuring Delivery Devices
4. Adding Delivery Profiles
5. Building Alerts

Job Manager

1. Configuring Job Manager
2. Monitoring Scheduled Requests

Oracle BI for Microsoft Office

1. Introduction to Oracle BI for Microsoft Office
2. Working with Oracle BI content in Microsoft Office Applications

Catalog Manager

1. Documentation of Web Catalog
2. Deploying Development to Test or Test to Production

OBIEE 11g New Features

1. Introduction about EM, CONSOLE, ANALYTICS, XMLP SERVER etc
2. OBIEE 11g Advanced Workshop Setup
3. Parent Child Hierarchies
4. Ragged and Skipped Hierarchies
5. Assign ID columns to descriptive columns
6. Using Lookup Tables
7. Horizontal Federation
8. Vertical Federation
9. Combined Horizontal & Vertical Federation
10. Hierarchical Columns and Selection Steps
11. Advanced Reporting, Master Detail Linking
12. New Graphing Options
13. BI Publisher 11g Online Template Builder and Interactive Viewer
14. New Dashboard Features
15. Creating Simple Action Links
16. Creating Advanced Action Links
17. Creating Time Series Measures using Period Rolling
18. Creating Scorecards
19. Creating KPI
20. Working with XML API

BI Publisher 11g & 10g

1. Introduction to BI Publisher or XML Publisher
2. Integrating Database
3. Integrating Oracle BI Presentation Server
4. Integrating Oracle BI Discoverer
5. Configuring Scheduler
6. Installing Oracle BI Publisher Desktop
7. Develop BI Publisher Templates using OBI Answer Request
8. Develop BI Publisher Templates using OBI Subject Areas
9. Develop BI Publisher Templates directly from Database
10. Develop BI Publisher Templates using XML File
11. Working with Parameters and LOV's
12. Scheduling BI Publisher Template