Maven Northwind & Traders

Challenge Objective

For the Maven Northwind Challenge, you'll be 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.

As part of your role, you've been tasked with building a top-level KPI dashboard for the executive team. Its purpose should be to allow them to quickly understand the company's performance in key areas, including:

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

The dashboard should be built to evolve and accommodate new data over time, but you've been encouraged by your manager to have insights & recommendations ready to share with the VPs. This is your chance to impress!

About The Data Set

Sales & order data for Northwind Traders, a fictitious gourmet food supplier, including information on customers, products, orders, shippers, and employees.

My Approach

If I would be part of the executive team of Northwind & Traders I would be interested in the following figures

• Sales Performance (Revenue, Discounts, Total Orders)
• Development of Freight Costs (Total Freight Costs, Freight Costs per Month)
• Product Performance (Top Products, Flop Products, Status, Total Product)
• Employee Performance (Revenue Volume per Employee)
• Shipping Company Performance (Delays, Freight costs)
• And I would love to see on one glance the recent status of Revenue, Orders and Shipments (This month’s parameter)

So this is how the proposal of my dashboard looks like. I hope you’ll like it 😊