OBIEE Training

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 )

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)
• Informatica Server ETLLoading 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
• Message Severity
• Viewing Server Logs

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
• Adding Multiple Logical Table Sources
• Adding multiple logical table sources to a logical table
• Specifying logical content

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 using 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 ggregate 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

Creating dimension hierarchies and level-based measures

• Creating dimension hierarchies
• Creating level-based measures

Providing Security for Groups & UsersANSWERS (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 Orcle 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

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