Hyperion Essbase Spreadsheet Add-in and Visual Explorer 7X Self-Study Course

Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

This product does not have fixed starting dates and/or places.

Description

Discover how Hyperion Essbase Spreadsheet Add-in and Hyperion Visual Explorer can turn your familiar spreadsheet application into an integrated online analytical processing (OLAP) client for Hyperion Essbase that enables you to transform data into insightful information. This self-paced, self-study course will teach you how to query and analyze data, create spreadsheet reports, and design advanced queries to address all your reporting needs. You will learn how to load and recalculate data to investigate what-if scenarios and extract valuable information that will help you make better and more informed business decisions.
Audience
  • Business Analysts

Course Topics Describing Hyperion Essb…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. Send an Email to info@springest.com

Didn't find what you were looking for? See also: Full time MBA, Global MBA, Executive MBA, Part time MBA, and Flex MBA.

Discover how Hyperion Essbase Spreadsheet Add-in and Hyperion Visual Explorer can turn your familiar spreadsheet application into an integrated online analytical processing (OLAP) client for Hyperion Essbase that enables you to transform data into insightful information. This self-paced, self-study course will teach you how to query and analyze data, create spreadsheet reports, and design advanced queries to address all your reporting needs. You will learn how to load and recalculate data to investigate what-if scenarios and extract valuable information that will help you make better and more informed business decisions.
Audience
  • Business Analysts

Course Topics Describing Hyperion Essbase
  • Basic Multidimensional Database Terminology
  • Describing the Client-Server Environment
  • Identifying the Users of Essbase
Introduction to Essbase Spreadsheet Add-in
  • Components of Essbase Spreadsheet Add-in
  • Connecting and Disconnecting from Essbase
  • Accessing the Online Help
Retrieving and Manipulating Data
  • Retrieving Data
  • Changing the Report View
  • Drilling In and Out of Data
  • Focusing on Specific Data
Retrieving Data Based on Attribute Dimensions
  • Querying Data Using Attribute Dimensions
  • Drilling into Attribute Dimensions
  • Creating Calculations with Attribute Dimensions
Creating Advanced Member Selections
  • Selecting Members
  • Defining Subset Selections
Creating Reports
  • Formatting Data
  • Creating Report Templates
  • Creating Cascaded Reports
Creating Advanced Reports
  • Preserving Spreadsheet Formulas
  • Using Substitution Variables
Loading and Calculating Data
  • Loading Data into the Essbase Server
  • Calculating Data
Creating and Modifying Queries
  • Creating Queries
  • Opening and Modifying Saved Queries
  • Preserving Spreadsheet Styles
Refining Queries
  • Filtering Data
  • Sorting Data
  • Ranking Data
Creating Crosstab Reports
  • Connecting to Data Sources
  • Creating a Summary Table View of Data
  • Filtering Dimension Members and Data Values
Presenting Data Graphically
  • Creating Graphical Views of Data
  • Creating Advanced Analysis Reports
Managing and Publishing Reports
  • Creating and Saving a Workbook
  • Creating Bookmarks for Reports
  • Publishing and Sharing Reports

Course Objectives
  • Retrieve and navigate through data
  • Design queries and reports
  • Add data analysis to reports and load data
  • Create data visualizations and explore the interrelationships of data using Hyperion Visual Explorer

There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

    There are no frequently asked questions yet. Send an Email to info@springest.com