Coles Coles experienced a record-breaking surge in profits in 2020 inflated by stockpiling and the shift to

Fantastic news! We've Found the answer you've been seeking!

Question:

Coles Coles experienced a record-breaking surge in profits in 2020 inflated by stockpiling and the shift to working from home. However, the CEO of the company, Steven Cain, is concerned that Coles is unable to maintain the unprecedented sales growth in the new financial year.

With online grocery shopping becoming the preferred option for customers, Mr Cain would like to focus on ensuring the orders from online shopping can be filled in a timely manner. Mr Cain has approached you as a BI Consultant to analyse the existing online grocery shopping database to provide insights into the possibility of increasing the average value of online grocery orders of existing customers through personalised promotions. Mr Cain is expecting your analysis to provide insight at the Strategic and Tactical levels of decision-making to maintain the growth of the company.

Provide answers for the following questions relating to this Case Study:

A1. (2 marks) Write a Priority for this case study.

A2. (4 marks) Name one-way Business Intelligence can help the organization achieve this priority and one-way Business Analytics can help the organization achieve this priority.

A3. (4 marks) Write one intermediate diagnostic question and one elementary prescriptive question a dashboard supporting this priority should be able to answer.

A4. (4 marks) List two structured data items you could use for this case study and indicate whether these items would be internal or external. While you are gathering data at Coles for this project, it becomes apparent that the corporate website and the Coles app operate on separate platforms and do not communicate with one another. You raised the issue with the IT department and are currently awaiting a response.

A5. (2 marks) List two potential issues with data quality in this case study.

A6. (2 marks) Give one reason why this BI project could fail. Explain briefly.

A7. (4 marks) Following the website/app issue identified above, explain briefly to Mr Cain how Coles would use a Data Warehouse in this instance in support of Business Intelligence.