BUS1001 – Data Analytics Concepts Assignment 2
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
BUS1001 – Data Analytics Concepts
Assignment 2: 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 identifiableperson 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 memberwho will assess it. |
By submitting* this piece of work and signing this document, I declare that:
1. The work is my own work.
2. I have not previously submitted all or part of this work for assessment in any subject, unless the subject coordinator for the current subject (or my research supervisor, if applicable) has given me written permission to reuse specific material and I have correctly referenced the material taken from my own earlier work.
3. I have read and agree to be bound by the Statutes, Regulations and Policies of the University relating to Academic Integrity available at http://www.latrobe.edu.au/students/academic-integrity;and
4. I may be subject to student discipline processes in the event of an act of academic misconduct by me including an act of plagiarism or cheating.
I further grant to the University or any third party authorised by the University (www.latrobe.edu.au/text-match)the right to reproduce and/or communicate (make available online or electronically transmit) the work I have submitted for the purpose of detecting plagiarism.
Assignment Requirements
1. (20 marks) Write a short paragraph to answer each of the following questions:
a. Choose two attributes among the six key attributes of actionable insights; for each attribute, give two examples, one actionable insight and one unactionable insight and explain why it is actionable or unactionable. (Limit to 300 words)
b. Give a data analytics success story of a company (you cannot use those in Weeks
1 and 8) and explain how they use data in their success. (Limit to 200 words)
2. (20 marks) Given the product review scores of the two product categories, Bed_bath_table and Health_beauty, in the Q2 worksheet of the BUS1001-Ass2.xlsx file. Using the learnt statistical analysis techniques with MS Excel to provide answers/interpretations for the following questions.
a. (3 marks) What is the probability of having a product review score above 4.5 for a Bed_bath_table product? And for a Health_beauty product? (Hint: see Tasks 1 of Week 6)
b. (4 marks) What is the 95% confidence interval of the average review of a Bed_bath_table product? (Hint: see Task 1 of Week 7).
c. (5 marks) With 95% confidence, can one claim the average review of a Health_beauty product greater than 4? (Hint: see Tasks 3 to 6 of Week 7)
d. (8 marks) Apply hypothesis testing to find out whether one can claim Health_beauty products have a significantly higher average review than Bed_bath_table products with 95% confidence. (Hint: see Tasks 7 and 8 of Week 7)
3. (30 marks) The Becommerce company wants to conduct a marketing campaign to promote their products in 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 campaign.
The Order worksheet in 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 product category to promote. Visualise 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 analytics tasks/questions. For example, “what are the top … that have the highest … ?”
• Analyse and visualise 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.
Hint: You should formulate many questions and then choose four that you can
combine to create a good story in a dashboard that can recommend appropriate actions for a successful campaign to promote their products. You should choose
appropriatevisualisation types to convey your messages (e.g., bar chart, line chart, pie chart, etc.). Apply visualisation best practices.
• Describe the insights shown in your visualisations.
• Recommend appropriate actions based on your insights so the company can have a successful marketing campaign to promote their products.
Submission Guidelines
Your submission to this assignment is required to have TWO FILES:
1) A WORD file: Contains ALL the answers. The file should have 3 sections:
• Section 1: Answers to two sub-questions of Question 1.
• Section 2: Each answer for Question 2 must show working out step by step, and
• Section 3: Describe the analytics questions, show visualisations, state insight of each visualisation, and recommendation that is backed up by your analysis.
2) An EXCEL file (for the purpose of checking your calculations, not for marking): Includes all the calculations that you show in the Word file for Questions 2 and 3. Note that if this file is missing or the content of this file does not match the answers in the WORD file, NO MARK WILL BE AWARDED for Questions 2 and 3.
Marking rubrics
The marker will use the following marking guide to assess your work. Please make sure you understand what you need to cover for each question in this assignment.
Submissions having a high similarity score will be considered plagiarism/collusion and will be reported to the Academic Integrity Advisors.
Question 1a - (10 marks)
Criterion |
Standard exceeded |
Standard met |
Standard not met |
|
8-10: - Excellent coverage of the required information relating to the task. - Acceptably low level of grammar and spelling errors Does an excellent job of drawing readers through . |
4-7 - Reasonable coverage of the required information relating to the task. - Some grammar and spelling errors. Readers can get through with some difficulties. |
0-3 - Has Little or no meaningful information relating to the task. - Significant grammar and spelling errors. - Not draw readers through. |
Question 1b - (10 marks)
Criterion |
Standard exceeded |
Standard met |
Standard not met |
|
8-10: - Excellent coverage of the required information relating to the task. - An appropriate level of references. level of spelling - Does an excellent job of drawing readers through. - Correct reference style |
4-7 - Reasonable coverage of the required information relating to the task. - Limited references. - Some grammar andspelling errors. - Readers can get through with some difficulties. - Correct reference style |
0-3 - Has Little or no meaningful information relating to the task. - No reference. - Significant grammar and spelling errors. - Not draw readers through. - Incorrect reference style |
Question 2 - (20 marks)
A full mark is given for each correct question with a step-by-step answer. Half of the mark will be given for something close.
2022-09-24