Recent Question/Assignment
Reporting Assignment
Date Due: Week 7
Assessment Percentage: 35%
Groups: 2
Data File: Superstoresales T2 2019.xlsx
Scenario
You work as a report developer and analyst for Super Store. Your manager has supplied you with some data related to sales and has requested a number of reports. You task, with a partner, is to create the required reports to answer each of the questions below.
You have been requested to use Microsoft PowerBI to analyse the data. Once you have created the required reports you will need to record the answer and insert a screen shot of the report with the answer highlighted, (in the area below). Each screen shot should include the student IDs. Your manager has also asked you to interpret the data and provide an explanation for the results for certain questions.
The footer must include the group member’s name and student ID.
You need to create a save a separate report for each question.
Name your file for assignment 1 in the form Student ID1 Student ID2.pdf. You must upload a copy of the assignment to Blackboard.
Question: 1. What is the overall Sales revenue? (1 mark)
Answer:
Screen shoots:
Note:
Question: 2. What is the overall profit for 2018? (1 mark)
Answer:
Screen shoots:
Note:
Question: 3. What is the Sales revenue for Lumber Crayons in 2017? (1 mark)
Answer:
Screen shoots:
Note:
Question: 4. Which customer purchased the most Lumber Crayons in 2017? (1 mark)
Answer:
Screen shoots:
Note:
Question: 5. For the customer in Question 4, which product did they purchase the highest quantity in 2017? (1 mark)
Answer:
Screen shoots:
Note:
Question: 6. Which customer supplied Super Sales with the highest sales revenue in 2018? (1 mark)
Answer:
Screen shoots:
Note:
Question: 7. Which year had the lowest profit? (1 mark)
Answer:
Screen shoots:
Note:
Question: 8. In the year with the lowest profit which product had the lowest profit assuming all products had at least one sale? (1 mark)
Answer:
Screen shoots:
Note:
•
Question: 9. In the year with the highest profit, which product category and product subcategory were most profitable? (1 mark)
Answer:
Screen shoots:
Note:
•
Question: 10. For the Product Category and Subcategory and Year in the previous Question, which customer provided the highest profit revenue? (1 mark)
Answer:
Screen shoots:
Note:
•
Question: 11. In the year with the highest sales revenue, which region had the highest sales revenue? (1 mark)
Answer:
Screen shoots:
Note:
Question: 12. For the region and Year in the previous Question, which Customer had the highest Sales revenue? (1 mark)
Answer:
Screen shoots:
Note:
Question: 13. What customer provided the highest sales revenue for the Furniture Product Category in 2018? (1 mark)
Answer:
Screen shoots:
Note:
Question: 14. For the year and customer in the previous question which product did they spend most on? (2 marks)
Answer:
Screen shoots:
Note:
Question: 15. Which product category had the biggest change in Sales Revenue from 2015 to 2018? Develop an appropriate visualisation. (2 marks)
Answer:
Screen shoots:
Note:
Question: 16. Which order and how much was the largest refund? (4 marks)
Answer:
Screen shoots:
Note:
Question: 17. What is the average sales revenue and profit for the Corporate customer segment? (3 marks)
Answer:
Screen shoots:
Note:
•