Background Information Bibitor, LLC is a retail liquor company with over 75 locations throughout the state of Lincoln. They sell spirits and wine products. Bibitor, LLC has been serving the area for over 50 years. Their wine and spirits selection is hand-picked and focused on value. Their employees are trained as personal beverage concierges and provide unmatched service to all customers. There are over 12,000 brands throughout the organization. 2 Task The CFO has performed a review of Bibitor's overall gross margin percentage, and it appears reasonable based on the typical retail mark-ups for wine (50%) and spirits (30% - 35%). However, the CFO would like to identify whether any brands have gross margins that are negative or zero. She has asked for your help in finding the right data for this analysis. 3 Steps 1. Review the files in the folder "BibitorCaseData". For each file:

(a) What observational unit is identified in the file?

(b) What attributes do columns represent? What type of data is contained in these attributes? (e.g., is the data quantitative or qualitative?)

(c) What attributes can serve as "keys" for identifying observations of interest and combining data across tables?

1. What properties should a key have?

2. Select the data that are most relevant for the CFO's request.

3. Identify any data issues that might interfere with your analysis.

4. Is it possible that a product could have different sale prices at different locations? How would you determine if this is the case?

5. What will the final dataset you give to the CFO look like?