Northwind Trader Challenge

1️⃣ Total revenue: By multiplying unit_sold, quantity, and freights, we can calculate the total revenue generated by Northwind Traders.

2️⃣ Total sales: Multiply quantity and unit_sold to find the total sales figure, giving us a comprehensive view of the company's performance.

3️⃣ Total quantity of product sold: Count the occurrences of quantity to determine the overall quantity of products sold.

4️⃣ Number of Shippers: Count the unique values in the shipper column to ascertain the number of shippers the company engages with.

5️⃣ Total Orders: Count the occurrences of orders to gain insights into the overall number of orders processed by Northwind Traders.

6️⃣ Monthly Customer Activity: Identify the number of customers who placed orders in each month to analyze trends and patterns in customer behavior.

7️⃣ Top Customers: Discover the customers who placed the most orders over the past three years, highlighting the most loyal and valuable clientele.

8️⃣ Valued Customers: Uncover the nine customers with the highest order volumes, showcasing Northwind Traders' top accounts.

9️⃣ Employee Performance: Track orders processed by employees over the past three years to evaluate individual performance and efficiency.

🔟 Company Performance: Analyze the total orders processed by each company, shedding light on their contribution to Northwind Traders' success.

1️⃣1️⃣ Employee Contribution: Explore the number of total orders processed by each employee, recognizing their impact on the company's operations.

1️⃣2️⃣ Product Sales Contribution: Calculate the percentage of product sales in the total revenue, demonstrating the significance of different products in driving company growth.

Link to Dashboard:https://lnkd.in/dX95XyQ8