Need help wit Tableau, as I'm working on final project. Please help! I am losing some of the data, when I plug sheets into tableau.

Option #2: Data Analytics Using Tableau

Refer toTableau(Links to an external site.). If you do not already have a login, please register.

On the next page is an Excel spreadsheet with the data for the ABC Company to use in this case.

Required:

1.Sort the file from largest to smallest Sales revenue. Determine a lower bound for the upper stratum. Defend your choice.

Largest to smallest in each year and then total (to see if lines up)

2.Assume that the ABC Company's FYE is 12/31/12. Check for appropriate sales cutoff. Identify any potential errors in sales revenue.

3.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 ABC Company? (region over time)

4.What month is the highest in terms of sales value? What is the year with the highest sales so far for the ABC Company?

5.Use the "Show Me" feature to determine which category of furniture sales yields the lowest profit, regardless of geographic location.

6.Learn about how to create 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?