Business Intelligence Course

1. Installing OBIEE 10.1.3.3.3
2. Theory of Dimensional Modeling
: Star Scheme
: Snow Flake
: Fact Table
: Dimensional Table

3.OBIEE Structure
: Mechanism of OBIEE
: Oracle BI Presentation Server
: Oracle BI Server
: Pop Chart Server
: BI Scheduler Oracle
: Administration Tool

4.Various version Of Oracle BI & Attributes
5. Oracle BI User Interface
* Answer
* Dashboard
* View
* Prompt
* Variable
* User & Group
* Privileges
* Installing OBIEE 10.1.3.3.3
2. Theory of Dimensional Modeling
: Star Scheme
: Snow Flake
: Fact Table
: Dimensional Table

3. OBIEE Structure
: Mechanism of OBIEE
: Oracle BI Presentation Server
: Oracle BI Server
: Pop Chart Server
: BI Scheduler Oracle
: Administration Tool

4. Various version Of Oracle BI & Attributes
5. Oracle BI User Interface
* Answer
* Dashboard
* View
* Prompt
* Variable
* User & Group
* Privileges
* GoNav
6. Oracle BI Administration Tool
I. Browser to Data warehouse Message flow
1. Physical Layer

* How to import Physical Table
* How to Create of Physical Joins
* How to Configure Connection Pools
* Explore Views

II. Logical Layer
* How to create Business Model
* How to create Logical Facts
* How to create Dimensions
* How to create Dimension Hierarchies/Levels
* How to create Measures
* Aggregation Navigation
* Fragmentation of Content and WHERE clause

III. Presentation Layer
1. How to create Presentation Catalog
2. How to create Presentation tables
3. How to create Presentation
4. Columns-Groups, Users, Repository-Variables, Session-Variables, Initialization Blocks

7. To enable Cache

: How to create iBots
: Automated Cache Purging using Event Polling
: Seed Cache

8. Security
I. Authentication

* LDAP
* Database
* Repository
* External-Table
I I. Authorization

: Filters, Data Security - GROUP
: UI Security - WEBGROUPS
9. Siebel Analytics Time-Series Wizard
a) Year Ago, Quarter Ago, Month Ago
10. OBIEE UI Trick
11. OBIEE Repository Trick
12. Real time Project Repository
13. Recap of the session, important website address
GoNav