Course Overview

The structure of this online training course comprises of three sections- text, videos and lab modules section. This course gives an in-depth understanding on modules like Business Intelligence overview, Data Warehousing overview, About Cognos 10.1 BI Architecture, Administration, Connection, metric studio, query studio, framework manager, power play client, data manager and transformer.

Course Duration

This course consists of 30 hours of training with two convenient options (weekday or weekend sessions)

Training Materials

  • Training material is designed by certified tutors with years of experience in classroom, online and corporate firms.
  • Recorded sessions gives an opportunity to attend lectures of missed or revision
  • Training comprises of step-by-step instructions that guides you to perform a series of tasks in an efficient and sophisticated manner
  • Narrated presentations in combination work oriented demonstration are conducted for each and every concept

What’s Needed To Join This Course?

The candidate is required to have a basic working knowledge of SQL and Oracle databases.

Who Are Ideal Candidates?

Any student from IT or non IT background can pursue this course.

Course Info

Hyperion EssBase online training course offers you an in-depth understanding on various modules such as Overview of Essbase, Design of Applications and Databases, Design of Data Descriptor Dimensions, Optimization of Data Descriptor Dimensions, Development of Dimension Designs, Creation of Basic and Advanced Dimension Build Rules Files, Loading of Data, Working with Smart View, Generating Reports with Smart View, etc.

Hyperion EssBase Curriculum

Online Analytical Processing Overview

  • Data Transformation
  • Multidimensional View of Information
  • Multidimensional Data Model
  • OLAP Solutions

Analytic Services Overview

  • Business Performance Management
  • Hyperion System 9 Overview
  • Hyperion Analytic Solution
  • Analytic Services
  • Analytic Administration Services

Creating Multidimensional Databases

  • Life Cycle of the Essbase Analytics Database Design
  • Creating Essbase Analytics Applications and Databases
  • Creating and Managing Database Outlines
  • Creating Time, Accounts, and Scenario Dimensions

Enhancing Database Outlines

  • Creating Business-view Dimensions
  • Specifying Consolidation Operators and Defining Calculations
  • Setting Time Balance Properties
  • Creating Label-Only and Shared Members
  • Defining Duplicate Member Names and Member Aliases
  • Creating Attribute Dimensions

Loading Data

  • Data Load Options
  • Loading Data from Flat Files
  • Performing Free-Form Data Loads
  • Loading Data with Rules Files
  • Loading Data from SQL Data Sources

Calculating the Essbase Analytics Database

  • Outline Calculations
  • Calculation Scripts
  • Two-Pass Calculations
  • Dynamic Calculations
  • Dynamic Time Series

Retrieving Data

    • Smart View Overview
    • Connecting to the Analytic Serverv
    • Retrieving Multidimensional Data into Two-dimensional Spreadsheet Report

s

  • Navigating Through Spreadsheet Reports
  • Manipulating Multidimensional Data
  • Installing the Web Server
  • Smart View Options

Advanced Spreadsheet Reporting

  • Updating Data on the Analytic Server
  • Creating Free-Form Reports
  • Selecting Members
  • creating Reusable Queries
  • Extending the Spreadsheet Environment with Visual Explorer

Storing Analytic Data

  • Data Storage Options
  • Block Storage
  • Block Storage
  • Aggregate Storage

Integration with BI+ Reporting Tools

  • BI+ Architecture
  • Workspace Overview and User Interface
  • Browsing the Repository
  • Working with BI+ Content
  • Previewing Financial Reports
  • Grouping Financial Reports into Books

Extending Analytic Reporting Using Web Analysis

  1. Web Analysis Overview
  2. Viewing Web Analysis Documents in Workspace
  3. Analyzing Query Results in Workspace
  4. Creating Web Analysis Documents
Hyperion EssBase Roadmap
Reviews

“I had a wonderful learning experience here at this training institute. Their comprehensive course material and advanced knowledge delivery tools made learning easier and interesting” – Shailaja Mathur

“Being a non IT graduate, this online training course has provided immense practical exposure of software field that helped me to learn the complexities and intricacies of software in a simple way. Looking forward for yet another specialization course from this institute”- Arnav Maheshwari

Hyperion EssBase Faqs
Open chat
1
Need Instant help?
Hello 👋
can we help you?