PHONE +91 9620196773, +91 8884684156
EMAIL info@iqstreamtech.com
Call for Free Demo +91 9620196773, +91 8884684156, 080-42073645


OBIEE Training Institute

DATAWAREHOUSING CONCEPTS

• Introduction and Definition
• Sources, Transformations and Targets( Architecture )
• Data Extraction, Data Transformations and Data Loading( Data Acquisition Process)
• Data Warehousing Approaches
• Staging Area, Metadata, Repository and Data Mart
• Differences between OLTP and OLAP( DSS ) Systems
• Operational Data Store( ODS )
• Business Intelligence
• Star Schema Design & Confirmed Dimension, Fact less Fact Table, Types of Facts
• Slowly Changing Dimensions( SCD )

OBIEE Installation & Configuration

• Installation of Database
• Installation of OBIEE Meta Data using Repository Creation Utility.
• Installation and Configuration of OBIEE.
• Testing of Sample Reports and RPD.
• Configuration of BI Sample schemas.

Introduction to Oracle Business Intelligence

• What is BI ?
• What are the other BI tools ?
• What is OBIEE ?
• History of OBIEE ?
• What you are going to learn in OBIEE ?
• Introduction on OBIEE Repository Design & Development
• Introduction on OBIEE Answers and Dashboards

OBI ARCHITECTURE

• Clients
• OBI Presentation Services
• OBI Server
• OBI Repository (.rpd)

OBI COMPONENTS

• OBI Administration Tool
• OBI Answers
• Intelligence dashboards

Part 1 OBIEE Repository Design & Development

REPOSITORY BASICS

• Sample Request Processing
• Using the OracleBI Administration Tool
• Repository Directory
• Repository Files ( Initialization files and log files)
• Creating a repository
• Connection Pool
• Repository Modes ( ONLINE and OFFLINE )
• Physical Layer
• Business Model & Mapping Layer
• Presentation Layer
• Presentation Catalogs, Folders and Columns

BUILDING THE PHYSICAL LAYER OF A REPOSITORY

• Defining an ODBC System DSN
• Setting up connection pool properties
• Importing data sources ( Physical Schema )
• Verifying the import
• Defining physical keys and joins
• Creating alias and select tables

BUILDING THE BUSINESS MODEL AND MAPPING LAYER OF A REPOSITORY

• Creating the logical business model
• Creating the logical tables, columns, and sources
• Defining logical joins
• Adding Calculation to a Fact Table
• Building measures

BUILDING THE PRESENTATION LAYER OF A REPOSITORY

• Creating a new Presentation Catalog
• Modifying Presentation layer objects
• Rename tables
• Reorder Table

TESTING AND VALIDATING A REPOSITORY

• Checking repository consistency
• Defining a repository in the initialization file
• Testing a repository using Oracle BI Answers
• Message Severity
• viewing Server Logs

ADDING MULTIPLE LOGICAL TABLE SOURCES

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

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

CREATING DIMENSION HIERARCHIES AND LEVEL-BASED MEASURES

• Creating dimension hierarchies
• Creating level-based measures

USING VARIABLES & INITIALIZATION BLOCKS

• Understanding different types of Variables.
• Creating Repository Variables and session variables and using them in the OBIEE environment
• Creating and setting Presentation variables in obiee reports and dashboards.

CREATING TIME SERIES MEASURES

• Using time comparison in business analysis.
• Using Oracle BI time series functions to model time series data

Security in OBIEE

• Oracle Platform Security Service
• Exploring Oracle BI default security settings
• Creating users and groups

Part-2 OBIEE Answers & DashBoards(REPORTS DEVELOPMENT)

Working with Oracle Business Intelligence Answers

• Introduction to Oracle BI Answers
• Working with requests in Oracle BI Answers
• Using advanced formatting
• Creating report Level Hierarchy

Filtering Requests in Oracle Business Intelligence Answers

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

Building Views and Charts in Requests

• Introduction to Answers views and charts
• Creating and editing charts
• Performing common view tasks
• Creating a column Selector
• Creating View Selector

Showing Results with Pivot Tables

• Introduction to pivot tables
• Formatting pivot tables
• Setting aggregation rules and building formulas

Creating Oracle Business Intelligence Interactive Dashboards

• Introduction to Interactive Dashboards and pages
• Adding Objects to Dashboard
• Creating Dashboard prompts
• Embedding content in an Interactive Dashboard
• Usage of presentation variables

OBIEE Advanced Concepts : Master-Detail linking ,KPI's etc

OBIEE Environment in different software companies

• Explain the Real time OBIEE Environment in the software Companies
• Explain the different support groups which are part of OBIEE project
• The way OBIEE project is developed
• Roles and Responsibilities of the Developer,Lead, Testers,etc
• OBIEE Requirement Analysis
• OBIEE Design and Development
• OBIEE testing dev and uAT
• OBIEE Migration
• OBIEE Infant Care