MAVEN Northwind Challenge!

About this project

For the Maven Northwind Challenge, I am working as a BI Developer for Northwind Traders, a global import and export company that specializes in supplying high-quality gourmet food products to restaurants, cafes, and specialty food retailers around the world.

I have created this dashboard, which will give a quick understanding to the manager about the company's performance in key areas, including:

• Sales trends
• Product performance
• Key customers
• Shipping costs

Insights & Recommendations

The sales trend clearly shows that over the period it has grown, but there is huge decline in sales from April 2015 to May 2015. The forecast for the next 6 months shows steady growth.

The top 3 categories are Beverages (21.15%), Dairy Products (18.56%) and Meat & Poultry (13.16%) which provided almost 53% of the total sales of the company.

The top 3 performing products are Cote de Blaye of beverages (11%), Thuringer Rostbratwurst of meat & poultry (6.48%) and Raclette Courdavault of dairy products (5.63%) which provided 23% of the total sales. These products are liked by people across Germany, USA, Austria, Brazil, continue to be the key spots. The company should continue to promote these products and can seek new markets for this product to grow in other regions.

Bottom 3 performing products are Genem Shouyu (of Condiments), Geitlost (of Dairy Products) and Chocolade (of Confections). The company should take measures to improve its sales for these products by working on consumer feedback, check why these products are having the least sales and take steps to improve them.

QUICK STOP of Germany, SAVE- A -LOT MARKETS of USA and ERNST HANDEL of Austria are the key customers in general results. Managing and expanding the relation with them can give huge profits in the long run to the company, as they provide a big income.

The best shipping company is Speedy Express with delivery before time at 96.12% of the total deliveries whereas Federal Shipping had 94.69% and United Package had 93.32%. So, the Speedy Express company is best for the deliveries.