Sportswear Sales Dashboard

Overview/Context:

• This project analyzes sportswear product sales across regions, sales channels, and retailers from 2020 to 2021, aiming to identify performance trends, highlight areas for improvement, and uncover opportunities to enhance sales. The analysis was fully conducted in Power BI, which was used for data processing and analysis. An interactive Power BI dashboard was created to present the findings: Link

Dataset:

• The dataset comprises sales records with the following features: City, Invoice Date, Operating Margin, Operating Profit, Price per Unit, Product, Region, Retailer, Retailer ID, Sales Method, State, Total Sales, and Units Sold. It spans a two-year period (2020–2021), capturing transactions across various sales channels and regions, with total sales of $89.99 million and 2.48 million units sold.

Data Preprocessing:

• Data cleaning was performed within Power BI using Power Query. Steps included handling missing values through removal, eliminating duplicate entries, and standardizing date formats to ensure consistency across the dataset for accurate analysis.

Business Questions:

• What are the total sales and units sold over the analysis period?

• How do sales vary by season, sales channel, and region?

• Which retailers and products are top performers, and which are underperforming?

• What are the sales trends across different states?

• How can sales performance be improved in low-performing areas?

Visuals

Overview

Insights

Insights:

• Sales Overview: Total revenue reached $89.99 million, with 2.48 million units sold over 2020–2021.

• Seasonal Trends: Sales peaked in July at $9.5 million and dipped in March to $5.6 million, indicating seasonal variations.

• Sales Channels: In-store sales led with $35.66 million (849.78K units), followed by outlets at $29.56 million (689.9K units), and online at $24.77 million (939.09K units).

• Top Retailers: West Gear and Foot Locker generated $24 million and $22 million, respectively, while Walmart lagged at $7 million.

• Popular Products: Men’s Street Footwear topped sales at $20.88 million, followed by Women’s Apparel ($17.9 million) and Men’s Athletic Footwear ($15.3 million).

• Geographic Performance: New York, California, and Florida were the top states, while Nebraska, Minnesota, and Iowa underperformed.

Recommendations:

• Targeted Promotions: Launch marketing campaigns in underperforming regions like Nebraska, Minnesota, and Iowa, offering seasonal discounts to boost sales during low months like March.

• Sales Channel Optimization: Enhance online marketing through social media and influencer partnerships to increase online sales, which currently lag behind in-store performance.

• Retailer Collaboration: Strengthen ties with underperforming retailers like Walmart by offering exclusive products or hosting promotional events to attract customers.

• Product Bundling: Pair popular items like Men’s Street Footwear with underperforming products (e.g., Men’s Apparel) to encourage broader purchases.

• Customer Feedback: Implement a feedback system via surveys or focus groups to understand underperformance and inform product and marketing strategies.

• Seasonal Planning: Optimize inventory and promotions for low-sales months like March, ensuring stock aligns with seasonal demand patterns.

Conclusion:

• This Power BI analysis highlights key sales trends, with in-store channels and top retailers like West Gear leading performance, while identifying growth opportunities in underperforming regions and products. The interactive dashboard provides an accessible overview for stakeholders, laying a foundation for strategic improvements to drive sales and operational efficiency.