Oracle Business Intelligence

Datawarehousing Concepts
  • Introduction and Definition
  • Sources, Transformations and Targets( Architecture )
  • Data Extraction, Data Transformations and
    Data Loading( Data Acquisition Process )
  • Data Warehousing Approaches
  • Staging Area, Metadata, Repository and Data Mart
  • Differences between OLTP and OLAP( DSS ) Systems
  • Operational Data Store( ODS )
  • Business Intelligence
  • Star Schema Design & Confirmed Dimension,
    Fact less Fact Table, Types of Facts
  • Slowly Changing Dimensions( SCD )
OBI Overview
New Features of OBI
OBI Architecture
  • Clients
  • OBI Presentation Services
  • OBI Server
  • OBI Repository (.rpd)
  • Data Sources
OBI Components
  • OBI Administration Tool
  • OBI Answers
  • Intelligence dashboards
Repository Basics
  • Oracle Business Analysis Warehouse
  • DAC and Informatica Server
  • Informatica Server ETL
  • Sample Request Processing
  • Using the OracleBI Administration Tool
  • Repository Directory
  • Repository Files ( Initialization files and log files)
  • Loading a repository into Oracle BI Server memory
  • Creating a repository
  • Connection Pool
  • Repository Modes ( ONLINE and OFFLINE )
  • Physical Layer
  • Business Model & Mapping Layer
  • Presentation Layer
  • Presentation Catalogs, Folders and Columns
  • Error Messages
Building the Physical Layer of a Repository
  • Defining an ODBC System DSN
  • Setting up connection pool properties
  • Importing data sources ( Physical Schema )
  • Verifying the import
  • Defining physical keys and joins
  • Creating alias and select tables
Building the Business Model and Mapping Layer of a Repository
  • Creating the logical business model
  • Creating the logical tables, columns, and sources
  • Defining logical joins
  • Adding Calculation to a Fact Table
  • Building measures
Building the Presentation Layer of a Repository
  • Creating a new Presentation Catalog
  • Modifying Presentation layer objects
  • Rename tables
  • Reorder Table
Testing and Validating a Repository
  • Checking repository consistency
  • Defining a repository in the initialization file
  • Testing a repository using Oracle BI Answers

Adding Multiple Logical Table Sources
  • Adding multiple logical table sources to a logical table
  • Specifying logical content
Adding Calculations to a Fact Table
  • Creating new calculation measures based on existing logical columns
  • Creating new calculation measures based on physical columns
  • Creating new calculation measures us ing the Calculation Wizard
Creating Dimension Hierarchies and Level-Based Measures
  • Creating dimension hierarchies
  • Creating level-based measures

Creating & Using Aggregates

  • Purpose of aggregate tables in dimensional modeling
  • Modeling aggregate tables to improve query performance
  • Testing aggregate navigation

Using Initialization Blocks Repository Variables

Creating Dynamic Repository Variables

Execute Direct Database Requests

  • Accessing database directly

Creating Time series Measures

  • Using time comparisons in business analysis
  • Using Oracle BI time series functions to model time series data

Providing Security for Groups & Users

Answers (REPORTS):-

Working with Oracle Business Intelligence Answers

  • Introduction to Oracle BI Answers
  • Working with requests in Oracle BI Answers
  • Using advanced formatting
  • Creating report Level Hierarchy

Filtering Requests in Oracle Business Intelligence Answers

  • Introduction to filters in Answers
  • Adding filter prompts to requests
  • Using saved requests as filters

Building Views and Charts in Requests

  • Introduction to Answers views and charts
  • Creating and editing charts
  • Performing common view tasks
  • Creating a Narrative View
  • Creating a column Selector
  • Creating View Selector

Showing Results with Pivot Tables

  • Introduction to pivot tables
  • Formatting pivot tables
  • Setting aggregation rules and building formulas

Creating Oracle Business Intelligence Interactive Dashboards

  • Introduction to Interactive Dashboards and pages
  • Adding Objects to Dashboard
  • Creating Dashboard prompts
  • Embedding content in an Interactive Dashboard