Liquor_sale (2017-2020)

Introduction

During a recent online search, I came across a comprehensive dataset detailing liquor sales spanning the years 2017 to 2020. Excited by the discovery, I saw it as a perfect opportunity to delve into the realms of data cleaning, analysis, and visualization. Eager to refine my skills in these areas, I eagerly embarked on this journey, aiming to extract valuable insights and refine my proficiency in handling real-world datasets.

Disclaimer: These datasets were used ONLY for practicing Tableau Public and Excel

Problem Statement

What would be the trends in liquor sales over the period from 2017 to 2020?

Which supplier has the highest quantity association with each type of liquor item?

What are the total liquor sales for each month throughout the year?

Any other relevant data insights

Skills Demonstrated

The following Tableau skills were incorporated:

Data Sources and Exporting, Dashboards, Advanced Visualizations including:

• Line graph
• Packed Bubble chart
• Horizontal Bar chart

Visualizations

Liquor Analysis based on the Total retail sales per year

In 2017, sales commenced at an average level, followed by a significant decline in 2018. However, in 2019, sales rebounded impressively, reaching their peak. Overall, 2019 recorded the highest sales figures across the years analyzed.

Conversely, in 2020, sales experienced a notable decrease. This alternating pattern of increase and decrease every other year warrants further investigation to understand the underlying factors driving these fluctuations. Analyzing the causes behind these rises and falls is crucial for devising strategies to mitigate downturns and capitalize on periods of growth.

Liquor Analysis Based on Max-Supplier and Item Type

Based on the data presented in the chart, it is evident that Z Wine Gallery Imports LLC consistently stands out as the leading supplier of wine across various shops. Their deliveries consistently surpass those of other suppliers, indicating a strong presence and likely dominance in the wine market.

This consistent performance underscores the significance of Z Wine Gallery Imports LLC as a key player in the wine supply chain, suggesting that they may have established strong relationships with the shops or possess competitive advantages in terms of product quality, pricing, or distribution efficiency. As such, businesses may benefit from further exploring opportunities for collaboration or partnerships with Z Wine Gallery Imports LLC to leverage their expertise and ensure a reliable supply of wine products.

Liquor Analysis based on Date and Item Type

Every year consistently sees wine, beer, and liquor occupying the top three spots in sales, with minimal differences between them. The leading spot alternates between wine, beer, and liquor, demonstrating their competitive edge.

In contrast, kegs, non-alcoholic beverages, and dunnage consistently show the lowest sales figures throughout each month across the years 2017-2020.

This trend underscores the enduring popularity of wine, beer, and liquor, while also highlighting areas for potential improvement or strategic focus in the sales of kegs, non-alcoholic beverages, and dunnage.

Dashboard

The data presented on the dashboard highlights wine, beer, and liquor as the most popular and frequently sold item types. These findings suggest that these products have a strong demand among customers. By strategically prioritizing the sale of wine, beer, and liquor, businesses can capitalize on this trend and potentially boost their sales revenue.

These item types are often associated with higher profit margins, making them particularly lucrative for businesses aiming to maximize their profitability. Therefore, directing resources towards promoting and selling wine, beer, and liquor may prove to be a successful strategy for increasing sales and driving overall profitability.

Conclusions/Recommendations

The datasets offer a comprehensive analysis of various liquor items sold between 2017 and 2020, providing valuable insights into sales trends over time.

To further assist company owners in boosting their sales, it would be beneficial to delve deeper into the trends of specific liquor item types during particular seasons or months. Understanding which products perform best during different times of the year can inform strategic decisions regarding inventory management, marketing campaigns, and product promotions. By leveraging this additional information, businesses can tailor their approaches to capitalize on seasonal fluctuations in consumer preferences and maximize sales opportunities.

Thank you!