Reference no: EM132344547

Reporting Assignment

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 PowerBIto 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.

You need to create a save a separate report for each question.

Question: 1. What is the overall Revenue?

Question: 2. What is the Revenue for E-Bike in 2017?

Question: 3. What is the Revenue for E-Bike in 2016?

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

Question: 5. What year had the highest Sales Quantity?

Question: 6. What year had the lowest Revenue?

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

Question: 8. Which material has the lowest revenue?

Question: 9. In the year that had the highest Net Sales, what division had the least Net Sales?

Question: 10. For the Division and Year in the previous Question, which customer had the least Net Sales?

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

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

Question: 13. What City provided the highest Revenue for Accessories in 2014?

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

Question: 15. What is the average customer Revenue in the Bikes Division in 2016?

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

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

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

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

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

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.

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?

Question: 23. Are there any materials that show dramatic change in revenue?

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

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

Question: 26. What percentage of total revenue was achieved from Chicago in 2014?

Attachment:- Reporting_Assignment.zip