Reporting Assignment
Date Due: Week 7
Assessment Percentage: 35%
Groups: 2
Data File: Ass1 T1 2019.xlsx
Scenario
You work as a report developer and analyst for Global Bike International (GBI). 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 your student ID. 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 ofnthe assignment to Blackboard.


Question: 1. What is the overall Revenue?
Answer:
Screen shoots:
Note:

Question: 2. What is the Revenue for E-Bike in 2017?
Answer:
Screen shoots:
Note:

Question: 3. What is the Revenue for E-Bike in 2016?
Answer:
Screen shoots:
Note:

Question: 4. What is the Sales Quantity of T-shirts to Airport Bikes in 2014?
Answer:
Screen shoots:
Note:

Question: 5. What year had the highest Sales Quantity?
Answer:
Screen shoots:
Note:

Question: 6. What year had the lowest Revenue?
Answer:
Screen shoots:

Note:

Question: 7. In the year with the lowest Revenue, what Material had the lowest revenue?
Answer:
Screen shoots:
Note:

Question: 8. Which material has the lowest revenue?
Answer:
Screen shoots:

Note:
•

Question: 9. In the year that had the highest Net Sales, what division had the least Net Sales?
Answer:
Screen shoots:
Note:
•

Question: 10. For the Division and Year in the previous Question, which customer had the least Net Sales?
Answer:
Screen shoots:
Note:
•

Question: 11. In the year with the highest Revenue, what division had the highest sales revenue?
Answer:
Screen shoots:

Note:

Question: 12. For the Division and Year in the previous Question, which Customer had the highest Net Sales?
Answer:
Screen shoots:
Note:

Question: 13. What City provided the highest Revenue for Accessories in 2014?
Answer:
Screen shoots:
Note:

Question: 14. In 2015, for Bicycles what is the total revenue for the top three customers?
Answer:
Screen shoots:
Note:

Question: 15. What is the average customer Revenue in the Bikes Division in 2016?
Answer:
Screen shoots:
Note:

Question: 16. What material has had the highest Quantity sold?
Answer:
Screen shoots:

Note:

Question: 17. Explain the annual revenue trends for the USA and Germany? Develop an appropriate visualisation.
Answer:
Screen shoots:

Note:

Question: 18. Did GBI ever gain or lose a customer? Explain
Answer:
Screen shoots:

Note:

Question: 19. Which Material had the biggest drop in Revenue over a one year period? Develop an appropriate visualisation.
Answer:
Screen shoots:
Note:

Question: 20. What Year and Material did the highest Revenue from a single customer occur in?
Answer:
Screen shoots:
Note:

Question: 21. Is there any major change in revenue during the five years of data? What were the Materials that contributed to this change? Explain and develop an appropriate visualisation.
Answer:
Utilized Tools:
Screen shoots:
Note:

Question: 22. Is there seasonality in revenue during the year? If so, what month has the highest revenue? Is the seasonality similar from year to year? Why?
Answer: • .

Screen shoots:
Note:

Question: 23. Are there any materials that show dramatic change in revenue?
Answer:
Screen shoots:
Note:
•

Question: 24. What is the average % discount of the different deluxe touring bikes (red, silver, black)?
Answer:
Screen shoots:

Note:
•

Question: 25. Which bike is the most profitable? Profit = Revenue-(cost of goods+discount) and what is the profit?
Answer:
Screen shoots:
Note:

Question: 26. What percentage of total revenue was achieved from Chicago in 2014?
Answer:
Utilized Fields:
Screen shoots:

Note:
•