Complete the following tasks by using the dataset of Walmart.
Develop a DW and BI system. In your design, consider the following:
(For sections a, b the figure numbers refer to lecture 8-Building Dimensional Models and the supporting graphics file, DW Process.pdf)
- Select an industry and organization (company or Stevens). 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)
- Develop a Detailed Bus-Matrix showing which process you will design and its associated fact tables (i.e., marts within a single business process) and that business process.
- Detailed Bus Matrix (Figure 7-7)
- 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 com/rahulbagga/walmart-data“>https://www.kaggle.com/rahulbagga/walmart-data.
Finish all the four tasks by writing a detailed report and make a slide for that.
0 comments