Oracle OLAP Essentials Workshop

Focus on Training

Course

In London-City

£ 1,645 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London-city

Oracle OLAP Essentials Workshop - key skills for all embarking on an Oracle business intelligence, data warehousing or data mining project. Learning Objectives Online analytical processing, (OLAP), as succinctly different to OLTP   (transactional processes) enables fast multi-dimensional analytical   (MDA) queries. iTrain’s Oracle OLAP Essentials workshop will explore OLAP data models to enable attendees to support and address the needs of a broad range of business intelligence project requirements. Hands on labs are structured throughout courses and will include exercises to enable delegates to design and build OLAP cubes to serve as a summary management resource for existing SQL table queries, through to adding rich analytic content to attendees data models. Further hands on labs will provide delegates with skills to develop their own sophisticated reports of OLAP data by using simple SQL queries, to execute OLAP queries in SQL Developer or Oracle tools, and progress to apply cube security, access control, exploring best practice including performance.

Facilities

Location

Start date

London-City ((select))
EC3V 9LJ

Start date

On request

About this course

SQL for OracleA base understanding of OLAP and BI concepts is helpful, athough not essential

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Business Intelligence
  • Project
  • Design
  • SQL
  • Access

Course programme

Oracle OLAP, Oracle BI and Data Warehouses

Oracle OLAP and the Oracle BI / DW Platform

Oracle OLAP Option Overview

Accessing Oracle OLAP data

Dimensional Model

Stored and Calculated Measures

Dimensions

Hierarchies

Levels

Attributes

OLAP Cubes

The Cube Building Tool

Creating Dimensions

Designing Cubes

Creating Measures

Mapping to Source

Data Loading Data

Cube-Organized Materialized Views (Cube MVs)

Cube MV Summary Management

General Requirements for rewrite to MVs

Designing Cube MVs

Using Cube MVs

Creating Calculated Measures

OLAP Calculation Types

The Calculation Builder

Creating Common Business Calculations

Creating Custom Calculations

Using SQL to Query Oracle OLAP Cubes

Cube Views

Querying OLAP Cubes

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

Forecast Measures Using OLAP DML

Using Ad Hoc Query and Reporting Tools Against OLAP Data

OLAP Data Using Oracle tools

Ad Hoc Query of OLAP Data Using Oracle BI Answers

Metadata Requirements for BI Tools

Implementing Cube Security

Authentication Requirements

Authorizing Access to Cube Data

User and Object Privileges

Methods for Scoping User Views of Data

Designing Cubes for Performance and Scalability

Objectives of Performant and Scalable Design

Data is Storage in Oracle Cubes

Cube Features that Impact Performance and Scalability

Design Techniques for Performance and Scalability

Examining Performance Tuning

How Cubes are Stored

Cube Build Processing

Balanced Configurations

Performance Bottlenecks

See related categories

Oracle OLAP Essentials Workshop

£ 1,645 + VAT

The best Oracle courses

See all

See all