使用SQL Server 2005构建移动用户行为分析平台

Build the Consumers' Behavior Model Using SQL Server 2005

在电信业重组之后,中国移动、中国电信和新联通对移动网络的用户的争夺势必越演越烈。如何根据用户的个人信息数据和消费数据,构建用户的一般消费行为模型,以此预测即将流失的客户并提供有针对性的服务,最大程度的保留原网客户以降低客户流失率,已经成为三大运营商的主要目标。本文详细介绍了基于中国移动的现网数据(用户信息和消费数据),使用微软公司的SQL Server 2005搭建用户消费行为模型(数据仓库)的过程,并在项目中验证了该过程的正确性。

After the reformation of telecommunication industry of China, the competition among China Mobile, China Telecom and China Unicorn should be much fiercer. It is a big challenge for the three services providers （SP） to keep the regular customers. It is generally considered a good way to build a model about the customers behaviors based on the consumption data. And according to the model, SP can afford the appropriate services to different kinds of people so that they can retain more regular customers. This paper introduces the process to build the model in detail based on the network data （ including the personal information and consumption data） using Microsoft SQL Server 2005.