Data Warehouse

The data vault approach

When operational data arrives from multiple sources then a data warehouse may be required to capture change and reconcile figures. Millersoft Ltd practices building Data Warehouses using the Data Vault approach to ensure;

  • change within the data warehouse is easy and encouraged
  • data can be reconciled directly with operational systems
  • warehouse can scale
  • scope of any change is limited
  • reduce complexity and time need to generate cubes

Data warehouse overview