KPI's Dashboard Northwind Traders

Project:

The scenario for the Maven Northwind Challenge is to work as a BI Developer for Northwind Traders, a multinational import and export company specializing in selling high-quality gourmet food goods to restaurants, cafes, and specialty food merchants worldwide.

Building a top-level KPI dashboard for the executive team is part of the function. Its goal should be to provide them with a rapid understanding of the company's performance in essential areas such as:

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

The dashboard should be designed to expand and accommodate additional data over time, however, the management has emphasized that insights and recommendations should be available to share with the VPs.

Data:

This dataset contains seven CSV tables with 2985 records and 28 fields: Data on orders, products, shipping, employees, orders details, customers, and categories.

Task:

• Data collection and preparation
• Querying transforming and loading data
• Data modeling
• Writing DAX measures and calculated column
• Develop compelling reports and visualization
• Create Interactive dashboard

Result:

Make a visualization using the questions from the goal section as a guide. Finally, the outcomes of this report will provide valuable insights to Stakeholders about business efficiency and performance, and they will make decisions about the company's growth and goals.