⟩ What is EDW?
EDW is Enterprise Datawarehouse which means that its a centralised DW for the whole organization.
this apporach is the apporach on Imon which relies on the point of having a single warehouse/centralised where the kimball apporach says to have seperate data marts for each vertical/department.
Advantages of having a EDW:
1. Golbal view of the Data
2. Same point of source of data for all the users acroos the organization.
3. able to perform consistent analysis on a single Data Warehouse.
to over come is the time it takes to develop and also the management that is required to build a centralised database.