Complete the following tasks by using the dataset of Walmart.
Develop a DW and BI system. In your design, consider the following:
(For sections 1 the figure numbers refer to lecture 8-Building Dimensional Models and the supporting graphics file, DW Process.pdf)
Select an industry and organization. Select candidate subject areas and develop a high-level bus architecture, showing candidate fact and dimension tables. Describe the sequence of construction and why. Use the following artifacts (all or some)
High-level Bus Matrix (Fig 3-5), Opportunity Matrix (Fig 3-6), Prioritization Grid (Fig 3-7), Low-level Bus Matrix (Fig 7.1)
Identify possible conformed dimensions and reference back to the bus architecture showing the fact tables involved with each conformed dimension.
Identify representative transformation rules.
Design one aggregate table. Identify and explain if it’s 1-way, 2-way, etc.
Design one cube (MDDB). Identify the facts, dimensions and, for each dimension, whether it’s dense or sparse and why, and aggregation levels (dimension hierarchies).
The link to this dataset is https://www.kaggle.com/rahulbagga/walmart-data.
Finish all the four tasks by writing a detailed report.
Sample Solution
