Required information

Skip to question

Lab Note: The tools presented in this lab periodically change. Updated instructions, if applicable, can be found in the eBook and lab walkthrough videos in Connect.

Case Summary: Sl$$inte is a fictional brewery that has recently gone through big changes. Sl$$inte sells six different products. The brewery has only recently expanded its business to distributing from one state to nine states, and now its business has begun stabilizing after the expansion. Sl$$inte has brought you in to help determine potential areas for sales growth in the next year. Additionally, management have noticed that the company$$s margins aren$$t as high as they had budgeted and would like you to help identify some areas where they could improve their pricing, marketing, or strategy. Specifically, they would like to know how many of each product were sold, the product$$s actual name $($not just the product code$),$ and the months in which different products were sold.

Data: Lab $2-2$ Slainte Dataset.zip $-83$KB Zip $/90$KB Excel

Note: Submit your answers for the following Analysis Questions in the text entry field below.

Now that you$$ve completed a basic analysis to answer management$$s question, take a moment to think about how you could improve the report and anticipate questions your manager might have.

AQ$1.$ If the owner of Sl$$inte wishes to identify which product sold the most, how would you make this report more useful?

AQ$2.$ If you wanted to provide more detail, what other attributes would be useful to add as additional rows or columns to your report, or what other reports would you create?

AQ$3.$ Write a brief paragraph about how you would interpret the results of your analysis in plain English. For example, which data points stand out?

AQ$4.$ In Chapter $4,$ we$$ll discuss some visualization techniques. Describe a way you could present these data as a chart or graph.