LiveZilla Live Help
India : +91 996 395 7366
USA : +1 214 347 4655

OBIEE

OBIEE Online Training

OBIEE
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)
  • 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
  • iewing 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 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
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 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
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