Dimensional Modelling

Posted on 2021-01-16 09:28:39 by admin

Using an abstract modelling layer based on mind maps, we define measures, dimensions, hierarchies, calculations and other attributes needed for a Data Warehouse setup.

Our business data model is driven & designed from interactions with business users and we also conduct workshops with the various business units in our definition process. The DWH Staging Area is temporary location where data from source systems is copied. All required source data is made available before data is validated/transformed/transferred into the Data Warehouse. Thus having an staging area considerably reduces the risk of data loss at any point of time. Staging is designerd to keep origional copy of data for extended periods of time for archival or troubleshooting purposes.

Data mapping is used as a first step for a wide variety of data integration tasks including data transformation/data mediation. We perform an analysis of the data in order to get an accurate account of the different types of data being stored in the data warehouse and the nature of the different sources being used. It includes identifications of attributes, size, datatype, allowed values and mapping between the source, staging & DWH model.