My team collects a two-year cash forecast from the business units and consolidates the data for analysis. I would like to use Power-BI to visualise the results. My company has access to the online Power-BI version so I need help to prepare a few visualisation charts and use the charts in PowerPoint presentations. I would also like to learn how you prepared the charts.
I have prepared sample data for 5 business units and I would like to:
-> Consolidate the data
-> Compare the monthly low points of all business units
-> Summation of daily forecast balance
-> Visualise the closing balances of all the business units on a selected date.
-> Compare the monthly low points with the previous month's figure (Change in the forecast).