Oracle - Course Details

OraDOLAPE11g Oracle Database 11g: OLAP Essentials

Oracle Course Description:
In this course, students learn to progressively build an OLAP data model to support a wide range of business intelligence requirements. Students learn to design OLAP cubes to serve as a summary management resource for existing SQL table queries. Students also learn to leverage the power of Oracle OLAP by adding rich analytic content to your data model.
Oracle Course Duration:
3 Days Training
Oracle Course Target Audience:
Business Analysts,Business Intelligence Developer,Data Warehouse Administrator,Data Warehouse Analyst,Data Warehouse Developer,Database Administrators
Oracle Course Prerequisite:
Basic SQL knowledge,A basic understanding of OLAP concepts
Course Content:
Examining the Role of Oracle OLAP within the Oracle BI / DW Platform
  • Oracle OLAP and the Oracle BI / DW Platform
  • Features of the Oracle OLAP Option
  • Accessing Oracle 11g OLAP data
Understanding the Dimensional Model
  • Stored and Calculated Measures
  • Dimensions
  • Hierarchies
  • Levels
  • Attributes
Building OLAP Cubes
  • Using the Cube Building Tool
  • Creating Dimensions
  • Designing Cubes
  • Creating Measures
  • Mapping to Source Data
  • Loading Data
Examining Cube-Organized Materialized Views (Cube MVs)
  • Benefits of Cube MV Summary Management
  • General Requirements for rewrite to MVs
  • Designing Cube MVs
  • Using Cube MVs
Creating Calculated Measures
  • Examining OLAP Calculation Types
  • Using the Calculation Builder
  • Creating Common Business Calculations
  • Creating Custom Calculations
 
Using SQL to Query Oracle OLAP Cubes
  • Understanding Cube Views
  • Querying OLAP Cubes: The Basics
  • Leveraging Cube Summaries
  • Applying Query Filters
  • Joining OLAP and Relational Data
Enhancing Analytic Content
  • Creating Cubes with Varying Dimensionality
  • Integrating Measures from Data with Different Dimensionality
  • Creating Forecast Measures Using OLAP DML
Using Ad Hoc Query and Reporting Tools Against OLAP Data
  • Exploring OLAP Data Using Oracle Application Express (APEX)
  • Performing Ad Hoc Query of OLAP Data Using Oracle BI Answers
  • Examining Metadata Requirements for BI Tools
Implementing Cube Security
  • Understanding Authentication Requirements
  • Authorizing Access to Cube Data
  • Examining User and Object Privileges
  • Examining Methods for Scoping User Views of Data
Designing Cubes for Performance and Scalability
  • Objectives of Performant and Scalable Design
  • Examining how Data is Stored in Oracle Cubes
  • Identifying Cube Features that Impact Performance and Scalability
  • Implementing Design Techniques for Performance and Scalability
Examining Performance Tuning
  • Describing How Cubes are Stored
  • Understand Cube Build Processing
  • Examining Balanced Configurations
  • Correcting Performance Bottlenecks