Northwind-Sales-Analysis:
May 9, 2019 · View on GitHub
This project based on Business Intelligence using QlikSense & Tableau. The primary objective of the project is to visualize sales analysis done using QlikSense & Tableau.
Dataset:
- northwinds.xls
- The data contains sales order data of Northwind (a general suppliescompany) for the period Apr-2013 to Mar-2015.
Calculated Columns:
- SaleAmt = Quantity * SalePrice Less Discount
- CostAmt = Quantity * CostPrice Less Discount
- Margin = SaleAmt – CostAmt
Visualizations:
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!