Question: Topic 2: Database Analytics Apply and test your knowledge of the current and previous topics by attempting the questions below. Completing these questions will help


Topic 2: Database Analytics Apply and test your knowledge of the current and previous topics by attempting the questions below. Completing these questions will help you to succeed in your subject. For this workshop, you are required to use MS Excel. Workshop Questions 1) Use the data given below to answer the following question. Following is the order database of XYZ restaurant in Sydney between April and June 2020. You can download the order Database from Week 2 page on Canvas. Using MS Excel calculate inventory value and then sort the data by inventory value. Using MS Excel calculate percentage and the cumulative percentage of total inventory value to help the restaurateur conduct a Pareto analysis. Note: Assume that no damages were caused to the inventory purchased over the three months
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
