Case Study Type your name here: Use the GBI_Dataset within SAP Cloud Analytics to do the following assignment. My Files / Public / Models All files Search Name Description Owner ERPsim_Dataset ELINDOO GBI_Dataset.xIs ELINDOO Killings by Police.xlsx ELINDOO NOAA Fish Data.XLsx CRISMIHAILESCU Titanic_SAP ELINDOO NOTE: All screen shots must include your name or initials! To accomplish this, rename the page as shown below, where I renamed it to Lindool (circled in red). Also note that your screen shot needs to be full screen including the date and time! A Type bare to watch 2021 Dr. Ed Lindoo Page 1Case Study - its you complete this l-question exercise, keep adding pages so that you end up with a page for each question, as shown below, here we are on page 1D: FAILURE TO SUBMIT your work exactly Ii Ire this will result in a zero for the assignment with no makeups. Also note that all timestamps are logged within SAP Cloud. 30 if the dates and times don't match up with your timestamped logs. you will receive a ZERO for this assignment. lGlobal Bikes is a ctitious company that sells bicycles and accessories throughout Europe and the US. Now, as an analyst for Global Bikes you are asked to answer the following questions 2021 Dr. Ed Lindoo Page 2 Case Study Business Analytics 1 - Material with highest sales Exercise Over all years, which product had the highest sales in USD. What was the amount? Task Find the product that had the highest USD sales. (Hint, Use Revenue USD, Prod Descr 1. Please your answer and a screen shot of your work here. Business Analytics 2 - Total revenue in 2015 Exercise What was the total revenue for the company in USD during 2015? Task Display -using a column chart- the total sales revenue in year 2015. 1. Place your answer and a screen shot of your work here. 2021 Dr. Ed Lindoo Page 3Case Study Business Analytics 3 - Customer with over 10 million dollars purchase in 2018 Exercise Which customer(s) had purchased goods over 10 million dollars in 2018? Task Using a horizontal bar chart- which customers(s) had achieved a purchase proportion over 10 million dollars in year 2018. How much was their total purchases? 1. Place your answer and a screen shot of your work here. Business Analytics 4 - Products with no sales in the last 5 years Exercise Which product(s) had no sales data during the last 5 years of data? Task Using a text table- which product(s) had no sales data in 2015 thru 2019? 1. Place your answer and a screen shot of your work here. 2021 Dr. Ed Lindoo Page 4Case Study Business Analytics 5 - Quantity of materials sold per year Exercise Show the quantity of materials sold per year. What was the quantity of air pumps sold in 2018? Time 10 min Task Using any choice of graph- show the quantity of air pumps sold in 2018 1. Place your answer and a screenshot of your work here. Business Analytics 6 - Annual revenue trends in US & Germany Exercise For the US and Germany, are the annual revenue trends similar? Task Using an donut chart- display the revenue (not revenue USD) acquired by each year in both the US and Germany, then compare both results, What was the 2018 revenue and % of total revenue for Germany (DE)? What was the 2018 revenue and % of total revenue for the US? 1. Place your answer and a screen shot of your results here. 2021 Dr. Ed Lindoo Page 5Case Study Business Analytics 7 - Seasonality Exercise Seasonality in revenue is important in any business. Task Using a line chart show monthly revenues USD achieved across all years. What month has the lowest revenue and what is the amount? 1. Place your answer and a screen shot of your work here. Business Analytics 8 - Total revenue per customer Exercise What customer has given GBI the most revenue USD over all the years. What is that amount? Task Using a tree map- show the total revenue USD achieved by each user per year sorted from the smallest revenue to the highest. What was the revenue for highest buyer? 1. Place your answer and a screen shot of your work here. 2021 Dr. Ed Lindoo Page 6Case Study Business Analytics 9 - Most purchased product Exercise What was the most purchased product by Rocky Mountain Bikes? How much did they purchase over all the years? Task Using a horizontal bar chart- show in USD the product most purchased by Rocky Mountain Bikes. 1. Place your answer and a screen shot of your work here. Business Analytics 10 - Total revenue by country Exercise What was the most sold product by revenue, in both the US and Germany? Task Using any chart you like to show the revenue (revenue, not USD revenue) for the US and Germany. Your screen shot should be sorted from highest to lowest showing the one product that sold the most in the US and Germany over all the years. What was the product? (ProdDescry? What was the total revenue for US? What was the total revenue for Germany? 1. Place your answer and a screen shot of your work here. 2021 Dr. Ed Lindoo Page 7\f