BIGtheme.net http://bigtheme.net/ecommerce/opencart OpenCart Templates
Vaishnot IT Online Training

OBIEE Online Training Course Details

OBIEE or Oracle Business Intelligence Enterprise Edition Plus is the future of business intelligence. OBIEE is compatible with BI server providing integration among the tools. It is a complete architecturally unified business intelligence system when utilized along with Essbase, a multidimensional database management system.

OBIEE online training details about the delivers abilities for reporting, ad hoc query and analysis, online analytical processing (OLAP), dashboards, and scorecards.

OBIEE course curriculum includes all enterprise data sources, as well as metrics, calculations, definitions, and hierarchies are managed in a Common Enterprise Information Model, providing users with accurate and consistent insight, regardless of where the information is consumed.

OBIEE training enlightens about the ways users can access and interact with information in multiple ways, including web-based interactive dashboards, collaboration workspaces, search bars, enterprise resource planning (ERP) and customer relationship management (CRM) applications, mobile devices, and Microsoft Office applications.

OBIEE online training is all about working with business experts to design universes that meet the needs of the business and create quality and consistency of reporting across multiple areas.

OBIEE course, designed by experts is centered on logical and physical data modeling, relational database design, and multi-dimensional modeling.

OBIEE training gives an insight on codes, tests, debug, documents while implementing and maintaining software applications. It briefs about the ways to analyze requirements, and maintains tests and integrates application components.

Prospects of OBIEE:

Where ever there is a need to address the alignment of IT and business strategies OBIEE is dominant. Most corporate for whom supply chain management is one of their tools for enhanced business intelligence, employ these professionals.

These professionals aid in connecting individuals, data and businesses, across business networks for better functioning. The key functions of the OBIEE professionals include performance management, planning, reporting, query and analysis, for enterprise information management.

This course gives an insight into the set of software applications that help companies improve activities across multiple operating systems.

———————————————————————————————————————————————————————

Online OBIEE Training Course Topics

Duration: 4 Weeks

Data Warehousing Basic Concepts

  • Data Warehouse Definition,
  • Characteristics of DWH
  • OLTP Vs OLAP Databases

Architecture of Date Warehouse

  • Process flow In DWH
  • Components of Architecture
  • Source, Integration Layer, Staging Area, ODS.
  • Technical Architecture of Back Room
  • Architecture of Front Room
  • Infrastructure Metadata

Implementation Methodology

  • Kimball Methodology
  • Inmon Methodology

Types of Loads

  • First Time Load
  • Full Load
  • Incremental Load

Data Marts and Star Schema Design

  • Definition of Star Schema
  • Data Marts Reasons for Construction
  • Replacement of Data Mart With Warehouse
  • Design process
  • Design of Dimension and Facts
  • Snow Flake Star Schema
  • Summary Tables
  • Slowly Changing Dimensions
  • Non Additive Facts
  • Conformed Dimensions
  • Types of OLAP ROLAP, DOLAP, HOLAP, MOLAP

Fundamentals of ETL Architecture

  • Scope of ETL Determination
  • Need for ETL metadata
  • Tools Vs Manual Development
  • Selecting and Setting ETL Architecture
  • Extract Analysis
  • Target Table Refresh Strategy
  • Transformations
  • Job Scheduling

ORACLE 11g

  • Overview of Business Analysis
  • Introduction to OBIEE
  • Importance and features of the tool
  • Overview of Oracle BI Components
  • Gather information to start building Business Model
  • Architecture of OBIEE
  • Create OBDC Connections
  • Importing a data source
  • Defining Keys and Joins
  • Defining the Repository logical Structure
  • Measures
    • Building simple Fact Measures
    • Customizing the presentation Catlog
    • Testing the repository
    • Checking Consistency
    • Importing Additional Product Tables
    • Creating Multiple Sources for a logical Table source
    • Specifying the Most Economical Source
    • Creating Calculation Measures using Logical columns
    • Creating Calculation Measures using Physical columns
    • Creating Calculation Measures using Calculation Wizard
    • Creating Level Based Measures
    • Define Share Measure and Rank Measures
  • Partition
    • Types of Partitions
    • Modeling a Value Based Partition
  • Using Dynamic Repository Variables
  • Time Series functions
  • Creating Users and Groups
  • Assigning permissions to users
  • Security
    • Object Level Security
    • Data Level Security
    • Setting Query Limits
  • Cache Management
    • Introduction to Cache
    • Cache Features
    • Modifying Cache Parameters
    • Purge the Cache
  • Report developer
    • Introduction to Reports
    • Different views
    • Dashboard
    • Creating and Modifying Reports
    • Creating Dashboards
    • Dash boards pages
    • Working with dash board objects
    • Working with filters and prompts
    • Guided Navigation Links
      • Static
      • Dynamic
  • Introduction and working with ODBC Client
  • Introduction to BI Publisher
  • Introduction to DAC