The Mining Data Mart - Data Mining Techniques in CRM: Inside Customer Segmentation - page 173

Table 4.26 A lookup table for network codes.

Field name Field type Field description

Network_Code Int The network code where the call was terminated/

originated

Network_Desc Char The description of the network code where the call was

terminated/originated

Network_Group Char The network group (see following categorization, first

level)

Network_Subgroup Char The network subgroup (see following categorization, second

level)

Network_Code is the primary key (PK) of this table.

Table 4.27 A typical categorization of mobile
telephony network types.

Network group Network subgroup

Fixed

•Fixedna ional

International

• International

On-net calls

• Internal network numbers
• Customer service
•Ca lcenter

Off-net calls • Mobile competitor 1

• Mobile competitor 2
• • Mobile competitor n

Information lines

• Information lines

The MCIF is a flat table which combines the most important blocks of information
to provide an integrated view of the customer's relationship with the organization.
The data mart is a general purpose data repository, a transitional stage through
which operational data pass before being used for analysis. The MCIF is the last
step in the data preparation procedure, with data that can immediately (or with a
little extra processing) support the majority of the data mining applications. The
MCIF presented here is at an MSISDN level, although the data mart design also
allows theMCIF to be built at a different level (e.g., at a customer level) if required.
Although the contents of the MCIF should take into account the specific
mining needs and plans of each organization, we present in Table 4.28 a listing
of fields in an attempt to delineate the data dimensions typically required for
identifying the traffic patterns and usage profile of mobile phone customers.