analytic services 9
Post on 08-Nov-2014
10 Views
Preview:
DESCRIPTION
TRANSCRIPT
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.
top related