Maven Northwind Traders Challenge

Required Task :

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!

1. Sales Trend :

• Calculated the revenue(Gross) from multiplying the Quantity sold and unit price of each product. So total revenue would be the sum of gross which is around 1.35 millions.
• Total sales(sum of net revenue) can be calculated from : For this calculate the Net revenue which is the difference of Gross and Discount.
• In the order details table we are having two columns named unit price and quantity. So just insert a new column named as Gross for gross revenue which is unit Pricequantity sold. One more column is discount change the type as percentage and calculate the discount in dollars as the result of grossdiscount%.
• After this net revenue = Gross - Discount $
• Plotted two visuals for the sales trend one having category wise total sales and other one showing monthly sales.

Insights -

Beverages have the highest sales around 2,67,868.18**** which is 0.27 millions

In the month of April the orders were highest with a sale of 0.19 millions

2. Product Performance :

• Total products are 77 (Count of Product ID) and total quantity sold is 55 K.
• You can see the top 5 products from the pie chart which is having product name and top 5 filter according to sum of net(i,e total sales).

Insights -

Cote de Blaye have highest sales around 0.14 million

3. Key Customers :

• Total customers are 91(count of customer ID) and total orders placed are 830(count of order ID)
• You can see the top 5 customers from the pie chart which is having customer name and top 5 filter according to sum of net.

Insights -

Horst Kloss is the number one customer having 0.11 million revenue.

4. Shipping Costs :

• There are three shipping companies having Total shipping cost of 64.94 K
• Shipping cost per company is calculated as sum of freight vs shipping company name. From the donut charge we can see shipping costs of companies.

Insights -

United Package have the highest shipping cost of around 28.24 K.

5. Other useful insights :

• The dashboard is having a dropdown for employee name, category name and product name. From there you can select for a particular or multiselect as per as your choice.
• Drop down for day and month of the order placed and tiles for years.
• You can also calculate the time taken for shipping from the difference of ordered date and shipping date.