Create A Data-Driven Solution To A Business Problem

Overview

Throughout this subject, you have gained an understanding of business databases and useful skills to analyse and visualise data. This assignment will provide you with an opportunity to demonstrate how data analytics helps businesses to gain actionable insights and create data-driven solutions to a business problem through the database in BUS1001-Ass2.xlsx.

Academic Integrity

Plagiarism

occurs when you use words, ideas, or work products attributable to another Identifiable person or source:

• without attributing the work to the source from which it was obtained
• in a situation in which there is a legitimate expectation of original authorship
• in order to obtain some benefit, credit, or gain which need not be monetary

Self-plagiarism

refers to the re-submission of work as if it were original. You may not submit your own academic work for assessment when it has already been submitted for assessment at anothertime (including at another institution), without the express permission of the academic staff member who will assess it.

Assignment Requirements

1. (20 marks) Given the customer satisfaction scores collected from the two cities, Sao Paulo and London, in the Q1 worksheet of the BUS1001-Ass2.xlsx file, use the learnt statistical analysis techniques with MS Excel to provide answers/interpretations for the following questions.
   1. (3 marks) What is the probability of having a satisfaction score above 4.5 from a Sao Paulo customer? And from a London customer? (Hint: see Task 1 of Week 6)
   2. (4 marks) What is the 95% confidence interval of the average satisfaction score from Sao Paulo customers? (Hint: see Task 1 of Week 7).
   3. (5 marks) With 95% confidence, can one claim the average satisfaction score of Sao Paulo customers is greater than 4.1?
   4. (8 marks) Apply hypothesis testing to find out whether one can claim the average satisfaction score in Sao Paulo is significantly higher than the average score in London with 95% confidence. Assume the variances of satisfaction scores from both cities are equal.
2. (30 marks) The Becommerce company wants to conduct a marketing campaign to promote their productsin one of their customer cities. They want to get an insight into their business so that they can come up with strategies for a successful marketing campaign.

The Order table in the Data worksheet of the BUS1001-Ass2.xlsx file records the order data of the company. You are required to analyse the provided data to support the company in deciding which customer city they should target, and which products to promote. Visualize the result of your analysis in a dashboard, and give recommendations based on insights or findings uncovered from your analysis. Specifically, you will:

• Formulate four analytic tasks/questions. For example, “what are the top … that have the highest …?”
• Analyse and visualize the results to answer the formulated questions. Then, create a dashboard to combine the created visualisations telling a story about the key patterns/insights that your analysis has discovered.
• Describe the insights shown in your visualisations.
• Recommend appropriate actions based on your insights so the company can have a successful marketing campaign.