Welcome to DataInsights
Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
Mint Classics - Model Car Database -Anaylze Done using MySQL - R Markdown Report
Project type
MySQL , R Markdown(Report)
Date
Dec 2023
Github Link
Analysis Report Link
Business Talk
1. Are there products with high inventory but low sales? How can we optimize the inventory of such products?
2. Are all the warehouses currently in use still necessary? How can we review warehouses that have low or inactive inventory?
3. Is there a relationship between product prices and their sales levels? How can price adjustments impact sales?
4. Who are the customers contributing the most to sales? How can sales efforts be focused on these valuable customers?
5. How can the performance of sales employees be evaluated using sales data?
6. How can customer payment trends be analyzed? .
7. How can the performance of various product lines be compared? Which products are the most successful, and which ones need improvement or removal?
8. How can the company’s credit policies be evaluated? Are there any customers with credit issues that need to be addressed?
Mint Classics Company, a retailer of classic model cars and other vehicles, is looking to close one of its storage facilities. To make a data-based business decision, the company wants suggestions and recommendations for reorganizing or reducing inventory while maintaining timely customer service. As a data analyst, you will use MySQL Workbench to familiarize yourself with the general business by examining the current data and isolating and identifying those parts of the data that could be useful in deciding how to reduce inventory.
Objectives:
1. Explore products currently in inventory.
2. Determine important factors that may influence inventory reorganization/reduction.
3. Provide analytic insights and data-driven recommendations.
