Question

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 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?

Answer 1

- Sno Differences Wine Spirit Wine Bottle Spirit Bottle Particulars Size A Size B Size A Size B Sales in $ Sales In QTY Sales in $ Sales In QTY Sales in $ Sales In QTY Sales in $ Sales In QTY April May June July August September October November December MS U1

Differences

Wine is an alcoholic beverage made by the fermentation of fruits. The most common fruit used in the production of wine is the grape, but a variety of other fruits are sometimes used. The process of wine production, known as winemaking, is as follows: fruits are crushed, releasing the juice. The juice is then fermented with yeast, and then bottled to be drunk. There are three main types of wine: white wine, red wine, and rosé wine, all three of which are pictured above.

Spirits are also called hard liquors, distilled beverages, and liquors, are alcoholic beverages made by distilling a fermented product. The fermented liquid, usually called a mash, made out of grains or other substances, is then put into a heated container, known as a still. The alcohol evaporates first, and the machine is then cooled to collect the drops of alcohol. Spirits include whiskey, gin, vodka, and brandy. A variety is pictured above.

Wine Spirits Made by fermenting fruits. Made by distilling a fermented product. Made from fruits. Made from a mash. Lower alcoholic content. Higher alcoholic content.

Wine has demand throughout the year and spirit has high demand during the winter months. because people consume more alcohol.

Other variables considered

1) Price of our product against competitors and discounts offered - for competitive pricing

2) Product differentiation - how our product is different from others

3) Advertisements - to improve brand image

4) Incentives for marketing team - boosts performance thereby increases sales