Oracle Business Intelligence Training Course

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring

* Ensure the success of your Oracle Business Intelligence project by learning from an experienced Oracle Business Intelligence expert.

* Get a pragmatic learning experience in Oracle Business Intelligence

* See industry best practices for choosing a  Business Intelligence  platform and supplemental  Business Intelligence  tools.

* Understand the evolution of  Business Intelligence  needs, from tactical data to hypothesis testing and forecasting.

* See how to use Oracle Business Intelligence for advanced linear regression, predictive modeling and trend analysis.

* Learn proven methods for ETL and data cleansing.

* See how to collect and analyze terabytes of operational data.

* See how to create executive dashboards for strategic data analysis.

* See how to build Oracle  Business Intelligence  Interactive Dashboards for executive management.

* Understand the secrets for hypercharging your Oracle Business Intelligence queries.

* See how to leverage the Oracle  Business Intelligence  Server.

* Learn to use Oracle  Business Intelligence  Answers for sophisticated trend analysis.

Oracle  Business Intelligence  Suite Enterprise Edition Training Course is an intense  training course that is designed to give the student maximum exposure to Oracle  Business Intelligence  Suite components.

Low on theory and long on real-world applications, this Oracle Business Intelligence training class is taught by an experienced Oracle Business Intelligence DBA who teaches Oracle Business Intelligence secrets and tips.

Every Oracle  Business Intelligence  shop has different requirements, and Oracle Business Intelligence training course can also be customized according to your specific needs along with follow-up supplemental mentoring to guarantee your success in your  Business Intelligence  deployment.

BC is proud to be the All-American team with pragmatic training from expert instructors.

		Oracle Data Warehousing and Business Intelligence Solutions  John Wiley & Sons ISBN = 0471919217

This Oracle  Business Intelligence  Suite Enterprise Edition course is designed for practicing Oracle professionals who have basic experience with Oracle.

Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.

This course is intended for anyone involved in the Oracle Business Intelligence project, including IT managers, data analysts, developers, systems analysts and end-user liaisons.

Introduction to Oracle Business Intelligence

• Business Intelligence and Transactional Applications
• 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

• 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

• 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

• 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 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 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

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

• 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
• Oracle Business Intelligence Best Practices