Northwind-Sales-Analysis

The primary objective of the project is to Analyse sales for Northwind data using QlikSense & Tableau.

---

Dataset:

• Northwinds.xls file has 32 columns and 2305 rows.
• The data contains Northwind Sales for the period Apr-2013 to Mar-2015.

---

Calculated Columns:

• SaleAmt = Quantity * SalePrice Less Discount
• CostAmt = Quantity * CostPrice Less Discount
• Margin = SaleAmt – CostAmt

---

Visualization in Tableau and QlikSense:

Tableau:

• Dashboard.
• Invoice Data With OrdID wise & OrderDate wise Totals.
• FinYear wise strategic data.
• Graph showing monthly strategic.
• Geo Graph showing a strategic measure per Geo Location.
• Forecast strategic data for the next 6 months.

Qlik Sense:

• Dashboard.
• Drill Down Table
• Drill Down Graph
• Combo / Dual Axis Chart
• Tree Map
• Geo Graph showing Total Revenue per City

---

Thank You!

Follow @shreyaswankhede