Description

Dept. of CSE, BUET
Assignment on Big Data analytics (Data Warehouse)
Full marks: 20

Task 1: Design the architecture of the warehouse and explain the sources, preprocessing, noise reduction, transformation and uploading.
Task 2: Design the star schema for the warehouse using the scenario and the data set and explain how the data of the superstore database will be collected to the DW (source driven or destination driven).
Task 3: Implement the star schema in PostgreSQL and upload the given data into the database.
Task 4: three different cross tabulation for three different dimensions using total price/ quantity. Write SQL to find the cross-tabs.
Task 5: Find at least 5 important DSS reports (one for each dimension) as bar chart. Use cube operation in SQL to find the reports data.

Data set for the DW has been uploaded in the Google drive shared folder given below.
Submission instruction:
1. Upload the hand-written report describing tasks 1-5 in pdf format to moodle.
2. Add the system presentation video shared link to your Google drive into the shared Google sheet in
https://drive.google.com/drive/folders/1DGAO_WdmoEYx1sxyWI9EVRsffs1 1fWiI