- Course: IS217.O21.HTCL - Data Warehouse and OLAP.
- Lecturer: MSc. Nguyen Thi Kim Phung.
- Semester: 2, 2023-2024.
| No. | Student ID | Full Name |
|---|---|---|
| 1 | 21520596 | Tran Thi Kim Anh |
| 2 | 21521882 | Le Minh Chanh |
Project Title: Building and Analyzing a Bicycle Business Data Warehouse
Dataset: Europe Bike Store Sales | Kaggle
The project will begin by using an existing dataset. Subsequently, a data warehouse schema will be designed. SQL Server Data Tools for SSIS will then be employed to construct the data warehouse based on this schema. Following the construction of the data warehouse, SSAS within the same toolset will be utilized for analysis and reporting. These reports will utilize MDX, pivot tables in MS Excel, and Power BI for advanced data visualization and analysis purposes. Finally, data mining techniques will be applied to the data warehouse to forecast future revenue trends.
- SQL Server Data Tools for SSIS and SSAS in Visual Studio
- MS Excel
- Power BI
- Microsoft SQL Server Management Studio (SSMS)