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 SAP Web Intelligence 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 include your Web Intelligence details so we can access your reports as required. 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 2015?
Question: 3. What is the Revenue for E-Bike in 2014?
Question: 4. What is the Sales Quantity of T-shirts to Airport Bikes in 2012?
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 2012?
Question: 14. In 2013, 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 2014?
Question: 16. What material has had the highest Quantity sold?
Question: 17. Explain the annual revenue trends for the US and DE? 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 was the Materials 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:- Business analytics Practical Assessment.rar