I restored the AdventureWorksDW2019.bak database. The main objective is to show a comparisson between the budget provided (from 2022 to half 2023) against the sales we have for those years. First I prepare the DataBase separating the tables in Fact and Dimensional to have a general overview All data was then extracted to a Data Warehouse for further processing The warehouse was used with Power BI Desktop and then published publicly. All the tools used to complete this project are shown below. Overall we can determine the company has a prety solid return from sales comapred to their budget being the "Serious Back" their best product.
You can access to the preview report with this link
| Tools Used | Download Link |
|---|---|
| Microsoft SQL Server 2022 Express Version | Microsoft SQL |
| Microsoft SQL Server Management Studio | Microsoft SSMS |
| Microsoft Visual Studio Code | VSCode |
| Git Version Controller | Git for Windows |
| Microsoft Powe BI | PowerBI |
All feedback or suggestion are gladly welcome. 😄