Skip to content

drusho/bigquery_liquor_sales

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Twitter profile link buttonLinkedin profile link buttonTableau profile link buttonGithub profile link button

Analyzing Iowa Liquor Sales with SQL

Exploring Public Datasets in Google BigQuery


About the Data

Data Source: data.iowa.gov

Provided by: Iowa Department of Commerce, Alcoholic Beverages Division

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

Class E liquor license, for grocery stores, liquor stores, convenience stores, etc., allows commercial establishments to sell liquor for off-premises consumption in original unopened containers.


Project Goals

Determine sales trends for city/counties

  • Popular items sold
  • Locations for highest sales
  • Dates of most sales

Sample of Data Collected






About

Using SQL to Analyze Iowa Liquor Sales

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published