Embedded Files
Mint Classics is a retailer of classic model cars exploring options to close one of its storage facilities. As part of this initiative, they need data-driven insights to reorganize or reduce inventory while ensuring timely delivery (within 24 hours of an order being placed).
Role:
Role:
As the data analyst, my mission was to explore the company's inventory and sales data using SQL to uncover key patterns and generate actionable recommendations.
Objectives:
Objectives:
Explore products currently in inventory.
Identify factors influencing inventory reorganization or reduction.
Provide insights and recommendations supported by data.
Tools Used:
MySQL Workbench | Power BI
Tools Used:
MySQL Workbench | Power BI
MySQL Workbench
MySQL Workbench
Data extraction and exploration
Using SQL queries, I explored MintClassics inventory, sales, and warehouse data to identify key trends and isolate products with low turnover or redundant storage.
Insight: Enabled discovery of underperforming items and warehouses with overlapping inventory.
Power BI – Regression Analysis
Power BI – Regression Analysis
Sales performance prediction
This scatterplot regression shows how sales volume correlates with inventory levels.
Insight: Helped identify which products have matching sales trends, supporting stock level justification and streamlining.
Power BI – Inventory Bar Chart
Power BI – Inventory Bar Chart
Identifying high- and low-stock products
This visualization highlights quantity in stock across all product lines.
Insight: Guided the decision on which lines could be trimmed or redistributed across fewer warehouses.
Explore the Full Interactive Dashboard Here
Power BI – Key Influencer Analysis
Power BI – Key Influencer Analysis
Understanding drivers of sales
This Key Influencer visual reveals what factors most affect order volume.
Insight: Helped isolate product lines and models worth keeping or retiring based on customer behavior.
Power BI – Decomposition Tree
Power BI – Decomposition Tree
Breaking down total stock by category, line, and product
This interactive visual shows how inventory is distributed across categories.
Insight: Identified potential consolidation opportunities and outliers that may be removed or relocated.
Page updated
Google Sites
Report abuse