The primary objective of this project is to conduct an in-depth analysis of data from a sales records database, with the intent of extracting meaningful insights that can be employed to enhance decision-making processes.
- 🤓 Description
- 💻 Database Overview
- 📊 Exploratory Data Analysis
- 🚀 Business Questions
- ✨ Recommendations
- 📗 Notebooks
- 📧 Contact Information
The power of data analysis in the realm of sales is well-established, as it enables the derivation of essential Key Performance Indicators (KPIs), thereby fostering more informed and streamlined decision-making practices.
The Vehicle Distributors is a fictitious global wholesale distributor specializing in die-cast vehicle models, serving a diverse customer base across more than 15 countries. Our team has been entrusted with a significant dataset analysis project, aimed at assisting the company in making strategic decisions concerning prospective expansion efforts.
The primary goal of this undertaking is to comprehensively investigate the provided dataset and furnish well-informed responses, driven by data, to the questions posed by our client.
The database source file can found through the following link:
The scale model cars database contains eight tables:
| customers | employees | offices | orders | orderdetails | payments | products | productlines |
|---|
Click to check the scale model cars database schema:
The scale model cars database schema is as follows.
The database was accessed and explored using Python SQLite.
The following business questions will be addressed in the analysis
- Which products need more or less inventory?
- How can we tailor marketing to customer behaviors?
- What is the budget for acquiring new customers?
- Which countries should marketing prioritize for best returns?
After having analysed the data based on the queries put forward by the Vehicle Model Company, the following are the recommendations that we could make based on the insights we have gained.
-
To optimize inventory, classic cars and motorcycles should be prioritized for restocking due to high demand, while vintage cars and planes can be managed at a steady pace given even interest over time. For slow-moving deadstock, consider strategic price reductions to increase appeal and accelerate sales. Though counterintuitive, lower prices could reduce losses compared to prolonging costs by holding deadstock. This balanced approach can align inventory to demand and minimize financial burden of deadstock.
-
Personalized interactions and recognition of loyal customers can build long-term relationships and repeat business. For VIP customers, we can offer exclusive, tailored events and initiatives to increase satisfaction and loyalty. For less engaged customers, targeted campaigns based on their needs and preferences can reinvigorate interest in our brand.
-
We should prioritize marketing in North America (USA), Europe (Spain, France), and Oceania (Australia, New Zealand). Concentrating on these targeted markets can improve efficiency and pursue the most promising opportunities. This focused approach can enhance overall business performance
The Notebook for the "Exploratory Data Analysis" can be accessed below:
The Notebook for the "Business Questions" can be accessed below:
- Email: sean_dhanasar@msn.com
- LinkedIn: Sean Dhanasar