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.
- Building a top-level KPI dashboard for the executive team with the purpose to allow them to quickly understand the company's performance in key areas, including Sales trends, Product performance, Key customers, and Shipping costs
- To give insights and recommendations to the VPs.
According to the data given, the dashboard will show performance in sales, customers, employee, and shipping segments. The performance was evaluated in two ways;
a) By comparing the current situation with the previous one
- Sales of products in current month vs. previous month
- Customer value in current month vs. previous
- Average Freight change in current quarter vs. previuos
b) By developing KPI's and measuring against them
- Sale KPI - $60,000 per month
- Customer KPI - 1 new customer per month
- Employee KPI - 7 days lead time per order
Click the image to interact
- Sales have dropped from May to December
- Generally Products in beverages and dairy products categories have high sales while grain & cereal, produce, and condiments products have poor sales. Beverages have an increase of 22.13% from previuos month
- Number of new customers have been dropping from year to year. 2013 had 67 new customers and 2014 had 21 new customers
- Generally Customer value has increased by 1.47%
- Average lead time is below the target, 8 days of lead time per order
- Speedy express have lower average shipping cost compared to others
- Average shipping cost is expected to rise to $282.36 from $249.77
- Reconstruct Marketing strategy. This is because the Sales have dropped and number of new customers is declining. The management have to reconstruct the marketing strategy to return on track
- The company should consider to use speedy express because they have low average freight and it may be conducive in the coming year since the cost is expected to rise.