dimensionalization
Dimensionalization refers to the process of assigning dimensions to data. In essence, it is about transforming raw data into a structured format that is suitable for analysis and reporting. This typically involves creating or identifying dimensional tables and fact tables. Dimensional tables, often referred to as dimension tables, store descriptive attributes of the business, such as customer names, product categories, or dates. Fact tables, on the other hand, store the quantitative measures or metrics that are to be analyzed, such as sales figures, order quantities, or website visits.
The goal of dimensionalization is to create a data model that is easy to understand and query,