Maven Northwind & Traders

Tools used in this project
Maven Northwind & Traders

Northwind & Traders Dashboard

About this project

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 😊

Additional project images

Discussion and feedback(0 comments)