Hi, I was just going through the data for some reason to make sure all the fact data was lined up comparing apples to apples from one another. By doing this, I used all of the Budget data and Forecast data and then just the January Actual data as that probably covered the basis. I removed all the duplicates for IT Department, Cost Element and Country. The excel workbook that I provide the missing data in each scenario. Can you please explain why some data is in some fact data like Forecast for IT Dept, but missing in others as well as for the other situations? What is it suppose to be like in this tutorial versus how it should or could be in real life? Thanks!
Hi Matthew,
I didn't create the dataset, but it's quite common in the real world to budget for something that doesn't happen, or have new expenses that you didn't plan etc., so I wouldn't read too much into it.
Mynda
Thank you Mynda, that is exactly what I was thinking 🙂