Reference no: EM132286856
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.
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 customerRevenuein 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.rar