As a data modeler, do you want to combine actual sales data with financial budgeting data to create a variance to budget?
If so, this guide is for you. We will walk through this process and also include how this variance can be set to absolute/percentage.
This training is based on Pyramid 2020.17.
Please adjust your screen zoom setting when you open the use case to see it in full screen mode.
You will learn:
- how to create a model with two sources (sales actual and budget data)
- assign budget data to be held at month, region and product category
- to create a Discover object that shows actual budget variance and percentage variance
- using grid view and colour codes to display positive and negative along with percentage variance.