- What is Oracle OBIEE?
- Makes corporate data easier for business users to access
- Provides a common infrastructure for producing and delivering enterprise reports, scorecards, dashboards, ad-hoc analysis, and OLAP analysis
- Includes rich visualization, interactive dashboards, a vast range of animated charting options, OLAP-style interactions and innovative search, and actionable collaboration capabilities to increase user adoption
- Reduces cost with a proven Web-based service oriented architecture that integrates with existing IT infrastructure
This course aims to teach students how to use the Oracle Business Intelligence Enterprise Edition 11g and also teach students the different aspects of business intelligence.
- Who should take this course?
- Oracle professionals with basic experience with Oracle (not required)
- Business Managers
- IT managers
- Data analysts
- System analysts
- End-user liaisons
- Hours and Instructor:
Call for more details
- Course Content
Part I Oracle Business Intelligence Defined.
Chapter 1 Oracle Business Intelligence.
Business Intelligence and Transactional Applications.
Daily Business Intelligence.
Enterprise Planning and Budgeting.
Oracle Integration Components Enabling Business Intelligence.
Business Activity Monitoring.
BPEL Process Manager.
Enterprise Messaging Service.
Custom Data Warehouse Solutions.
The Role of the Oracle Database.
Oracle Warehouse Builder.
Oracle Business Intelligence Standard Edition.
Oracle Business Intelligence Enterprise Edition.
BI (XML) Publisher.
Building Custom Business Intelligence Applications.
Chapter 2 Oracle’s Transactional Business Intelligence.
Transactional Business Intelligence.
Oracle’s Daily Business Intelligence.
How DBI Works.
Varieties of DBI.
Oracle Balanced Scorecard Structure.
Creating an Oracle Balanced Scorecard.
The Oracle Customer Data Hub.
How Data Hubs Work.
Other Oracle Data Hubs.
Is Transactional Business Intelligence Enough?
Chapter 3 Introduction to Oracle Data Warehousing.
Oracle Data Warehousing Basics.
Oracle Database Analysis and Schema Considerations.
Managing an Oracle-based Data Warehouse.
Where to Start?
Oracle/Siebel Business Analytics Applications.
Choosing Completely Custom.
Chapter 4 Choosing a Platform.
Scaling Up Platforms Versus Scaling Out.
Sizing the Platform.
Information Needed for Warehouse Hardware Sizing.
Sizing Hardware for Business Intelligence Tools.
Part II Custom-Built Data Warehousing Solutions.
Chapter 5 Designing for Usability.
Approaches for Design.
Key Design Considerations.
Features for Design — Enhancing Performance.
Online Analytical Processing Design.
Selecting the Best Approach.
Chapter 6 Business Intelligence Tools.
Oracle Portal and Portal Products.
Using Oracle Portal.
Building and Deploying Oracle Portal and Portlets.
Oracle BI Reporting Workbench (Actuate).
Ad hoc Query and Analysis.
Business Intelligence Enterprise Edition.
Discoverer and Business Intelligence Standard Edition.
Oracle Spreadsheet Add-ins.
Building Business Intelligence Applications.
JDeveloper and BI Beans.
Chapter 7 Data Loading.
Oracle Database Data Loading Features.
Embedded ETL in the Oracle Database.
Change Data Capture.
Oracle Warehouse Builder.
Typical Steps when using OWB.
ETL Design in OWB.
OWB and Dimensional Models.
The OWB Process Editor.
Balancing Data Loading Choices.
Chapter 8 Managing the Oracle Data Warehouse.
Oracle Enterprise Manager Grid Control.
Database Performance Monitoring.
Management and Management Options.
Chapter 9 Data Warehouse Performance Tuning and Monitoring.
Understanding Performance Challenges.
Who Is Responsible?
Causes of Poor Performance.
Successful Approaches to Performance Tuning.
Critical Tasks for Performance Tuning Lifecycle.
Database Application Design.
Business Scenario: Tuning Our Sample Solution.
Where To Start.
Enterprise Manager Advisory Framework.
Approaches for Success.
Part III Best Practices.
Chapter 10 Scoping the Effort and an Approach for Success.
Uncovering Key Business Initiatives.
Where to Start.
What is Important.
Accountability and Securing Business Sponsorship.
Establish a Steering Committee.
Project Review Board.
Endorsing a Methodology.
Choices of Methodologies.
A Business-focused Approach.
Staffing the Project.
Engaging the Business: Education and Training.
Communication — Managing Expectations.
No Place to Shortcut.
Chapter 11 Understanding Business Needs.
How Bad Deployment Choices Impact the Business.
Independent Data Marts.
Limited and Inflexible Reporting.
Sources of Information Limited to Internal Data.
Limited Data History.
Lack of Current High-Quality Data.
Limited Growth Flexibility.
Project Drivers and Business Types.
Media and Entertainment.
Other Business Types: Transportation and Utilities.
Developing Scope and Gaining Business Support.
Chapter 12 Justifying Projects and Claiming Success.
Concept to Project.
Where to Start Justification.
Common Metrics to Measure.
Common Budgeting Techniques.
Total Cost of Ownership.
Modeling Total Cost of Ownership.
Return on Investment.
Modeling Return on Investment.