- 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.
- AdventureWorks sample dataset from SQL Server Management Studio from AdventureWorks.
- 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