How This Course Is Organised

The Oracle Business Intelligence Foundation Suite 11g Boot Camp course provides step-by-step instructions on how to perform a variety of tasks using Oracle BI Suite Enterprise Edition Plus including Oracle BIEE11g Ad-Hoc Reporting Tools, Oracle Strategy and Scorecard Management 11g, Oracle BI Publisher 11g, Hyperion EPM - Performance Management System 11 tools and applications including Essbase and SmartView for activities based on real-life work scenarios.

 

The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.    

This course provides step-by-step instructions for creating Ad-hoc queries in Oracle Business Intelligence Answers and incorporating them into Interactive Dashboards, which compose business intelligence applications.

 

You also get introduced to Oracle Strategy and Scorecard Management 11g and learn to build KPI Watch lists and basic Strategy Management Scorecards.

 

Use Oracle BI Publisher to build Pixel perfect reports as well as build BI Publisher reports based on Answers requests as well as Oracle BI subject areas.

 

Finally you get to understand the capabilities of Oracle EPM System 11 and Applications including Essbase, Planning and Financial Management. You learn to Create Oracle BI Reports using Essbase data sources, Navigate EPM System Workspace, explore Hyperion Essbase and create Ad-Hoc Analysis using SmartView.

 

Certification  

This course will assist in preparation for the Oracle BI Certification exam.

 

Duration           

N/A 

 

Audience 
Business Analysts
Functional Implementer
Technical Consultant
OBIEE Modellers

Business Intelligence Developer
EPM Application Developers

EPM Applications Project Team Leads

EPM Applications Project Managers

 
Prerequisites:
Suggested Prerequisites:
WebLearning Oracle BI 10g: Analytics Overview
 

Course Objectives:

Upon completion of this Course, you should be able to:

Understand Oracle BI Suite Enterprise Edition Plus

Understand Hyperion Performance Management Architecture

Understand and Explore OBI Administration Tools

Build queries in Oracle BI Answers
Create and modify Oracle BI Interactive Dashboards

Understand Strategy and Scorecard Management Concepts

Create KPI and KPI Watch lists
Build Oracle BI Publisher reports

Understand Hyperion Essbase

Understand and use SmartView

Understand Essbase Integration with Oracle BIEE

Use EPM Workspace

Course Outline

Overview

The Oracle Business Intelligence Value Proposition

 

Introduction to Oracle BI Enterprise Edition

The Plus Components of OBIEE 

Hyperion Financial Reporting 

Hyperion Web Analysis 

Hyperion Interactive Reporting 

Hyperion SQR Production Reporting

 

Introduction to Oracle BI Enterprise Edition Components

Oracle BI Server Processes 

Oracle BI Plug-In 

Oracle BI Publisher

MS-Office Plug-In 

Oracle BI Java Host 

Oracle BI Server 

Oracle BI Scheduler 

Oracle BI Cluster Controller

 

Oracle BI Presentation Service 

Oracle BI Answers 

Oracle BI Interactive Dashboard

Oracle BI Delivers 

Oracle BI Disconnected Analytics 

 

Understanding OBIEE Administration

Administrative Tasks

BI Repository (RPD) 

Oracle Business Intelligence Administrator 

BI Publisher Repository 

 

Navigating and Accessing Subject Areas with Answers 

Viewing Saved Requests by Dashboard 

Viewing Saved Requests in Presentation Catalog 

Searching for Saved Requests 

Printing a Dashboard or Request 

Downloading Oracle BI Requests 

Emailing Requests or Dashboards 

Setting Preferences 

 

Using Business Intelligence Answers 

Oracle BI EE11g Creating Reports and Dashboards

Creating a Query and Chart 

Creating a Query 

Creating a Filter 

Formatting the Query 

Creating Chart 

Working Pivot Tables 

Formatting Pivot Tables 

 

Using Interactive Dashboards 

Creating Interactive Dashboards 

Creating Dashboard Prompts 

Presentation Variables 

Dashboard Design Principles and Best Practices

 

Strategy and Scorecard Management

Scorecard, KPI and Watchlist Concepts

Key Performance Indicators (KPIs) Overview   

Features of KPI's

KPI Terminology

Evaluating a KPI

 

Point-of-View Bar

Exploring the Point-of-View Bar

Performance Tab

Pinning

 

KPIs and Scorecards

Opening a KPI

Creating KPI's

Defining General Properties

Defining Dimensionality

Defining Thresholds

Defining Related Documents

Defining Custom Attributes

Saving the KPI

Editing a KPI

Exploring KPI Analysis

 

Using Oracle BI Publisher 

Creating BI Publisher Reports

Understanding Template Builder Menus 

Creating a BI Publisher Report from Answers Request 

Creating a BI Publisher Report from BI Server 

Creating RTF Templates

 

Enterprise Performance Management Tools and Applications

Shared Services

EPM Workspace

EPM Architect

Calculation Manager

SmartView

SmartSpace

 

Essbase and Essbase Studio

Essbase Overview

Deployment Architecture

Optimised Multi-dimensional Storage

Cache-Architecture

High-Availability Options

Business Model Development

Multi-Dimensional Calculation Engine

Essbase Application Administration

Essbase Studio       

Essbase Administration Services (EAS)

Oracle Essbase Analytics Link for Oracle HFM

Oracle Essbase Analytics Link Architecture

Benefits of Essbase Analytics Link

Oracle BI Server and Essbase Integration

Exploring Essbase from EPM Workspace

 

Introducing EPM Workspace           `

EPM Workspace User Interface    

Accessing EPM Workspace

Navigating Workspace 

Launching Workspace 

Reviewing the Workspace User Interface 

Setting General and Explore Preferences 

Adding Favourites 

Opening Applications

 

Working with EPM Workspace

Creating Workspace Portal Pages 

Adding Repository Content

 

Ad-Hoc Analysis with Smart View

Introduction to Smart View and Architecture

Architecture

Provider Services

Data Source Manager

Platform support

 

Usage Scenarios

Ad Hoc Analysis

Predefined Form Interaction

Pre-created Content Access

 

Reporting

Smart Slice

Data Integration & Reporting

Combined Data Display

Report Controls

Cascade

 

Accessing the Smart View Toolbar 

Connecting to Data Sources 

Retrieving Planning Data in Smart View

 

Entering Data in Smart View          

Entering Data in Smart View          

Connecting to Data Sources          

Selecting Data Forms         

Navigating Data Forms in Smart View      

Entering Data in Data Forms         

Applying Formulas to Data Forms 

Calculating Data      

Saving and Refreshing Data in Smart View         

 

Creating Ad Hoc Grids        

Pivoting Dimensions           

Zooming In and Out on Members   

Keeping and Removing Members 

Selecting POV Members    

Accessing Smart Slices

     

NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY TRAINING GUIDE, E-LEARNING OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR TRAINING GUIDE LEARNING  FORMATS 

What is a CBT?

CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBTTitles do NOT have voice.

Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

NOTE:WebLearning Publishing CBT and Courseware products are now delivered with FULL LICENCE KEY.

The WebLearning unique Methodology

All WebLearning® CBT and Courseware courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: ANEW, very effective and proven way of learning. 

FACT:

• ·        Material retention with CBT’S are 45% better than with conventional training methods
• ·        Your learning curve with CBT is 25%-55% less than conventional methods
• ·        The cost of CBT training is over 65% less than Classroom training
• ·        CBT’S are self pacing, interactive and simulate the actual software being studied