What is dimensional modeling? Design the data warehouse for a wholesale furniture company. The data warehouse has to allow analyzing the company's situation at least with respect to the furniture. Customer and Time. More ever, the company needs to analyze: The furniture with respect to its type, category, and material. The customer with respect to their spatial location, by considering at least cities, regions, and states. The company is interested in learning the quantity, income, and discount of its sales.

Dimensional Modeling

• Dimensional Modeling (DM) is a data structure technique that is used to optimize the data storage in a Data warehouse.

• This will optimize the database for faster retrieval of data.

• A Dimensional Model in the data warehouse is designed to read, summarize, and analyze numeric information like values, …