Northwind Traders challenge - Dashboard in Power BI

Tools used in this project
Northwind Traders challenge - Dashboard in Power BI

About this project

About this project

This challenge is made by Maven Analytics, where participants act as 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.

The target audiences are the executives, say, bosses. The purpose of this Dashboard is for the CEO to quickly catch what is going on in

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

The data is in the period of July 2013 - May 2015, so I assumed it is now May 2015. Since we only have data for half of 2013 and 2015, comparison between years are pointless. Instead, it should be compared month by month, or the compilation of available months. I have interpreted from the data that this company is in a growing state, since every month in 2015 have higher sales than that of 2014 .

I have found interesting facts from the interactive dashboard, though I am not the CEO.

  • In 2014, the lowest revenues recorded are in February, March, June and November
  • Beverages and Daily Products made up approximately 40% of the total revenues
  • Sales growth rates is in a downward trend
  • The average days to ship and costs of shipping are both on the lower end of their ranges
  • There are 3 big customers, namely Quick-stop, Save-a-lot Markets and Ernst Handel
  • The least sale products should be considered and taken action accordingly

This is my very first project on Maven, so please leave kind constructive comments. Thank you so much.

Additional project images

Discussion and feedback(0 comments)
2000 characters remaining