Price: Check with seller

Sponsored Ads

Description


  • Data warehouse Concepts

    • Data Warehouse

    • Basics of Data Warehousing

    • What is OLTP and OLAP?

    • Difference between OLTP and OLAP

    • Dimensional table

    • Fact table

    • Aggregate table

    • Star schema

    • Snowflake schema

    • Star schema Vs. Snowflake schema

    • Fact Vs. Dimension table

    • Fact Vs. Aggregate Table



  • Overview of OBIEE

    • Introduction to Siebel Analytics

    • What is OBIEE?

    • Introduction to OBIEE 10G

    • Introduction to OBIEE 11G

    • Advantages of OBIEE

    • End to End Life Cycle of OBIEE

    • Oracle BI Architecture 11g vs. 10g

    • Oracle BI Components 11g vs. 10g



  • Installation of OBIEE

  • Repository & Catalog Basics

    • Repository Basics

    • What is Metadata & Catalog?

    • Creating a Repository using BI Administration Tool

    • Physical, Business Model and Mapping and presentation layers

    • Properties of repository objects

    • Online Mode and Offline Mode

    • Answers, Dashboards, Administration

    • Loading a Repository & Catalog into Oracle BI Server memory

    • Administration files, Logs, Services, Folders



  • 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



  • Building the Business Model and Mapping Layer of a Repository

    • 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



  • Building the Presentation Layer of a Repository

    • Exploring Presentation layer objects

    • Creating Presentation layer objects

    • Modifying Presentation layer objects

    • Examining Presentation layer object properties



  • 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



  • Adding Multiple Logical Table Sources & Adding Calculations to a Fact Table

    • Adding multiple logical table sources to a logical table

    • Specifying logical content

    • 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 share measures

    • Creating rank measures



  • Using Aggregates

    • Purpose of aggregate tables in dimensional modeling

    • Modeling aggregate tables to improve query performance

    • Testing aggregate navigation

    • Using the Aggregate Persistence Wizard



  • Using Variables

    • Session variables

    • Repository variables

    • Initialization blocks

    • Using the Variable Manager

    • Using dynamic repository variables as filters



  • Security

    • Creating users and groups

    • Setting permissions for users and groups

    • Authenticating using a external database

    • Authenticating using database authentication

    • Setting query limits and timing restrictions

    • Setting filters to personalize information



  • Cache Management

    • Restricting tables as non-cacheable

    • Using Cache Manager

    • Inspecting cache reports

    • Purging cache entries



More Details

Total Views:6
Reference Id:#585158
Phone Number: 9989275111
Website URL: Click To Visit
Current Rating: /5 0 Vote
Copyright © 2017 |   All Rights Reserved |   TuffClassified |   24x7 support |   Email us: query[at]tuffclassified.com