OBIEE Training in Hyderabad

OBIEE Training

OBIEE online training:

Oracle Business Intelligence Foundation Suite (OBIEE + and Essbase) is a complete, open system, and architecturally unified business intelligence for the company that provides capabilities for reporting, query and ad hoc analysis, online analytical processing (OLAP), boxes command and control panels. All enterprise data sources and metrics, calculations, definitions and hierarchies are managed in a Common Information Model Enterprise, providing users with accurate and consistent view, regardless of where the information is consumed

 

OBIEE

CONCEPTS Data warehousing

  • Introduction and Definition
  • Sources, Transformations and goals (Architecture)
  • Data extraction, data transformation and loading data (Process Data Acquisition)
  • Data Storage Approaches
  • Area organization, metadata repository and Data Mart
  • Differences between OLTP and OLAP systems (DSS)
  • Operational Data Store (ODS)
  • Business Intelligence
  • Schematic Design Star and confirmed Dimensions, table less informative facts, Data Types
  • Slowly changing dimensions (SCD)

OBI Overview

OBI NEWS

OBI ARCHITECTURE

  • Customers
  • OBI Presentation Services
  • Server OBI
  • Repository OBI (.rpd)
  • Data Sources

OBI COMPONENTS

  • OBI Management Tool
  • Responses OBI
  • Intelligence panels

 

FUNDAMENTALS Repository

  • Business Analysis Oracle Warehouse
  • DAC and Informatica server
  • Informatica ETL server
  • Request Sample Processing
  • Using the management tool OracleBI
  • Directory repository
  • Repository (initialization files and log files) Files
  • Informatica ETL Server Load a memory repository Oracle BI Server
  • Creating a repository
  • Connection pool
  • Modes repositories (online and offline)
  • Physical Layer
  • Business model and mapping layer
  • Presentation Layer
  • Presentation catalogs, folders and columns
  • Error Messages

CONSTRUCTION OF PHYSICAL LAYER OF DEPOSIT

  • Defining an ODBC System DSN
  • Configuring connection pool properties
  • Importing data sources (physical schema)
  • Import Verification
  • Definition of physical keys and joins
  • Creating aliases and select tables

BUSINESS MODEL CONSTRUCTION AND layer assignment of a deposit

  • Creation of business logic model
  • Creation of logical tables, columns and fountains
  • Definition of logical connections
  • Adding calculation to a fact table
  • Building Data

CONSTRUCTION OF PRESENTATION LAYER OF DEPOSIT

  • Creating a new catalog Presentation
  • Modifying objects of the presentation layer
  • Rename tables
  • Table Reorder

Testing and validation of a REPOSITORY

  • Checking the consistency of the repository
  • Definition of a repository in the initialization file
  • Testing a repository using Oracle BI Answers
  • Message Severity
  • vision server logs

CONSTRUCTION OF PHYSICAL LAYER OF DEPOSIT

  • Defining an ODBC System DSN
  • Configuring connection pool properties
  • Importing data sources (physical schema)
  • Import Verification
  • Definition of physical keys and joins
  • Creating aliases and select tables

BUSINESS MODEL CONSTRUCTION AND layer assignment of a deposit

  • Creation of business logic model
  • Creation of logical tables, columns and fountains

It joins • Definition of logic

  • Adding calculation to a fact table
  • Building Data

CONSTRUCTION OF PRESENTATION LAYER OF DEPOSIT

  • Creating a new catalog Presentation
  • Modifying objects of the presentation layer
  • Rename tables
  • Table Reorder

Testing and validation of a REPOSITORY

  • Checking the consistency of the repository
  • Definition of a repository in the initialization file
  • Adding multiple logical table sources
  • Adding multiple sources of logic table to a logical table
  • Specifying logical content

Adding logical table sources MULTIPLE

  • Adding multiple sources of logic table to a logical table
  • Specifying logical content

Add calculations with a 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 measures BASED level

  • Creating dimension hierarchies
  • Creation of measures based on the level

CREATING AND USING ADDED

  • Purpose tables dimensional modeling aggregation
  • Modeling aggregate tables to improve query performance
  • Scan Test aggregation

Use Initialization Variables repository Blocks

Creating dynamic variables tank

Execute requests direct database

  • Access to the database directly

BUILDING MEASURES TIME SERIES

  • Using comparisons over time on business analysis
  • Using the features of Oracle BI time series modeling time series data

CREATING dimension hierarchies and measures BASED level

  • Creating dimension hierarchies
  • Creation of measures based on the level

Providing security for Groups and UsersANSWERS (Reports)

Working with Oracle Business Intelligence Answers

  • Introduction to Oracle BI Answers
  • Working with Oracle BI Answers requests
  • Using Advanced Format
  • Creating report hierarchy level

Filtering requests in Oracle Business Intelligence Answers

  • Introduction to filters in Answers
  • Adding filter requests to applications
  • Using saved requests as filters

Building Views and graphics APPLICATIONS

  • Introduction to tables and views Answers
  • Creating and editing graphics
  • Performing tasks common views
  • Creating a Narrative view
  • Creating a column selector

Results: Pivot tables

  • Introduction to PivotTables
  • PivotTables format
  • Adjust the aggregation rules and formulas building

Create panels Oracle Business Intelligence Interactive

  • Introduction to dashboards and interactive pages
  • Adding objects to dashboard
  • Creating dashboard messages
  • Incorporation of content in a interactive dashboard

For more details please call 9885743409, / 9966569433 or mail to leave a sudhakar.k@digitaltechnologies.com

Leave a Reply

Your email address will not be published. Required fields are marked *