OBIEE Online Training

1). Data warehousing overview

• Basics of Data Warehousing
• What are OLTP and OLAP?
• Difference between OLTP and OLAP
• Advantages of OLAP
• What is Data Marts and ODS?

2). Dimensional Modelling Overview

• Introduction to Dimensional Modelling
• What are Facts and Dimensions?
• Star schema and Snowflake schema

3). Introduction to Business Intelligence

• What is Business Intelligence
• Where BI tools are Used
• Architecture, Components
• Why the Oracle Business Intelligence
• Clients – Answers, Delivers, Dashboards and Web administration,
• Servers- Oracle BI server, Presentation, Scheduler server
• Advantages

4). 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

5). Building Physical Layer of a Repository

• Objects of Physical Layer
• Build physical layer
• DSN for a data sources

6). Building business Model mapping layer

• Objects of BMM layer
• Building Business model (creating logical tables, columns, joins)
• Creating simple measures

7). Building presentation layer

• Objects of presentation layer
• Properties of the presentation layer
• Build presentation layer

8). Testing and validating Repository

• Checking repository consistency
• Checking Global Consistency
• Inspecting Oracle Answers inspecting SQL
• Inspecting log files

9). Adding multiple sources to dimension

• De-normalizing tables structures in database design
• Adding multiple sources to existing logical tables source
• Adding second table sources

10). Adding calculations to fact

• Calculation measures on the basis of physical and logical columns
• Using Calculation wizard

11). Creating dimensional hierarchies and level based measures

• Creating dimensional hierarchies
• Use level based measures
• Create Rank and Share measures

12). Using aggregation

• Importing Aggregated Tables into Repository
• Modeling aggregate tables to speed processing

13). Using partition or fragments

•  Identifying reasons to segment data
•  Techniques to model partitions
•  Value based partitioning

14). Using variables

• Presentation Variables
• Repository variables
• Session variables

15). Multiuser Environment (MUD)

• Overview on Multiuser Environment (MUD)
• How to create projects in MUD
• Checkout and check in of projects

16). Modeling time series data

• Types of SCDS
• Using of time series functions

17). Modeling extension tables

• Purposes of extension tables
• Modeling extension tables for fact and dimensions

18). Oracle BI Security

• Security at object and data level
• Creating users and User groups
• Assigning permissions to users
• Setting Query limits and timing restrictions
• Authenticating using an external database

19). Cache management

• Purge cache and event handling tables
• Making the table cacheable
• Setting of cache in NQSCONFIG.INI file

20). Working with Oracle BI Answers

• Adding Column Filter Prompts in Answers
• Building Business Requests using Answers
•  Adding filters to Business requests
• Views and charts in requests

21). Creating Oracle Intelligence Dashboards

• Creating dashboard pages using report requests
• Creating dashboard prompts
• Configuring guided navigation links
• Adding content to dashboard
• Conditional links and conditional section

22). Administering OBI Presentation Catalog

• Creating catalog groups, issuing privileges etc
• Using catalog management to maintain web catalog

23). Using Oracle BI Delivers

• Configuring delivery devices
• Add delivery profiles
• Build Oracle alerts
• Create ibots
• Configuring Oracle scheduler database
• Configuring of Event poll tables

24). Overview of Advanced Topics

• BI Applications/ Pre-Built RPO
• ETL Integration using DAC
• BI Publisher