Maven Northwind Challenge | Maven Analytics Project
Introduction:
This project is a submission for the #mavennorthwindchallenge conducted by Maven Analytics. As a BI developer at Northwind Traders, I have been given the exciting responsibility of creating a comprehensive KPI dashboard for our executive team. This dashboard will serve as a valuable tool for them to gain quick insights into our company's performance across various crucial areas. These areas include:
- Sales trends
- Product performance
- Key customers
- Shipping costs
By presenting this information in an easily digestible format, the executive team can make informed decisions and steer the company towards continued success.
Talking about dataset it includes 7 tables in the form of csv format which contains Sales & order data for Northwind Traders, food supplier, including information on customers, products, orders, shippers, and employees.In today's highly competitive business landscape, companies rely on data-driven insights to make informed decisions and stay ahead of the curve. Northwind Traders, a leading global import and export company specialising in gourmet food products, understands the value of data analysis in driving success. As a BI developer for Northwind Traders, I had the opportunity to build a comprehensive KPI dashboard that provides the executive team with a bird's-eye view of the company's performance across crucial areas. In this blog post, we will delve into the key features and insights offered by this powerful dashboard.
Maven Northwind Challenge Tableau Dashboard
Sales Trends:
Understanding sales trends is vital for any business. Northwind Traders' KPI dashboard provides a clear visualisation of sales performance over time. Executives can quickly identify patterns, seasonal fluctuations, and growth areas. By analysing sales trends, they can make strategic decisions regarding inventory management, marketing campaigns, and sales projections.
Total sales done by Northwind Traders were $1.35M from Q3 of 2013 to Q2 of 2015, with total orders of 830. The highest sale was done in 2015 Q1, i.e., $57K, with the highest orders of 182.
The total sales for the Northwind Traders are increasing year over year.
Product Performance:
The success of individual products can significantly impact a company's overall revenue. With the KPI dashboard, Northwind Traders' executives gain a comprehensive understanding of product performance. They can assess sales volume, revenue generated, and profitability for each product category. Armed with this information, they can optimise the product portfolio, identify top-performing items, and strategically allocate resources to drive growth.
There were a total of 77 products sold in 8 product categories. The highest product sold was Raclette Courdavault, with $76.3K. According to sales, the Cote de Blaye is the product with the highest sales of $149.98K. The most popular product category was beverages, with a total quantity sold of 404 and total sales of $286.55K.
Key Customers:
Maintaining strong relationships with key customers is crucial for sustainable business growth. The KPI dashboard highlights the company's most valuable customers based on various metrics such as revenue generated, repeat purchases, and customer loyalty. This insight allows executives to focus on nurturing these relationships, tailoring offerings to their specific needs, and identifying potential upsell or cross-sell opportunities.
Northwind Traders has a total of 91 customers across 21 countries. The United States has the most customers, followed by Germany. The top customer for the Northwind Traders was Hanari Carnes, with total sales of $18.3K.
Shipping Costs:
Efficient supply chain management is a critical factor in maximising profitability. The dashboard provides a detailed breakdown of shipping costs, enabling executives to identify areas of potential cost savings, optimise logistics, and negotiate better terms with shipping providers. This information helps Northwind Traders streamline operations and enhance overall profitability.
There are three shippers who supply the food products for the Northwind Traders. United Package Shipper Company supplied the maximum 326 products with the highest total sales of $89.94K, followed by Federal Shipping with total sales of $50.50K in 2nd place and Speedy Express in 3rd place with total sales of $46.51K.
Conclusion:
Northwind Traders' KPI dashboard equips the executive team with a comprehensive overview of the company's performance in key areas. By leveraging data visualisations and actionable insights, executives can make informed decisions, drive growth, and maintain a competitive edge in the gourmet food industry. This powerful tool empowers Northwind Traders to monitor sales trends, evaluate product performance, nurture key customer relationships, and optimise shipping costs. With a data-driven approach, Northwind Traders is well-positioned to continue its success and expand its global reach.
No comments: