• The need for dimensional modelling typically comes when:

    * you want to build a SSAS cube on top of the data warehouse (as SSAS thinks in terms of facts and dimensions).

    * business users need to create reports directly on top of the database. Dimensional modelling is generally easier to understand than a fully normalized model

    * you want to store historical data efficiently

    You don't need to use dimensional modelling, you can also use for example the Inmon methodology.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP