Research of data warehouse established methods based on county post CRM

Authors:
Pengfei Li;Caiwu Lu
Affiliations:
School of Management, Xi'an University of Architecture & Technology, Xi'an, China and Department of Information and Management Engineering, Xi'an Institute of Posts and Telecommunications, Xi'an, ...;School of Management, Xi'an University of Architecture & Technology, Xi'an, China
Venue:
CCDC'09 Proceedings of the 21st annual international conference on Chinese Control and Decision Conference
Year:
2009

Citing 3
Cited 0

Building the Data Warehouse

Building the Data Warehouse
Data Warehousing Fundamentals

Data Warehousing Fundamentals
Data Mining Techniques: For Marketing, Sales, and Customer Support

Data Mining Techniques: For Marketing, Sales, and Customer Support

Quantified Score

Hi-index	0.00

Visualization

Abstract

The CRM system of postal enterprise stored amount of data, including customer-based information, transaction record, business type, sub-office etc. But it cannot provide the comprehensive analysis for customers. According to the CRM system actual demand of postal enterprise, by analyzing the old model, we provide the architectural model of data warehouse based on CRM and determine customer-centered management Star schema. We also analysis subject field setting of the postal business and descript the implementation strategy and methods of data extraction, transformation and loading. Finally, we point out the limitations of the method.