AIN$3701$ Data analysis and automation

Assignment $32024$

Unique number: $592440$

Deadline: $10$ September $2024,$ at $23$:$00$

You have been appointed as a financial manager at Ubuhle Bemvelo Bistro $($UBB$).$ UBB is one of the top restaurants in South Africa, serving traditional South African dishes. UBB is situated in a private game reserve in Pretoria and is being visited by local and international visitors. UBB was also recognised by an international magazine as one of the must visit attractions in South Africa. Another achievement achieved this year was for UBB to be awarded as one of the top $10$ restaurants in South Africa.

You are reporting directly to the financial director, Mrs Ceki, who qualified as a CA$($SA$)$ in $1998.$ Part of your duties is to assist Mrs Ceki with drawing up visual dashboards for UBB. UBB uses Microsoft Excel $365$ to generate visual dashboards.

UBB has invested in a new sales system who generates summative records of sales during the year, per product category $($category$)$ and product. These records include the month of sale as well.

The CEO of UBB, Mr Gokal, is very exited about this new system and has provided Mrs Ceki with the electronic records of the system. He asked Mrs Ceki to draw up a visual dashboard reflecting the sales volumes for the $2024$ year.

Mrs Ceki is not well versed in visual dashboards but know a few functions in Excel $365.$

She has spent around two weeks to generate a draft dashboard for one of the product categories. She presented the draft dashboard to Mr Gokal, and they agree that the dashboard should look like the following dashboard: