NORTHWIND DATA ANALYSIS USING SQL SERVER & EXCEL
Data Parsing
• Description: An interactive dashboard showing Sales Analysis
• Tools Used: SQL Server, Excel
• Data Source: Northwind SQL Database
• Story:
1- In SQL, Creating Queries & Views for:
o Product performance
o top10 customers
o Net Sales Per Year
o Top Sales Products
o Employee Sales
o Order Timing Per Hour
o Delivery Days Avg.
o Top Suppliers
o Orders by Country
o Not Ordered Products
o Totals
2- Exporting Data to Excel
o Creating a Pivot table for every data set
o Creating Pivot charts
• Designing Interactive Dashboard with filters displays Sales Analysis
• Tools Used: SQL Server, Excel
• Data Source: Northwind SQL Database
• Story:
1- In SQL, Creating Queries & Views for:
o Product performance
o top10 customers
o Net Sales Per Year
o Top Sales Products
o Employee Sales
o Order Timing Per Hour
o Delivery Days Avg.
o Top Suppliers
o Orders by Country
o Not Ordered Products
o Totals
2- Exporting Data to Excel
o Creating a Pivot table for every data set
o Creating Pivot charts
• Designing Interactive Dashboard with filters displays Sales Analysis