Part II ( Diculty : Beginner/Intermediate) The Bibitor, LLC CFO wants some additional analysis using ***Tableau****. She is interested in dierences between wine and spirits across the entire organization. She wants to know the dierences in Sales Dollars and Quantities between the two categories, popular bottle sizes for wine and spirits, and the most popular vendor for wine and spirits. She is also interested in certain information at the Store level of detail. Required: Assist the CFO in creating Worksheets and Dashboards to answer these questions: What is the total Sales Dollars and percentage breakdown of wine and spirits? Hint: Use the Classification and Sales Dollars to separate the sales based on wine and spirits. Convert the data into a Pie Chart (Show Me Tab) and the Analysis Tab to convert data to percentages. What is the most popular Size for wine and for spirits based on Sales Dollars and Quantity (include the total Sales Dollars and Quantity in your answer)? Provide the CFO with some reasons why this is important for managing the business. Who is the most popular Vendor for wine and for spirits based on Sales Dollars and Quantity (include the total Sales Dollars and Quantity in your answer)? Provide the CFO with some reasons why this is important for managing the business. Which Stores have the highest and lowest weighted average sales price for wine and spirits? How does the weighted average sales price compare to a simple average of Sales Prices for SKUs (Brands) in each Store? What does a large dierence between the simple average and the weighted average mean? Hint: Create a Calculated Field (Analysis Tab) and label it Average Sales Price. To accomplish this, drag the Sales Dollars pill divided by Quantity pill. You should see the Average Sales Price pill. Drag the Average Sales Price pill into columns and convert the variable from SUM to AVG by using the Dropdown Menu on the Pill . Drag the Classification pill into the Filter Card to help you determine the Average Sales Price for wine versus spirits. What seasons/months are sales the highest and lowest? Provide the CFO with some reasons why this is important for managing the business. If you were the CEO or CFO, what other data/variables would you want to collect to improve your business and why?