In the data warehouse design phase, we can use VBA to simulate the requirement and show it to users. Users can confirm the requirement, then you start the development in real system. this is a document with real data, real code used in DW project. this is a document with valuable VBA codes, it can be referenced in any Excel advance requirement. requirement.