Updated Iowa Liquor Sales

Context

This dataset contains the spirits purchase information of Iowa Class “E” liquor licensees by product and date of purchase from January 2021 to January 2022. The dataset can be used to analyze total spirits sales in Iowa of individual products at the store level.

Content

The dataset contains of ~ 3M rows and 24 columns. The columns are:

1. invoice_and_item_number: concatenated invoice and line number associated with the liquor order. This provides a unique identifier for the individual liquor products included in the store order.
2. date: date of order.
3. store_number: unique number assigned to the store who ordered the liquor.
4. store_name: name of store who ordered the liquor.
5. address: address of store who ordered the liquor.
6. city: city where the store who ordered the liquor is located.
7. zip_code: zip code where the store who ordered the liquor is located.
8. store_location: location of store who ordered the liquor. The address, city, state and zip code are geocoded to provide geographic coordinates.
9. county_number: iowa county number for the county where store who ordered the liquor is located.
10. county: county where the store who ordered the liquor is located.
11. category: category code associated with the liquor ordered.
12. category_name: category of the liquor ordered.
13. vendor_number: the vendor number of the company for the brand of liquor ordered.
14. vendor_name: the vendor name of the company for the brand of liquor ordered.
15. item_number: item number for the individual liquor product ordered.
16. item_description: description of the individual liquor product ordered.
17. pack: the number of bottles in a case for the liquor ordered.
18. bottle_volume_ml: volume of each liquor bottle ordered in milliliters.
19. state_bottle_cost: the amount that alcoholic beverages division paid for each bottle of liquor ordered.
20. state_bottle_retail: the amount the store paid for each bottle of liquor ordered.
21. bottles_sold: the number of bottles of liquor ordered by the store.
22. sale_dollars: total cost of liquor order (number of bottles multiplied by the state bottle retail).
23. volume_sold_liters: total volume of liquor ordered in liters. (i.e. (bottle volume (ml) x bottles sold)/1,000).
24. volume_sold_gallons: total volume of liquor ordered in gallons. (i.e. (bottle volume (ml) x bottles sold)/3785.411784).

Acknowledgements

The dataset provided by https://data.iowa.gov/Sales-Distribution/Iowa-Liquor-Sales/m3tr-qhgy
Photo by John Hernandez on Unsplash

Inspiration

The dataset is a sample, so it could represent the liquor consumption behavior in the USA. Using the dataset, try to answer some of the following questions.

1. How was the trend of the number of bottles sold between January 2021 to January 2022?
2. How much revenue does Iowa make from the business each month? Which product drives the most sales?
3. How many stores ordered the liquor? Which store has the most order?
4. Are there any variations among regions in terms of the most popular product?
5. Are there any differences between product consumption in terms of the season?
6. How many bottles will Iowa sell in the next three months?