Advanced Coding in Prophet - Course Outline
Day 1
Introduction
- Overview
- Objectives
- Revision
Array Variables
- How to use them
- Advantages and Disadvantages of using Array variables
- Hints and tips on usage
- Array variable examples
- Hands on exercise
Extended Formulas
- Non t-dependant extended formulas
- t-dependant extended formulas
- Debugging
- Construction of extended formulas
- Hints and tips on usage
- Extended formulas examples
- Hands on exercise
Text Variables
- Text manipulation
- Advantages and Disadvantages of using text variables
Optimisation of Runs
- Optimising extended formulas
- Efficient Array coding
- Optimising standard Prophet code
- Optimisation performed by the system
- Efficient models
- Common examples of inefficient code
Advanced Quiz
Day 2
Introduction to DCS and Grouping
- How to set up Data Conversion Programs (DCS)
- Example programs
- How to perform Data Grouping both in DCS and Prophet
- Hints and Tips
New Business Methods
- Alternative approaches to modelling new business
- Advantages and Disadvantages of each
- Sales Generator
- Practical group exercise
Workspace/ Model Controls
- User permissions
- Parallel PC runs
- Audit features and controls
Other Advanced features
- Calculation looping
- Goalseeking
- Rebasing
Advanced Exercises
Individual delegates will have the choice of one or more of
the following advanced exercises:
- Array variable exercise
- Extended formulas exercise
- Calculation looping & Excel reporting exercise
- Goalseeking Exercise
Close supervision and guidance will be provided by the trainer, which will allow each delegate to concentrate on areas with the greatest relevance for them.
Back to course overview |
Booking and contact information |
Back to list of courses
