Data model: what data will be available and how will it flow?
Data gathering: how will data be gathered both in physical and technological terms?
Data gathered: what data will be gathered?
Data types: what types of data will be gathered?
Data formatting: how will data be held?
Data warehousing: where will data be held?
Data mining: how will we retrieve data from the warehouse?
Information modelling: how will we create models and what of?
Information access: how will we access the data models and reports?
Presentation & reporting: on what will we report?
Most companies want to know essential information about customers at every point of contact, for example:
Lifetime value
X sell and upgrade potential
Acquisition cost
Channel preferences
Loyalty/retention
Purchase behaviour patterns
Much of the data that they have will have different frequencies of change, refreshment or occurrence. It will be kept for different periods. In some cases, aggregated data may be kept rather than source data. All of these factors effect the data modelling exercise and the eventual modelling software requirements.
Turning the data into useful information requires:
Identifying the issue(s)
Assembling the data set(s)
Building models
Verify models
Interpretation of the results
Automation of the delivery
Thereafter, modelling tools and techniques have to be used. These can be divided into two groups: theory driven and data driven.
Theory driven modelling (hypothesis testing) attempts to substantiate or disprove preconceived ideas. Theory driven modelling tools require the user to specify most of the model based on prior knowledge and then tests to see if the model is valid.
Data driven modelling tools automatically create the model based on patterns they find in the data. This also needs to be tested before it can be accepted as valid.
Modelling is an iterative process with the final model usually being a combination of prior knowledge and newly discovered information. The engine(s) tools and techniques include:
Statistical techniques
Data driven tools
Correlation
Cluster analysis
t-tests
Factor analysis
Analysis of Variance
CHAID (Chi-square Automatic Interaction Detector) decision trees
