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 11g 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 11g 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 Initialization Blocks Repository Variables

Creating Dynamic Repository Variables

Creating Time Series Measures

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

Security in OBIEE 11g

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

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 Narrative View
• 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

Delivers

• Introduction to Oracle BI Delivers
• Developing IBOTS
• Configuring delivery devices

Publisher

• Introduction to Oracle BI Publisher
• Creation of reports using BI Publisher.

OBIEE 11g Advanced Concepts

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

OBIEE 11g&12c along with OBIA and ELT, ETL, Data warehousing Implementation Approaches.

• 12+ Years of Real-time BI architect Experience in IT Industry
• Worked on OBIA certified professional with various Great MNC’s
• Real-time project oriented training with step-by-step Scenarios.
• Technical and functional and migrations and security design Documentation approaches
• Covering the Pre-requisites for learning OBIEE 11g&12c
• Completed 250+ coaching Assignment around 800 students

The OBIEE training contains all real time industry standards with ERP and multiple domains.

• OBIEE Real Time Project Support and Documentation:- OBIEE Real-time project support related design and migration and function setup documentation also teach under training
• Interview Skills based on OBIEE:- Mark interview conducted on every week and provide more than 500+ interview questions by end of course
• OBIEE Certification Support:-Providing OBIEE certified training, 50+ learner certified through JSE SoftTech in OBIEE technology.
• OBIEE Resume Preparation: - Based on learner experience we helps him to show his confidence through resume. We will help you to prepare to shortlist resumes.
• Small Training Batch:-One to one session will arrange by JSE SoftTech for learner comfortability.
• OBIEE Practical Guidance:- Everyday tasks and practical exercises as homework