Game Sales Data Warehouse

Table of Contents

• About The Project
• Technologies Used
• Setup and Launch
• Project Status
• Contact

About The Project

• Build a Star Schema Data Warehouse model with Dim tables (containing the objects to be analyzed) and Fact table (containing the ids of the objects and 1 column containing the values grouped by from the ids)

Technologies Used

• SQL Server 2019
• Visual Studio 2019
• SQL Server Integration Services Projects 4.2
• Microsoft Analysis Services Projects 2.9.18
• Microsoft Reporting Services Projects 2.6.11

Setup and Launch

1. Restore "./Database/55N1NguyenVuGameSale.bak" and "./Database55N1NguyenVuGameSale_DW.bak"

Product Database:

Data Warehouse:

2. Run "./55.N1.01.NguyenTuanVu.GameSale.DWH/55N1NguyenVuGameSale_DWH.sln" to see Data Warehouse

3. Run "./55.N1.01.NguyenTuanVu.GameSale.DWH/55N1NguyenVuGameSale_DWH_SSRS.sln" to see Report

Project Status

Project is: complete

Contact

• Vũ Nguyễn