Our Courses  


  • 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