OBIEE

We are providing Exclusive Training on OBIEE by Faculty from top MNC’s with highly skilled domain expertise will train & guide you with real time applications and case studies. We also help you in resume preparation and provide job assistance till you get job.

Key features OFFERED:

  
OBIEE 11G

  Case studies

  Exercises

  Sample applications

  Resume preparation and more

Our training features:

  You will receive top quality instruction that we are famous for online trainings.

  Training from professional experts with Real time project scenarios and  real-time examples

  Excellent course material will be provided

  State-of-the-art lab with required software for practicing

  Resume preparation and job assistance

COURSE TOPICS:

OBIEE 11g Online Training Course Content

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 )

OBI Overview NEW FEATURES OF OBI OBI ARCHITECTURE Clients OBI Presentation Services OBI Server OBI Repository (.rpd) Data Sources

OBI COMPONENTS OBI Administration Tool OBI Answers Intelligence dashboards

REPOSITORY BASICS Oracle Business Analysis Warehouse DAC and Informatica Server Informatica Server ETL Sample Request Processing Using the Oracle BI Administration Tool Repository Directory Repository Files ( Initialization files and log files) Informatica Server ETL Loading a repository into Oracle BI Server memory Creating a repository Connection Pool Repository Modes ( ONLINE and OFFLINE ) Physical Layer Business Model & Mapping Layer Presentation Layer Presentation Catalogs, Folders and Columns Error Messages

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 iewing Server Logs

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 Adding Multiple Logical Table Sources Adding multiple logical table sources to a logical table Specifying logical content

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

CREATING & USING AGGREGATES Purpose of aggregate tables in dimensional modeling Modeling aggregate tables to improve query performance  Testing aggregate navigation

Using Initialization Blocks Repository Variables CREATING DYNAMIC REPOSITORY VARIABLES EXECUTE DIRECT DATABASE REQUESTS Accessing database directly

CREATING TIME SERIES MEASURES Using time comparisons in business analysis Using Oracle BI time series functions to model time series data

CREATING DIMENSION HIERARCHIES AND LEVEL-BASED MEASURES Creating dimension hierarchies Creating level-based measures

Providing Security for Groups & UsersANSWERS (REPORTS) 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

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