Data warehousing overview

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

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

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

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

Building Physical Layer of a Repository

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

Building business Model mapping layer

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

Building presentation layer

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

Testing and validating Repository

• Checking repository consistency
  
• Checking Global Consistency
  
• Inspecting Oracle Answers inspecting SQL
  
• Inspecting log files(Nqquery.log,NQSserver.log)

Adding multiple sources to dimension

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

Adding calculations to fact

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

Creating dimensional hierarchies and level based measures

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

Using aggregation

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

Using partition or fragments

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

Using variables

• Presentation Variables
  
• Repository variables
  
•  Session variables
  
• Initialization Blocks

Multiuser Environment (MUD)

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

• Types of SCDS
  
• Using of time series functions

Modeling extension tables

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

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

 Cache management

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

Oracle BI Presentation services

Working with Oracle BI Answers

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

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

Administering OBI Presentation Catalog

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

Using Oracle  BI Delivers

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

Overview of Advanced Topics

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