Gabriella final project
https://gabriellagonzales.quarto.pub/gabriella-final-project/
This project is based on the Mixed Beverage Gross Receipts dataset, which is collected by the Texas Comptroller of Public Accounts and published on the Texas Open Data Portal, which uses the Socrata service. It captures monthly alcohol sales data across establishments, categorized by Total Receipts, Wine Receipts, Beer Receipts, Liquor Receipts, and Cover Charge Receipts. Each row represents monthly sales for a specific location. It includes variables detailing taxpayer (owner) and location (establishment) information and allows for trend analysis by location, type of alcohol and geographical area.
Summary
I plan to explore seasonal and monthly sales fluctuations in alcohol sales over the last five years in Austin neighborhoods. I will analyze how alcohol sales change through the year, how these changes correlate with seasonal factors and which neighborhoods are affected by these fluctuations. This analysis will also examine how major events throughout the years, like SXSW and ACL impact sales across neighborhoods. To further this analysis, I will break down sales by alcohol type and identify if any drive more revenue in different areas and seasons.
News lede
A new analysis of alcohol sales data from the Texas Comptroller of Public Accounts from 2019 to 2023 reveals rising sales in Austin, with October marking the city’s peak. The study, which examines monthly and seasonal sales trends across various neighborhoods, shows notable spikes in alcohol sales during events like SXSW and ACL. With liquor consistently driving the highest revenue year-round, the data offers insight into how both seasonal factors and major events influence alcohol sales in Austin’s neighborhoods.
Data takeaways
- On average, Austin sees the highest average alcohol sales in October. The city sees the average lowest alcohol sales in January.
- Average alcohol sales in Austin have risen by about 34% between 2019 and 2023, despite a dip in sales in 2020.
- Liquor drives the most revenue in Austin year-round, with spikes during March and October which host SXSW and ACL, respectively.
- On average, the ZIP codes 78701, 78704 and 78758 sell the most alcohol, respectively.
- On average, the ZIP codes 78774, 78713 and 78742 sell the least amount of alcohol, respectively.
- Austin sells the most alcohol in the 78701 ZIP code based on average sales data from the Texas Comptroller of Public Accounts between the years 2019 to 2023.
- The ZIP codes 78712, 78736 and 78713 make the highest average contributions to alcohol sales during October.
- The ZIP codes 78704, 78736 and 78712 made the highest contribution to alcohol sales during October 2023.
- The ZIP codes 78742, 78728 and 78713 make the highest average contributions to alcohol sales during March.
- The ZIP codes 78728, 78742 and 78739 made the highest contribution to alcohol sales during October 2023.
Data charts
