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

Topic 2: Database Analytics Apply and test your

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!