Forecast

Based on all things we learned in the previous chapters we can create or modify the financial forecast which is an estimate of future financial outcomes for a company.

At present our model only has Actual data stored within it – we need to add some Forecast data which we will get from a CSV file.

Import Forecast Data {3 minutes}

Navigate to Main Menu > Files > My Files.
Select Model PnL_Admin_New###.

Note

If you have not previously created or copied this model, you will need to follow the steps in the

Select Data Management as workspace.
Select Import Data from File.

Select Select Source File, then select file “Data_PnL_Forecast.txt” from the location that you have saved the datasets to.

Note

If you are doing this as a standalone module, download

Select the Public folder. Select the Experience Academy - SAC Planning folder and then the Datasets folder and select the file to download.

Select Import.

Wait for this message:

Select the “Data_PnL_Forecast.txt” draft source.

Select OK on Data Sample message that appears.

Select Grid View.

The side panel with import settings should be opened automatically, if not select the Cube icon to assign general import settings.
Scroll down to the Version section.

Within the Version section select the following:
- Select the New Version radio button.
- Under the Category drop-down select Forecast.
- For the Version Name enter Forecast.
Then click Finish Mapping.

Select Finish.

Once you can see the imported file within the Import Jobs section, select the Model Structure workspace.

Select the General dropdown option.
Select Save.

Besides Actual and Product Profit we now have now loaded our original Forecast data.

Next lesson