Implementation methodology

  • We conduct an initial 1-2 week workshop to define the overall requirements and to establish expectations and timeline
  • Model customization and source-to-target mappings are actioned based on Functional groups.
  • For each Functional group customization and mappings may require 4-8 weeks, depending on complexity
  • The order of the Functional groups are defined with client by priority

About Model

In our Data Warehouse Model the semantic data model is integrated with logical data model in several ways:

  • We conduct an initial 1-2 week workshop to define the overall requirements and to establish expectations and timeline
  • Relationships between the various entities are named and then we describe the type of relationship – practical example for subtype relationship between Device and Product table is named “Device is a Product”
  • Naming conventions for entities and attributes are respected throughout the Data Warehouse model
  • All attributes have a domain. Domains are not only generic (String, Number, Date), but also context-specific and descriptive of attribute role

Our Data Warehouse Model is customizable by client request. There are several options for customization:

  • We conduct an initial 1-2 week workshop to define the overall requirements and to establish expectations and timeline
  • Customizing of existing Entities including changing attribute properties (name, type, and description), adding new attributes, adding indexes etc.
  • Creating new Entities if there is a requirement for a new dimension or new aggregation
  • Adding new Subject areas with multiple entities that will cover new business areas
  • Customizing of physical model – defining partitions, block sizes etc.
Print Friendly, PDF & Email