OBIEE 11g for End Users

Workshop Description
Oracle Business Intelligence Enterprise Edition (OBIEE) is the solution that finally realizes the potential that business intelligence has promised for over a decade.

Traditionally, companies have measured BI projects in terms of months, or even years, but you deploy OBIEE in a matter of weeks. This workshop teaches you the skills you need to become an independent OBIEE user. This means that when you've completed the course, you'll be able to use OBIEE to get the data you need to make the difficult decisions necessary in a tough economy.

You'll learn how to use OBIEE to create, modify and distribute your own reports, charts, dashboards, and graphs. This course provides step-by-step instructions for creating ad-hoc queries in Oracle Business Intelligence Analysis and incorporating them into Interactive Dashboards. Students also learn to build an Oracle BI Interactive Dashboard, requests created in Analysis, pivot tables, charts, gauges, prompts, embedded content, navigation links, and Oracle BI Publisher reports. The course also profiles Alerts (iBots) and provides an introduction to BI Publisher. Finally, you see how to incorporate content from BI Analysis into Excel spreadsheets.

Listen now to our podcast "Understanding the difference between OBIEE for End Users and Administrators" (11:27 min).

Workshop Overview
By the end of the course you will have:
  • Gained familiarity with OBIEE's components
  • Developed your own reports in BI Analysis
  • Created your own Dashboards in OBIEE
  • Customized OBIEE's charts and graphs
  • Used BI Scheduler and created alerts using iBots
Prerequisite knowledge and skills:
  • You need NO prior knowledge of OBIEE or BI solutions to take this workshop
Recommended audience:
  • Users of Oracle Business Intelligence tools
  • Finance team members who need to craft their own reports

Workshop Agenda
  DAY 1  

Oracle BI EE Introduction, Architecture
  • An Overview of OBIEE
    • Source
    • Informatica
    • DAC
    • Application layer
    • Presentation layer
  • OBIEE architecture, technology stack components, overview
  • Analytics
  • Administration (levels of abstraction)
    • Physical layer
    • Business Model and Mapping layer
    • Presentation layer
  • Datawarehouse Concepts, Overview
    • Dimensions
    • Facts
    • Measures
  • BI Server design: cache, security, high availability options, steps
  • Installation and Configuration, Options and Steps

Oracle BI EE Analysis and Dashboards – Getting Started
  • Introduction to BI Analysis and Subject Areas
  • Developing initial BI Analysis reports and filtering within BI Answers
  • Working with Views of data in Analysis
  • Complex BI Analysis calculations
  • Variables and advanced techniques
  • Dashboard Fundamentals
  • Dashboard Creation and Modification
  • Dashboarding and Navigation
  • Layout Concepts and Best Practices
  • Subject Areas
  • Navigation links
  • Prompts
  • View Types
  • Column Selectors
  • Drilling into report dimensions
  • Filtering requests
  • Formatting results
  • Compound Layout / Views
  • Pivot Tables
  • Analytical Formulas
  • Rank, Lead, Lag, TopN, Rolling
  • Adding Text, Folders, Guided Navigation Links
  • Briefing Book Navigation Links
  • Controlling Drill Down Display
  • Creating and modifying requests
  • Funnels
  • Gauges
  • Charts
  • Bubble Chart
  • Time series Chart
  • Executing Direct Database Requests
  • Folder / Tab Best Practices
  • Catalog
  • Global Filters
  • View Selectors
  • Column Selectors
  • Legends
  • Narrative
  • Ticker
  • Creating an Interactive Dashboard

Labs, Analysis and Dashboards - Getting Started
  • Creating and configuring reports
  • Developing and configuring graphs
  • Creating and configuring Pivot Table reports
  • Adding content to Dashboards

  DAY 2  

Oracle BI EE Analysis and Dashboards - Advanced Topics
  • Dashboard prompts
  • Presentation variables
  • Direct database requests
  • Guided navigation links
  • Dashboard Overview
  • Creating Dashboards and Pages
  • Modifying Page structures
  • Adding BI Answers, BI Publisher, and other content to Dashboard Pages
  • Using "drop-down" filters in Dashboard Pages
  • Using session and user variables in Dashboard Pages
  • Developing links and navigations within Dashboards
  • Advanced Dashboard Techniques
  • Working with Disconnected Analytics
  • Creating Briefing Books, snapshots of dashboard pages
  • Downloading BI Publisher Reports for offline viewing
  • Mobile analytics

Labs, Analysis and Dashboards - Advanced Topics
  • Creating and configuring dashboard prompts
  • Adding Filters to dashboards
  • Customizing graphing components
  • Using direct database requests
  • Using guided navigation

Oracle BI EE Delivers - Sending Alerts using iBots
  • Creating conditional iBot
  • Creating unconditional iBot
  • Understanding BI scheduler

Labs -Sending Alerts Using iBots
  • Creating a conditional iBot
  • Creating an unconditional iBot
  • Configuring delivery options for iBots

Oracle BI EE Office Add-In
  • Installing the Office Add-In
  • Configuring the Office Add-In in Excel
  • Using BI catalog to create Excel reports and PowerPoint slides

Labs - OBIEE Office Add-Ins
  • Installing Office Add-in
  • Configuring connection to BI Server presentation layer
  • Working with different report and graphing formats in Excel
  • Connecting Excel reports to PowerPoint
  • Working with static and refreshable reports

Building Oracle BI Publisher reports based on BI Answers requests and BI metadata subject areas via integrated WYSIWYG Editor and Word
  • Bursting
  • Delivery
  • Scheduling
  • Multiple data sources
  • Pivot Table builder
  • Integrating Oracle BI Publisher reports in Interactive Dashboards

Labs, Building Oracle BI Publisher reports based on BI Answers requests and BI metadata subject areas
  • Creating a BI Publisher Report with graphs, column totals
  • Formatting and labeling information

The sessions are being held from 9 am to 5 pm.

Workshop Registration

This workshop is currently being offered on demand. Please contact us at 1-800-675-0032 if you wish to receive more information.

Cost

$750

For Oracle User Groups members

$1,000

For non-members
Members of Oracle User Groups get a 25% discount!

Location/s

Instructor/s

Related Workshops

Continue checking other workshops