This repository showcases the business overview of Headie's Store, covering two key departments: the Sales department and the Logistics department. It provides in-depth insights into the store's operations and performance, highlighting crucial metrics and trends that drive the business forward.
A high-level summary of key sales metrics, including total quantity ordered, total revenue, profit generated, and customer count, all of which showed upward trends from 2019 to 2022. This interactive dashboard also highlighted the top-performing States/Provinces by revenue, regions generating the most profit, and sub-categories with the highest sales, such as products under the Chairs Category, and the Copier product leading in profit. The dashboard provided monthly breakdowns for deeper analysis.
Offering a detailed look into logistics performance, this dashboard provided insights into total orders received, shipments sent, shipment modes, and cities served. It also highlighted the most preferred shipment modes, States/Provinces with the most orders, and the top product categories and sub-categories by order volume. Additionally, the dashboard displayed the top 10 customers with the highest orders, in line with the CEO's goal to celebrate these loyal customers.
November: A Record Month for Sales
November stood out as the highest sales month for Headie’s Stores, with a remarkable $352,666 in revenue. The line chart revealed November as a peak period, likely influenced by successful marketing initiatives, seasonal demand, or increased customer engagement during the festive season.
Regional Profit Insights
The West Region, including states like California and Washington, was the top profit generator for Headie’s Stores, bringing in $111K. A significant boost in profit occurred between 2021 and 2022, with profits rising from $24K to $45K. This growth was fueled by the addition of over 150 new products, with the Copiers sub-category leading in profit with a value of $19k, followed by Accessories and Binders, each contributing $16K.
Central Region, including states like Texas and Illinois, generated the least profit at $40K and had the highest discount amount among all regions, totaling $563. It was also the only region to record losses in two sub-categories: Furniture and Appliances, with losses of $4K and $3K, respectively.