For this capstone project, I conducted an in-depth analysis of the Northwind Trade Company dataset. The goal was to extract strategic insights that could improve the company’s operational efficiency, and profitability. I employed SQL, Python, and Power BI to query, analyze, and visualize the data.
I evaluated key performance indicators (KPIs) including Total Orders, Gross Sales, Net Sales, Total Quantity Sold.
These metrics helped in summarizing the company's overall performance, giving a top-down view of sales and profitability.
I analyzed customer data to determine the top 10 customers by order value, where Germany and the USA showed the highest number of customers. I also identified the best-selling products and visualized the sales distribution across product categories like Beverages, Dairy Products, and Confections.
- Analyzed sales volume, net profit, and discount rates per product category. Beverages and Dairy Products led in terms of profitability, contributing significantly to the company’s gross and net revenue.
- Visualized top 5 categories by total quantity sold and monthly sales trends to identify peak seasons and high-performing categories.
I examined the company's performance across 21 countries and 19 regions. Using SQL queries, I drilled down into each country to measure sales, shipping costs, and profit. Insights from this analysis allowed me to identify opportunities for expanding into regions with high growth potential.
The screenshots of the project are provided below:
