Maven Northwind Traders - Performance Report

Business Goal :

The business goal of the Maven Northwind Challenge was to develop a dynamic KPI dashboard for Northwind Traders' executive team, enabling them to monitor and analyze sales trends, product performance, key customers, and shipping costs. The dashboard provides a comprehensive view of the company's performance, facilitating informed decision-making, and is designed for scalability to accommodate future data updates and evolving business needs.

Significant Observations :

Sales Trend:

• The Total sales demonstrated a significant upward trend, increasing by 83.01% between July 2013 and April 2015.
• During this period, the Total sales experienced its steepest incline, jumping from 84,441 to 154,538 units.
• The upward trend in Total sales started in July 2013 and continued for 7 quarters.

Product Performance:

• Côte de Blaye emerged as the top-performing product with a Total sales of 149,987, surpassing Tarte au sucre by a margin of 200.99% (Total sales: 49,832).
• Côte de Blaye accounted for 36.22% of the company's total sales.
• Across all 5 products, the Total sales ranged from 49,832 to 149,987 units.

Shipping Performance:

• Shipping costs exhibited an upward trend, experiencing an 85.85% increase between July 2013 and April 2015.
• The steepest incline in shipping costs occurred during this period, rising from 3,808.83 to 7,078.65 units.

Key Customers:

• The top 5 customers generated total sales ranging from 52.25K to 117.49K, accounting for approximately 33.6% of the company's overall sales.

These insights indicate positive sales growth, product performance variations, shipping cost trends, and the significance of key customers in driving sales. Based on these findings, the executive team can make informed decisions and strategize for continued success.