A Hyperion Education Services Training Map

Hyperion System 9 BI+ Analytic Services

Hyperion System 9 BI+ Analytic Services Fundamentals

BUSINESS USER

Hyperion Essbase Spreadsheet Add-in and Visual Explorer CBT

(valid for Hyperion System 9 BI+ Analytic Services Users)

Hyperion System 9 BI+ Getting Started CBT

Hyperion Essbase Analytics Bootcamp (5 Days)Objectives:

• Describe the role of OLAP tools in Business Performance Management• Identify the components of the Analytic Services product family

and describe its architecture• Design and build database outlines• Create load rules to automate dimension builds and data loads• Analyze data in Microsoft Excel, constructing and troubleshooting

a variety of reports• Describe the Essbase Analytics data structure and configure a database

for optimal performance• Create basic database calculation scripts

Hyperion Essbase Spreadsheet Add-in and Visual Explorer CBT (6-8 Hours)

Objectives:

• Describe basic data structures within an Analytic Services database• Identify the Essbase Spreadsheet Add-in components• 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 Visual Explorer

Hyperion System 9 BI+ Analytic IntegrationServices: Create and Manage Data Structures (3 Days)

Objectives:

• List the benefits of data warehousing, business intelligence,and performance management

• Describe the Analytic Integration Services implementation process• Create and load Analytic Services databases from data sources• Provide direct access to relational databases using drill-through reports• Create relational OLAP (ROLAP) applications by enabling Hybrid Analysis

and Advanced Relational Access

Hyperion System 9 BI+ Analytic Services for System Administrators (3 Days)

Objectives:

• Configure the Analytic Services environment• Estimate disk storage requirements• Set up user, group, and application access type security• Optimize the Analytic Services environment• Perform database maintenance, including backup and recovery

and application migration• Automate routine tasks using the MaxL command line interface

Hyperion Essbase Analytics Bootcamp

DEVELOPER

Hyperion System 9 BI+ Analytic Integration Services:Create and Manage Data Structures

Hyperion System 9 BI+ Analytic Services for System Administrators

IT SUPPORT

Hyperion System 9 BI+ Analytic Services Courses

Education solutions that accelerate performance and ROI

Hyperion System 9 BI+ Enterprise Analytics:Deploy Aggregate Storage Databases

Hyperion System 9 BI+ Analytic Services for System Administrators

Hyperion System 9 BI+ Web Analysis: Design Reports

Hyperion System 9 BI+ Analytic Services New Features (for experienced Developers)

Hyperion System 9 BI+ Web Analysis for Business Users CBT

Classroom Training Computer-based Training

Manager, Project Manager Essbase Developer, Analyst Programmer System Administrator

HCD

HCC

HCC

HCSA - Recommended classes for Hyperion Certified Solutions ArchitectHCC - Recommended classes for Hyperion Certified ConsultantHCD / HCA - Recommended classes for Hyperion Certified Developer / Administrator

Copyright 2006 Hyperion Solutions Corporation. All rights reserved. “Hyperion,” the Hyperion logo and Hyperion’s product names are trademarks of Hyperion. References to other companies and their productsuse trademarks owned by the respective companies and are for reference purpose only. No portion hereof may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or information storage and retrieval systems, for any purpose other than the recipient’s personal use, without the express written permission of Hyperion. The information containedherein is subject to change without notice. Hyperion shall not be liable for errors contained herein or consequential damages in connection with furnishing, performance, or use hereof. Any Hyperion softwaredescribed herein is licensed exclusively subject to the conditions set forth in the Hyperion license agreement.

Hyperion Solutions Corporation Worldwide Headquarters5450 Great America Parkway, Santa Clara, CA 95054voice 1.408.588.8000 / fax 1.408.588.8500

product information voice 1.800.286.8000 (U.S. only)consulting services e-mail northamerican_consulting@hyperion.com / voice 1.203.703.3000education services e-mail education@hyperion.com / voice 1.203.703.3535worldwide support e-mail worldwide_support@hyperion.com

Please contact us at www.hyperion.com/contactus for more information.

0706

� Hyperion System 9 BI+ Analytic Services Fundamentals (3 Days)

Objectives:

• Describe Online Analytical Processing and multidimensional data models

• Describe the Analytic Services environment and architecture• Create a multidimensional database using Hyperion System 9 BI+

Analytic Administration Services• Describe Analytic Services storage options• Integrate Analytic Services data with Microsoft Office products using

Smart View Provider• Retrieve and analyze data using Essbase Spreadsheet Add-in• Extend analytic and reporting capabilities by integrating Analytic

Services with Hyperion System 9 BI+ Web Analysis and Hyperion System 9 BI+ Financial Reporting

� Hyperion System 9 BI+ Analytic Services New Features (2 Days)

Objectives:

• Describe the role of Analytic Services within the BI+ framework of analysis

• Utilize Administration Services Console to complete typical tasksof administration and design

• Explain the latest updates to Analytic Services security• Create, load, and aggregate an aggregate storage database• Create and execute MDX queries• Describe Analytic Services server and database enhancements• Illustrate integration features offered by Hyperion System 9

Smart View for Office• Demonstrate the new features of Hyperion Visual Explorer

� Hyperion System 9 BI+ Analytic Services for System Administrators (3 Days)

Objectives:

• Differentiate between block storage and aggregate storage databases• Create aggregate storage databases• Implement partitioning for aggregate storage databases• Perform fundamental management tasks for aggregate storage

databases• Write queries and member formulae with MaxL Data Manipulation

Language (MDX)

Related Courses� Hyperion System 9 BI+ Web Analysis: Design Reports (2 Days)� Hyperion System 9 BI+ Getting Started CBT (4 Hours)� Hyperion System 9 BI+ Web Analysis for Business Users CBT (6-8 Hours)

HYPERION EDUCATION SERVICES provides comprehensive training solutionsthat enhance knowledge, drive performance, and accelerate ROI withHyperion technology. Our complete, blended curriculum combines inten-sive, hands-on classroom training with flexible, self-paced Computer-basedTraining and custom learning solutions to provide the right training at theright time for a variety of roles, learning styles, budgets, and schedules.

CLASSROOM EDUCATION Hyperion conducts over 1,000 administrator,developer and end-user courses annually at Hyperion Education Centersand at customer locations. Our intensive, hands-on group live trainingcourses on the latest Hyperion business performance management solu-tions are available in numerous locations throughout the world and canalso be delivered at customer sites, enabling entire project teams or usergroups to learn the technology quickly and efficiently.

CERTIFICATION PROGRAM The Hyperion Certification Program enables indi-viduals to benchmark and validate their expertise and skills usingHyperion’s business performance management solutions. The program pro-vides industry-recognized credentials for individuals and organizations toidentify and promote Hyperion experts. Certification exams are currentlyavailable for Essbase, Planning, Financial Management, Enterprise, andPillar.

CPE CREDITS Hyperion is registered with the National Association of StateBoards of Accountancy (NASBA) as a sponsor of continuing professionaleducation on the National Registry of CPE Sponsors. State Boards ofaccountancy have final authority on the acceptance of individual coursesfor CPE credit. Complaints regarding registered sponsors may be addressedto the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite700, Nashville, TN 37219-2417. Web site: www.nasba.org

To register for a course or for more information about our offerings and ourpayment, cancellation, refund, and complaint policies, visit our web site orcontact us.