For this GitHub project, we focus on Northwind Traders, a renowned global import and export enterprise dedicated to delivering premium gourmet food items to restaurants, cafes, and specialized food retailers worldwide. The project's goal is to construct an advanced KPI dashboard tailored for the executive team.The primary aim is to provide a rapid overview of the company's performance across crucial aspects such as sales trends, product performance, key customers, and shipping costs.
The KPI dashboard was designed to be user-friendly, allowing the executive team to quickly understand the company's performance.
▪ Postgres
▪ Tableau
▪ PowerPoint (For Presentation and Insight)
-
Data Wrangling/Transforming: Rectifying spelling mistakes, Removing the duplicate rows, Datatype checking.
-
Importing the Dataset into PostgreSQL.
-
Loading the transformed data: Defining the useful KPIs, Creating insightful chart.
Tested the dashboard using SQL queries and made a documentation .
I want to extend my appreciation to Maven Analytics for furnishing with this dataset.