Oracle Business Intelligence Training

Oracle Business Intelligence Online Training

Introduction to Oracle Business Intelligence

  • Daily Business Intelligence
  • Business Intelligence Balanced Scorecard
  • Enterprise Planning and Budgeting
  • Activity-Based Management for Business Intelligence
  • Oracle Integration Components Enabling Business Intelligence
  • Business Intelligence Data Hubs
  • Business Activity Monitoring
  • BPEL Process Manager
  • Enterprise Messaging Service
  • Custom Data Warehouse Solutions
  • The Role of the Oracle Database in Business Intelligence
  • Oracle Warehouse Builder
  • Oracle Business Intelligence Standard Edition
  • Oracle Business Intelligence Enterprise Edition
  • Business Intelligence (XML) Publisher
  • Oracle Portal
  • Spreadsheet Add-ins
  • Building Custom Business Intelligence Applications
  • Emerging Trends in Business Intelligence

Oracle’s Transactional Business Intelligence

  • Transactional Business Intelligence
  • Oracle’s Daily Business Intelligence
  • How Business Intelligence Works
  • Varieties of Business Intelligence
  • Business Intelligence Balanced Scorecards
  • Oracle Balanced Scorecard Structure
  • OBSC Architecture
  • Creating an Oracle Balanced Scorecard
  • Business Intelligence Data Hubs
  • The Oracle Customer Data Hub
  • Internals of Oracle Data Hubs
  • Other Oracle Data Hubs
  • Transactional vs. Strategic Business Intelligence

Introduction to Oracle Data Warehousing

  • Oracle Data Warehousing Basics
  • Oracle Database Analysis
  • Business Intelligence Schema Considerations
  • Managing an Oracle-based Data Warehouse
  • Oracle/PeopleSoft EPM
  • Oracle/Siebel Business Analytics Applications
  • Build or Buy?  Choosing a Custom Business Intelligence solution

Business Intelligence Project Planning

  • Uncovering Key Business information Initiatives
  • Information Sources for Business Intelligence
  • What is Important in Business Intelligence?
  • Business Intelligence Accountability
  • Securing Business Sponsorship
  • Establish a Steering Committee
  • The Business Intelligence Project Review Board
  • Endorsing a Methodology
  • Choosing a of Business Intelligence Methodology
  • Staffing the Business Intelligence Project
  • Business Intelligence Organization Structure
  • Maximizing the End-User Experience
  • Engaging the Business: Education and Training
  • Managing Risk
  • Managing Business Intelligence Expectations
  • Business Intelligence Contingency Allocation
  • Financial and Technology Risk Assessment
  • Business Intelligence Feasibility Analysis

Understanding Business Intelligence Needs

  • Avoiding Bad Deployment Choices
  • Creating Independent Data Marts
  • Building for Flexible Reporting
  • Identifying Business Intelligence Sources of Information
  • Limiting and scrubbing Internal Data
  • Ensuring Current High-Quality Data
  • Planning for Business Intelligence Growth & Flexibility
  • Project Drivers and Business Types
  • Business Intelligence in Financial Companies
  • Business Intelligence in Healthcare
  • Business Intelligence in Manufacturing
  • Business Intelligence in Media and Entertainment
  • Business Intelligence in Retail
  • Telecommunications
  • Other Business Types: Transportation and Utilities
  • Business Intelligence in Educational Institutions
  • Government Agencies
  • Developing Scope and Gaining Business Support

Justifying  Business Intelligence  Projects – cost/benefit analysis

  • Business Intelligence conceptual planning
  • Evaluating Business Constraints
  • Where to Start Justification
  • Measuring Value in Business Intelligence
  • Common Metrics to Measure
  • Common Budgeting Techniques
  • Total Cost of Ownership
  • Modeling Total Cost of Ownership
  • Return on Investment
  • Modeling Return on Investment
  • Claiming Success

Choosing a Platform for Oracle Business Intelligence

  • Scaling Up Platforms Versus Scaling Out
  • Hardware Platforms for Business Intelligence
  • Cost and Availability Considerations
  • Business Intelligence Manageability Considerations
  • Sizing the Business Intelligence Hardware Platform
  • Information Needed for Warehouse Hardware Sizing
  • Benchmarking a Business Intelligence system
  • Sizing Hardware for Business Intelligence Tools

Designing Oracle Business Intelligence for Maximum Usability

  • Approaches for Business Intelligence Design
  • Key Business Intelligence Design Considerations
  • Features for Design — Enhancing Performance
  • Business Scenario
  • Normalized Database Design for Business Intelligence
  • Multi-Dimensional Database Design
  • Online Analytical Processing (OLAP) Design
  • Selecting the Best Design Approach for your Business Intelligence Project

Oracle Business Intelligence Tools

  • Oracle Portal and Portal Products
  • Using Oracle Portal
  • Building and Deploying Oracle Portal and Portlets
  • Business Intelligence and XML Publisher
  • Oracle Reports and Business Intelligence
  • Oracle  Business Intelligence  Reporting Workbench (Actuate)
  • Ad hoc Query and Analysis for Business Intelligence
  • Discoverer and Business Intelligence Standard Edition
  • Building Business Intelligence Applications
  • JDeveloper and  Business Intelligence  Beans
  • Using Oracle Data Miner (ODM)

Oracle Data Loading and ETL

  • Oracle Database Data Loading Features
  • Embedded ETL in the Oracle Database
  • SQL*Loader
  • Change Data Capture (CDC)
  • Transportable Tablespaces
  • Data Pump
  • Oracle Warehouse Builder and Business Intelligence
  • OWB Packaging
  • Typical Steps when using OWB
  • ETL Design in OWB
  • OWB and Dimensional Models
  • The OWB Process Editor
  • Balancing Data Loading Choices

Managing the Oracle Data Warehouse

  • Oracle Enterprise Manager Grid Control
  • Database Performance Monitoring
  • Database Administration
  • Database Maintenance
  • Database Topology
  • Management and Management Options

Business Intelligence Performance Tuning

  • Understanding Performance Challenges in Business Intelligence Applications
  • Causes of Poor Business Intelligence Performance
  • Successful Approaches to Performance Tuning
  • Critical Tasks for Performance Tuning Lifecycle
  • Hardware Configuration for Business Intelligence
  • Software Configuration for Business Intelligence
  • Database Application Design
  • Business Scenario: Tuning Our Sample Solution
  • Oracle Enterprise Manager Advisory Framework

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message