Auditing
Sort the file from largest to smallest Sales revenue. Determine a lower bound for the upper stratum. Defend your choice.
Assume that the ABC Company’s FYE is 12/31/12. Check for appropriate sales cutoff. Identify any potential errors in sales revenue.
Use Tableau to determine the market segment of sales by product category and consumer market region. What category of product has the highest sales volume?
What category has the lowest sales volume? What are the top two regions in the world for sales volume of consumer office supplies? Which market region is an emerging market for Superstore Sales?
What month is the highest in terms of sales value? What is the year with the highest sales so far for the ABC Company?
Use the “Show Me” feature to determine which category of furniture sales yields the lowest profit, regardless of geographic location.
Learn about how to create a forecast in Tableau using the following link (and associated webinar): Forecasting with Tableau (Links to an external site.).
Assume that you wish to develop an expectation to compare likely sales levels by month across the three product categories, that is, furniture, office, and technology.
What is your forecast of sales for FYE 2013 for each of these categories? How would you use these forecasts as compared to actual FYE 2013 amounts as asserted by management?