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

Workday HCM Demo New Batches Starting from Monday... 13-11-2017
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 Starting From 14th NOV & 15th NOV.


Hadoop Dev New Batch Starting From 15th NOV & 16th NOV.


IBM COGNOS TM New Batch Starting From 16th NOV & 17th NOV.


Informatica Dev New Batch Starting From 17th NOV & 18th NOV.


Mean Stack New Batch Starting From 18th NOV & 19th NOV.

SAP BODS new Batch Starting From 19th NOV & 20th NOV.

SAP S/4 HANA New Batch Starting From 20th NOV & 21st NOV
.

Tableau New Batch Starting From 21st NOV & 22nd NOV

PUBLIC DEMO


(1) Workday Technical Demo Training

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

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