Our Courses  
Course Contents


  • OLAP OLTP Differences
  • Introduction to DATA WAREHOUSING
  • Types of Warehouse Tables
  • Introduction to SDE & SIL
  • Introduction to Data Warehouse Application Console (DAC Concepts)
  • Difference Between SIEBEL ANALYTICS 7/ 7.1/ 7.8 & OBIEE 10G, 11G

Part– II Build Repositories

  1. Repository Basics
    • Oracle BI architecture components
    • Repository structure, features, and functions
    • Using the OracleBI Administration Tool
    • Creating a repository
    • Loading a repository into Oracle BI Server me
  2. Building the Physical Layer of a Repository
    • Importing data sources
    • Setting up connection pool properties
    • Defining keys and joins
    • Examining physical layer object properties
    • Creating alias and select tables
  3. Building the Business Model and Mapping Layer of a Repository
    • Building a business model
    • Building logical tables, columns, and sources
    • Defining logical joins
    • Building measures
    • Examining business model object properties
  4. Building the Presentation Layer of a Repository
    • Exploring Presentation layer objects
    • Creating Presentation layer objects
    • Modifying Presentation layer objects
    • Examining Presentation layer object properties
  5. Testing and Validating a Repository
    • Checking repository consistency
    • Turning on logging
    • Defining a repository in the initialization file
    • Testing a repository using Oracle BI Answers
    • Inspecting the query log
  6. Adding Multiple Logical Table Sources
    • Adding multiple logical table sources to a logical table
    • Specifying logical content
  7. 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
  8. Creating Dimension Hierarchies and Level-Based Measures
    • Creating dimension hierarchies
    • Creating level-based measures
    • Creating share measures
    • Creating rank measures
  9. Using Aggregates
    • Purpose of aggregate tables in dimensional modeling
    • Modeling aggregate tables to improve query performance
    • Testing aggregate navigation
    • Using the Aggregate Persistence Wizard
  10. Using Partitions and Fragments
    • Purpose for segmenting data into partitions and fragments
    • Partition types
    • Modeling partitions in an Oracle BI repository
  11. Using Repository Variables
    • Session variables
    • Repository variables
    • Initialization blocks
    • Using the Variable Manager
    • Using dynamic repository variables as filters
  12. Modeling Time Series Data
    • Using time comparisons in business analysis
    • Using Oracle BI time series functions to model time series data
  13. Modeling Many-to-Many Relationships (THEORY)
    • Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables
    • Using helper tables to model many-to-many relationships for team-based hierarchies in a dimension
  14. Configuring Oracle Business Intelligence data and metadata to support multilingual environments Setting an Implicit Fact Column (THEORY)
    • Selecting a predetermined fact table source
    • Specifying a default join path between dimension tables
  15. Security
    • Creating users and groups
    • Setting permissions for users and groups
    • Authenticating using a external database
  16. Cache Management
    • Multi-user Development
    • Setting up a multi-user development environment
    • Developing a repository using multiple developers
  17. Part– III

  18. Create Reports and Dashboards Working with Oracle Business Intelligence Answers
    • Introduction to OracleBI Answers
    • Working with requests in OracleBI Answers
  19. Filtering Requests in Oracle Business Intelligence Answers
    • Introduction to filters in Answers
    • Adding filter prompts to requests
    • Using saved requests as filters
  20. Views and Charts in Requests
    • Introduction to Answers views and charts
    • Creating a column selector view
  21. Showing Results with Pivot tables
    • Introduction to pivot tables
    • Formatting pivot tables
    • Setting aggregation rules and building formulas
  22. Creating Interactive Dashboards
    • Introduction to Dashboards and pages
    • Dashboard Editor UI elements
    • Composing Dashboard elements
  23. Configuring Interactive Dashboards
    • Types of Dashboard content
    • Embedding content in Dashboards
  24. Administering Oracle Business Intelligence Presentation Catalog
    • Maintaining the OracleBI Presentation Catalog
    • Maintaining security
    • Understanding security inheritance
  25. Using Oracle Business Intelligence Delivers
    • Building alerts
    • Building iBots
    • Introduction to OracleBI Scheduler
  26. Interactive Dashboard Design Principles and Best Practices
    • Understanding Dashboard design principles
  27. Part– IV

    • Using BI Publisher with OBIEE
    Copyright © 2012-14 www.ifocusitolutions.com All rights reserved. Facebook Twitter LinkedIn Blog