Northwind Traders Dashboard

The objective of this project is to enable the executive team to quickly understand the company's performance in key areas including sales trends, product performance, key customers and shipping costs and make informed decisions based on meaningful insights.

Sale trends: The company made the highest revenue in April which corresponds to 9.7% of the net revenue. The executive team should strive to understand the factors driving high sales in April and also develop effective sales and marketing strategies such as carrying out targeted monthly campaigns in order to replicate that success in other months.

Product Performance: Côte de Blaye being the top performing product and contributing 11.1% of the net revenue, the executive team should ensure there's adequate supply of this product to meet the demand. They should also focus on potentially expanding the product line to capitalize on its popularity.

Key customers: QUICK- stop, Ernst Handel and Save-a-lot Markets being our key customers, they contribute significantly to the net revenue that is 8.68%, 8.26% and 8.21% respectively. The executive team should focus on understanding their needs and preferences, providing personalized services and implementing other strategies to ensure continued loyalty. Prioritizing and maintaining strong relationships with these key customers will result in overall business growth due to customer retention.

Shipping cost: The company is spending more on shipping using United Packages, It is essential to negotiate better rates with the carrier or evaluate alternative shipping options. This will help in optimizing shipping cost and reduce overall expenses.