Question: For this short paper, due in Module Seven, you will review the Kimball Group's video for this module and the discussion on dimensional modeling presented in Chapter 18. Dimensional modeling is an important part of the data warehousing process. Describe the role, purpose, and need for dimensional modeling.
Additionally, provide specifics as to what the dimensional model seeks to achieve.
Specifically, the following critical elements must be addressed:
- Explain the role of dimensional modeling and what it seeks to achieve.
- Explain the purpose of dimensional modeling.
- Explain the need for dimensional modeling.
Consider providing examples from the resources and your own independent research to strengthen your explanation.