Oracle Business Intelligence Enterprise Edition (OBIEE):

Oracle Business Intelligence Enterprise Edition (Oracle BI EE) is a comprehensive set of enterprise business intelligence tools and infrastructure, including a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards, proactive intelligence and alerts, real-time predictive intelligence, and an enterprise reporting engine. Oracle Business Intelligence is designed to bring greater business visibility and insight to a wide variety of users.

Oracle BI Enterprise Edition (sometimes simply referred to as Oracle Business Intelligence) provides a full range of business intelligence capabilities that allow you to:

  • Collect up-to-date data from your organization
  • Present the data in easy-to-understand formats (such as tables and graphs)
  • Deliver data in a timely fashion to the employees in your organization

These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.

OBIEE course outline:

DATAWAREHOUSING CONCEPTS

dwh

  • 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 OracleBI Administration Tool
  • Repository Directory
  • Repository Files ( Initialization files and log files)
  • Informatica Server ETLLoading 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 & Users

ANSWERS (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