Global Gourmet Insights: Maven Northwind Project

The Maven Northwind Project was undertaken to drive business growth and enhance decision-making in the gourmet food industry. Through thorough analysis of sales, shipping, and product performance data, the project aimed to uncover key insights that would guide strategic initiatives and improve overall profitability.

Key Insights: The project yielded several key insights that shaped decision-making and strategy:

Gross Revenue:** The company's gross revenue was calculated to be $1.27 million.

United Package: United Package emerged as the shipping partner with the most frequent order delays and high freight costs. Addressing these issues would be crucial to improve customer satisfaction and reduce shipping expenses.

Sales Trends: The overall sales trend showed a decline, with a significant dip in business after 2015 Q1. Further analysis was recommended to identify any external factors that may have impacted sales during this period.

On-Time Delivery and Cost: The company consistently achieved a 95% on-time delivery rate to customers. However, the average cost of delivering an order had been increasing over the years, highlighting the need to optimize delivery processes and reduce costs.

Shipping Partners: Among the three shipping partners, Federal Shipping emerged as the best-performing partner. Leveraging this insight, the company could negotiate favorable terms and strengthen its partnership with Federal Shipping.

Top Sales Categories and Products: The top three sales categories were Beverages, Dairy Products, and Confections, accounting for approximately 53% of the total sales. Within these categories, specific products such as Cote de Blaye (Beverages), Thuringer Rostbratwurst (Meat & Poultry), and Raclette Courdavault (Dairy Product) stood out as top performers, contributing to 23% of the total sales.