This course teaches the fundamental concepts and processes of building and analyzing multi-dimensional activity-based cost models through the use of OLAP analysis cubes, custom report templates, and the classic analytic view of an ABC model. This self-study course includes structured course notes that provide a detailed overview, essential skills, and exercises, along with a software Virtual Lab to practice.

The e-learning includes:

• digital course notes for self-study
• Virtual Lab: 30 hours of hands-on software practice

• describe activity-based costing (ABC) methodology
• use SAS Cost and Profitability Management 8.X software for modeling, OLAP analysis, what-if analysis, and model updating
• construct a model
• import and export model data for backup and relocation
• perform dimensional analysis using online analytical processing (OLAP) techniques
• use surveys to conduct model updates
• create what-if scenarios to visualize the effect of possible changes made in the model.

Who should attend

Formats available	Standard Duration
e-Learning:	21 hours/180 day license	System Requirements

There are no formal prerequisites for this course.

This course addresses SAS Cost and Profitability Management Standard software.

• overview
• fundamentals of an activity-based model

• navigating through the SAS Cost and Profitability Management workspaces
• describing the administration and security as it affects the models and users

• describing dimensional categories for cost
• explaining how the dimensions affect the models structure
• using the New Model Wizard
• adding dimension members
• using the New Account Wizard to create intersection accounts
• identifying cost elements
• adding cost to the model

• describing the importance of period-specific and scenario-specific models
• defining new periods and scenarios

• creating a column layout
• creating drivers
• creating inter-modular and intra-modular assignments
• calculating the model

• identifying and defining the types of attributes
• attaching attributes to intersection accounts

• identifying typical custom drivers
• identifying driver quantity types
• identifying the difference between fixed and variable drivers
• using custom drivers in the model

• touring the OLAP page
• configuring and generating a single-stage cube and resource contribution cube
• conducting a dimensional analysis of a SAS Cost and Profitability Management OLAP model
• analyzing model data in the Table and Graph views
• exploring and conducting an analysis of a cube with attributes

• defining stages and the stages attribute
• generating a multi-stage cube with attributes
• analyzing a multi-stage cube using the Explorer view
• defining and using calculated measures in an OLAP analysis

• exporting and importing model data
• creating and using surveys
• developing a what-if analysis

• reviewing the modeling process
• identifying additional modeling tools, techniques, and courses