Superstore managers are interested in your feedback on the following questions. For each question you need to
Question:
Superstore managers are interested in your feedback on the following questions. For each question you need to create a separate worksheet in Tableau using the SuperStoreOrders data (use the one attached to this assignment, not the one we used during the lectures). (20 Marks)
1. At which months in 2013 Superstore had the lowest and highest number of total sales for each product category?
2. What is the overall percentages of “Shipped Late”, “Shipped On Time”, and “Shipped Early” orders in state of Texas ? (Assume that Same Day, First Class, Second Class, and Standard Class shipping is expected to take 1, 2, 4, 6 days to process, respectively) Hint: you need to compare the actual ship dates with the expected ship dates to determine if the shipment is on time, early, or late.
3. Which state(s) has the highest percentage of “Shipped On Time” orders? Which region(s) has the lowest percentage of “Shipped Late” orders in 2014?