Northwind Trader sales analysis

Background:

Northwind Trader is an international e-commerce site. The management team wants to know about the sales performances across different markets, and find out the best-selling products, the average sales by product  and provide insights related to distinct area of interests within the company. The dataset include sales data over two years from six countries. 

Goal:

To perform a sales analysis and prepare a dashboard to visualize the most important KPIs: sales trends, volumes, SPLY, periodic growth rate, and discounts etc. Each report page has a specific focus. There are pages specifically focusing on the performances by categories/products, country, change over time, others try to explain the causes of sales decrease.

Result: 

As an EDA project, this report provides an interactive dashboard that enables users across the organization to consult different graphs, apply different filters, find the right information and insights that are specific to their teams and work contexts in an easy way, and therefore brings value to the organization's decision making and strategy formulation.