Built with Tableau
An interactive dashboard where insights revealed that high-profit, low-sales items can outperform top sellers, reshaping business strategies.
What are the top performing items for a fine wine & spirits boutique?
Use data extracted from the shop's Point of Sale (POS) System to create an interactive dashboard highlighting the Gross Product Margin for each item and category as well as the ability to filter by category.
This dashboard created with Tableau visualizes the profitability of wines and spirits items alongside their respective categories over one year. This dashboard was created in direct response to a stakeholder's request for comprehensive insights for a fine wine & sprits boutique's sales performance.
I initiated the project by extracting two CSV files from the shop's Point of Sale (POS) System: one containing line item sales data for 2022 and one containing item category information. After eliminating unnecessary columns from the sales data table, I visualized total sales over time using a line chart ensure the data was complete for the entire year. I then transformed the item categories table from wide to long format using Power Query and then joined it with the sales data table in Tableau for a unified dataset.
The interactive dashboard visualizes item sales data for 2022 through a scatter plot and two bar charts which utilize Gross Profit Margin as a Key Performance Indicator (KPI).
Scatter Plot: The main visualization lays out individual items based on their gross profit and gross sales. This visual representation enables stakeholders to identify high-profit, low-sales items and vice versa, all in a single glance.
Bar Charts: The dashboard includes two bar charts that showcase gross sales by category and by item. This dual perspective empowers stakeholders to assess the category's financial impact while also diving into individual item performance.
KPI: Gross profit margin was chosen as the key performance indicator due to its ability to provide a comprehensive and standardized measure of profitability, accounting for both revenue and cost factors. The dashboard quantifies this critical KPI and represents it through a range of colors.
Color Scheme: I chose an orange-blue diverting color scheme for its heightened contrast and accessibility, ensuring that users can easily interpret and draw insights from the visualizations. This visual gradient provides an instant understanding of profitability, with shades transitioning according to increasing gross profit margin.
Item and Category-Level Insights: The dashboard equips users with the power to filter data by item and category, offering a granular view of each item's financial performance. With this feature, stakeholders can focus on specific products to uncover nuanced trends and patterns.
Informative Tooltips: To enhance the user experience, tooltips pop up as you hover over scatter plot points or bar chart elements. These tooltips present more intricate details, such as the gross product margin as a percentage and the quantity sold for each item.
In summary, the Wine Shop Profitability Visualization underscores my expertise in data exploration, transformation, and interpretation, facilitating informed business decision-making. Notably, the analysis revealed that the Molino a Vento Pinot Grigio, despite lower gross sales, generated more profit than the top-selling Tito's Vodka, which had a paltry 12% gross profit margin. This revelation prompted a strategic shift by the stakeholder, optimizing resource allocation based on data-driven insights. I invite you to navigate the visualization for a comprehensive understanding and welcome further discussions to explore this project's nuances.