Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
Search Course Here




Live Chat
Support
Oracle OLAP  Online Training

Oracle OLAP

overview

Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries producing results with speed of thought response times. This outstanding query performance may be leveraged transparently when deploying OLAP cubes as materialized views enhancing the performance of summary queries against detail relational tables
prerequisties
  • All attendees should have
    • Basic SQL knowledge
    • A basic understanding of OLAP concepts.
Duration
Online
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.
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
Videos
Oracle OLAP videos will be updated soon
To Watch More Videos Click Here

Flash News


AngularJS New Batch Start From 09th OCT & 10th OCT.


Hadoop Dev New Batch Start From 10th OCT & 11th OCT.


IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.


Informatica Dev New Batch Start From 12th OCT & 13th OCT.


Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT
.

Tableau New Batch Start From 16th OCT & 17th OCT

PUBLIC DEMO

(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

(2) SAP MII Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings