Build a dashboard. Can use excel, power or other apps. ( Need to be done before this Monday, 7/3/2022)

Abc's new ceo and board of directors has asked your consulting company to help in developing a dashboard to monitor the financial performance of the company.  The company has only been using monthly reports from their existing ERP System that only provides information at customer level and consolidated level only. 
·         Design a dashboard using the data on the Data Set Tab of this File.
·         Dashboard can be in Excel, PowerPoint, or whichever format you deem fit.  Explain to the BOD your reason for using and if this method can be easily replicated, updated each month.
·         Analyze the data and provide a list of your key findings and an additional insights that you uncover from the data set that can help the Board understand company performance over the last 19 months.
·         The Board and Management would like to have a prediction around Q4 2018 sales for the company and a general direction for next 3 years.  And how the company could help to reduce transports costs over this same time period.  Should the company contrast/expand into any additional cities over these 3 years.