Sales-Analysis-Bike

Business Task

Analyse Sales data to improve internet sales reports and want to move from static reports to visual dashboards.
To focus on how much products have been sold, to which clients and how it has been over time.
To measure numbers against budget, added that in a spreadsheetSales Budget so that it can be compared with values against performance.
Look 3 years back in time when we do analysis of sales.

Data Set

AdventureWorks sample dataset from SQL Server Management Studio from AdventureWorks.

Tools

Microsoft SQL Server 2019 for data analysis - View SQL scripts(https://github.com/sanjanand06/Sales-Analysis-Bike/blob/main/DIM_CUSTOMER.sql)(https://github.com/sanjanand06/Sales-Analysis-Bike/blob/main/DIM_PRODUCT.sql)(https://github.com/sanjanand06/Sales-Analysis-Bike/blob/main/DIM_INTERNETSALES.sql)
Power BI for data visualisation - View dashboard

Dashboard