In this mini project I analysed data of an eCommerce company. Because of the need to significantly increase inventory of the most profitable clothing items for the next season, I created a PowerBI dashboard and made recommendations based on my analysis as requested by the head of data and insights.
Summary
My conclusions: most profitable clothing items of all times are Full-Finger Gloves, Women’s Tights, Men’s Bib-Shorts, Men’s Sports Shorts, and Long-Sleeve Logo Jersey. The only challenge I had while working on this project was time, as I had only one day. Data was provided by the head of data in Excel format.
Data Manipulation
After making sure that all the variable types are suitable for the analysis, I used Power BI to create a ‘Profit’ variable using the following formula
• Profit = Squiddle_Sales[Quantity]XSquiddle_Sales[ProductPrice]-Squiddle_Sales[Quantity]XSquiddle_Sales[ProductCost]
Analysis
I created a bar chart displaying the top 5 most profitable items: Full-Finger Gloves, Women’s Tights, Men’s Bib-Shorts, Men’s Sports Shorts, and Long-Sleeve Logo Jersey. Next, I generated a table that includes product SKUs (with sizes), keys, product names, colors, and total profits. Finally, I designed a grouped bar chart to visualize the product names and their profits over time. The dashboard is interactive, allowing us to click on the bars and refer to the table for the product information (SKUs, color, size, etc.) regarding Q2 and Q3 stock, for example.
Dashboard
Recommendations:
• Most profitable clothing items of all times are Full-Finger Gloves, Women’s Tights, Men’s Bib-Shorts, Men’s Sports Shorts, and Long-Sleeve Logo Jersey
• To increase inventory of the most profitable clothing items for Q2 2023, we need to order Full-Finger Gloves, black S, M, L sizes, Men’s Sports Shorts, black S, M, L sizes, Long-Sleeve Logo Jersey, multi colour, M, L, X sizes
• For the autumn collection (Q3), we will need Women’s Tights, black, S, M, L sizes, Full-Finger Gloves black S, M, L sizes, and Men’s Sport Shorts black, S, M, L sizes.
Interactive Dashboard
Banner photo source: pathdigital/Unsplash