This dashboard analyzes kids' toy sales across different countries using data sourced from Kaggle. It was one of my first projects in Excel, and I dedicated significant effort to making it visually appealing and insightful. I revised it several times until I was completely satisfied. Working on this project taught me a lot about data visualization and storytelling. You can access and explore the dashboard through my OneDrive click the link below if you'd like to dive in.
The dashboard showcases global toy sales, highlighting countries with high sales volumes and cities contributing significantly to revenue. It provides a detailed view of monthly sales trends, product performance, and top customer purchases. Visualizations of order statuses and deal sizes offer insights into operational efficiency and customer preferences, creating a well-rounded analysis of the toy sales business.
Click here: Interactive dashboard of sales data
Total Sales Country-wise
The USA leads in total sales by a significant margin compared to other countries across the years (2003–2005).
Countries like Spain, the UK, and Germany show moderate sales levels.
Many countries exhibit consistently low sales figures.
Total Order Quantity
Classic Cars dominate the total order quantity, with 967 units sold.
Other significant categories include Vintage Cars (607 units) and Motorcycles (331 units).
Categories like Trains and Planes have the lowest quantities sold.
Order Status
The majority of orders (93%) are shipped, showcasing efficient order processing.
A small percentage of orders are either on hold, canceled, or marked as resolved, reflecting minimal operational issues.
Top 7 Cities with Highest Sales
Madrid and San Rafael are the cities with the highest sales figures, followed by NYC.
Cities like Singapore and Paris have moderate sales, while San Francisco and New Bedford have the lowest among the top 7.
Best Customer by Total Purchase
The Euro Shopping Channel and Mini Gifts Distributors Ltd. are the top customers by total purchases.
Other customers, such as Australian Collectors Co. and Land of Toys Inc., contribute significantly but are far behind the top two.
Total Sales of Each Product
Classic Cars generate the highest sales revenue among products, followed by Vintage Cars and Motorcycles.
Products like Trucks and Buses and Planes show moderate revenue levels.
Product Insights
Classic Cars: Best-selling product with:
💰 Total sales exceeding $3.9 million.
📦 967 orders, mostly in the medium size category.
Vintage Cars: Second-best with:
💰 $1.9 million in sales from 607 orders.
ℹ️ Average deal size is three times smaller than classic cars.
Trains: The lowest-performing product with:
📦 Only 77 orders resulting in $220k in sales.