Duration:
Only 2 days
Study Mode:
Classroom
Next Date:
10/03/2025 (Monday)

Overview

On this accelerated SAS® Certified Specialist: Forecasting and Optimization Using SAS® Viya course,

Successful candidates are familiar with SAS® Model Studio and SAS® Studio for Optimization. They are skilled in tasks such as: creating, fitting and refining forecast models, visualizing modeling data, building and sharing custom pipelines for large-scale forecasting analyses and Solving optimization problems using linear, mixed integer linear and non-linear programming.

In just 2 days, you’ll learn Data visualization. You’ll also learn how to:

  • Pipeline modeling
  • Hierarchical forecasting
  • Post-forecasting functionality
  • Optimization

At the end of this course, you’ll sit the SAS exam, and achieve your SAS® Certified Specialist: Forecasting and Optimization Using SAS® Viya certification. Through Firebrand’s Lecture | Lab | Review methodology, you’ll get certified at twice the speed of the traditional training and get access to courseware, learn from certified instructors, and train in a distraction-free environment.

 

Audience

This course is ideal for:

  • Data scientists, forecasters, analysts, economists and others who create forecasting models.

Curriculum

Module 1: Data Visualization (15% – 20%)

Create project and load data

  • Create a Forecasting project (define variable roles)
  • Load data from various sources
  • Use Data tab functionality

Visualize data using attribute variables

  • Load Attributes table
  • Identify scenarios in which attribute variable are useful in visualizing data
  • Create a Visualization using Attribute Variables

 

Module 2: Pipeline Modeling (25% – 30%)

Model using a pipeline

  • Auto-forecast using a pipeline
  • Build and run a custom pipeline
  • Given a scenario select and use appropriate pipeline template
  • Visualize the forecasts

Determine the champion models

  • Compare models within a pipeline
  • Recognize and interpret the model family of the champion model
  • Define the role of accuracy statistics in pipeline comparison
  • Select the champion model for the project
  • Explore the champion model

Judge model accuracy using accuracy statistics

  • Define and calculate MAPE, MAE, RMSE Adaptive learning
  • Given a scenario determine when is best appropriate to use MAPE, MAE or RMSE
  • Use a holdout sample to do honest assessment

 

Module 3: Hierarchical Forecasting (15% – 20%)

Generate a forecast using data with a hierarchical structure

  • Generate a hierarchical forecast with default functionality
  • Improve the fit of a forecast by adding combined models
  • Share a model using The Exchange
  • Visualize the forecast models for a given level of the hierarchy

Use Time Series data creation options

  • Explain the differences between data accumulation and data aggregation
  • Given a scenario select the appropriate accumulation or aggregation options

Implement a hierarchical model or combined model

  • Given a scenario select the appropriate reconciliation method for a hierarchical model
  • Generate a combined model

 

Module 4: Post-Forecasting Functionality (10% – 15%)

Implement an override on a forecast in SAS Model Studio

  • Apply an override to a forecast
  • Resolve an override conflict
  • Use attribute variable to set an override
  • Disseminate tables containing the results of a forecast (manually vs. automatically)

Export a forecast

  • Prepare exported data set for use in SAS Visual Analytics

 

 

Module 5: Optimization (25% – 30%)

Optimize using Linear Programming

  • Explain local properties of functions that are used to solve mathematical optimization problems
  • Use the OPTMODEL procedure to enter and solve simple linear programming problems
  • Formulate linear programming problems using index sets of arrays of decision variables, families of constraints, and values stored in parameter arrays
  • Modify a linear programming problem (changing bounds or coefficients, fixing variables, adding variables or constraints) within the OPTMODEL procedure

Optimize using Nonlinear Programming

  • Use the OPTMODEL procedure to enter and solve simple nonlinear programming problems
  • Describe how, conceptually and geometrically, iterative improvement algorithms solve nonlinear programming problems
  • Identify the optimality conditions for nonlinear programming problems
  • Solve nonlinear programming problems using OPTMODEL procedure
  • Interpret information written to the SAS log during the solution of a nonlinear programming problem
  • Differentiate between the NLP algorithms and how solver options influence the NLP algorithms

Optimize using Mixed Integer Linear Programming

  • Use the OPTMODEL procedure to enter and solve simple MILP problems
  • Identify the optimality conditions for MILP problems
  • Solve MILP programming problems using the OPTMODEL procedure

Exam Track

At the end of this accelerated course, you’ll sit the following exam at the Firebrand Training centre, covered Certification Guarantee:

SAS® Certified Specialist: Forecasting and Optimization Using SAS® Viya A00-407 Exam

  • Duration: 90 minutes
  • Format: Multiple choice and short-answer questions
  • Number of questions: 50 questions.
  • Passing score: Passing score is 68%
  • Domains:
    • 15-20% - Data visualization
    • 25-30% - Pipeline modeling
    • 15-20% - Hierarchical forecasting
    • 10-15% - Post-forecasting functionality
    • 25-30% - Optimization

Prerequisites

There are no prerequisites for this accelerated course.

What's Included

Your accelerated course includes:

  • Accommodation *
  • Meals, unlimited snacks, beverages, tea and coffee *
  • On-site exams **
  • Exam vouchers **
  • Practice tests **
  • Certification Guarantee ***
  • Courseware
  • Up-to 12 hours of instructor-led training each day
  • 24-hour lab access
  • Digital courseware **

* For residential training only. Accommodation is included from the night before the course starts. This doesn't apply for online courses.
** Some exceptions apply. Please refer to the Exam Track or speak with our experts.
*** Pass first time or train again free as many times as it takes, unlimited for 1 year. Just pay for accommodation, exams, and incidental costs.

Benefits

Seven reasons why you should sit your course with Firebrand Training

  • Two options of training. Choose between residential classroom-based, or online courses
  • You'll be certified fast. With us, you’ll be trained in record time
  • Our course is all-inclusive. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
  • Pass the first time or train again for free. This is our guarantee. We’re confident you’ll pass your course the first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
  • You’ll learn more. A day with a traditional training provider generally runs from 9 am – 5 pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day of quality learning time, with your instructor
  • You’ll learn faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
  • You’ll be studying with the best. We’ve been named in the Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified over 135,000 professionals

*For residential training only. Doesn't apply for online courses
**Some exceptions apply. Please refer to the Exam Track or speak with our experts

Think you are ready for the course? Take a FREE practice test to assess your knowledge!  Free Practice Test

Course Dates


Start
Finish
Status
Study Mode
Prices
10/03/2025 (Mon)
11/03/2025 (Tue)
Open
Classroom
04/06/2025 (Wed)
05/06/2025 (Thu)
Open
Classroom
08/09/2025 (Mon)
09/09/2025 (Tue)
Open
Classroom
09/12/2025 (Tue)
10/12/2025 (Wed)
Open
Classroom