Northwind Traders Sales Analytics

The data is spread across seven CSV files namely orders, order_details, product, shippers, category, customer, and employees. We can consolidate data with Excel and create the data model in Power BI.

The Power BI dashboard displays net sales, total orders, average transit time, freight charges segregated by the shipping firms, and top-performing employees for every year, product category, country, and city.

It also gives the net sales trend, monthly orders, the top 5 most-ordered products, and the top 5 customers by sales.