Write a business case that requires the development of dimensional modeling (business profile, needs, problems, current IT structure), develop the logical dimensional model (fact table, dimensions, attributes, data types, field length), and collect some sample data

Describe the case

Make sure to identify the business and the key items that need to be analyized

Definition of the Fact table Define the fact table and explain why those Measures were chosen

This criterion is linked to a Learning OutcomeDefine the Dimensions Explain what dimensions are being utilized and why those are important to the Business Case

Display the Sample Data

Make sure to display at least a sample of both Facts and Dimensions as part of the assignment