基于消费数据的大型百货商场会员购买力模型研究
|
摘要
本文主要基于获取的商场会员信息数据、商场销售流水表、会员消费明细表、商品信息表,通过Oracle数据处理与分析,剔除异常数据,为后续处理做准备。通过分析商场的会员消费特征,会员与非会员消费特征的差异,有针对性的为商场管理者提供营销建议;建立了基于会员性别、入会时长、年龄和消费频次的评估会员购买力的多元线性回归模型,并对模型的每个参数进行了检验。
This paper is mainly based on the acquired mall member information data, shopping mall sales flow meter, member consumption schedule and commodity information table. Through Oracle data processing and analysis, the abnormal data is eliminated to prepare for subsequent processing. By analyzing the characteristics of member consumption of the mall and the difference between the consumption characteristics of members and non-members, the marketing suggestions for the mall managers are proposed; the multiple linear regression model for assessing member purchasing power based on the membership gender, the length of membership, the age and the frequency of consumption are established and each parameter of the model is tested.
This paper is mainly based on the acquired mall member information data, shopping mall sales flow meter, member consumption schedule and commodity information table. Through Oracle data processing and analysis, the abnormal data is eliminated to prepare for subsequent processing. By analyzing the characteristics of member consumption of the mall and the difference between the consumption characteristics of members and non-members, the marketing suggestions for the mall managers are proposed; the multiple linear regression model for assessing member purchasing power based on the membership gender, the length of membership, the age and the frequency of consumption are established and each parameter of the model is tested.
引文
[1]朱道元,等.数学建模案例精选[M].北京:科学出版社,2003.
[2]姜启源,谢金星,叶俊优.数学模型[M].四版.北京:高等教育出版社,2010.
[3]Oder R R,Price C R. HGMS:Mathematical modeling of commercial practice[C]//American Institute of Physics,1976:641-643.
[4]Rivera R,Burnaev E. Forecasting of Commercial Sales with Large Scale Gaussian Processes[C]//IEEE International Conference on Data Mining Workshops. IEEE Computer Society,2017:625-634.
[5]King N,Bax T J. Using Grocery Store Point-ofSale Date to Correlate Consumer Purchase Habits to Nutrition Targets:,US20160133140[P]. 2016.
[6]Dorismond J. Supermarket optimization:Simulation modeling and analysis of a grocery store layout[C]//Winter SimulationConference. IEEE,2017:3656-3657.
[7]Pasichnyk R, Maslyyak B, Vitsentiy V. Modeling of products sale velocity and products recommended structure on the basis of a data reduction method[C]//Intelligent Data Acquisition and Advanced Computing Systems:Technology and Applications,International Workshop on. IEEE,2001:238-241.
[8]秦靖,刘存勇.Oracle从入门到精通[M].机械工业出版社,2011.
[9]秦靖,刘存勇.ORACLE从入门到精通:视频实战版[M].机械工业出版社,2013.
[10]王秀峰.数据分析与科学绘图软件ORIGIN详解[M].化学工业出版社,2008.
[2]姜启源,谢金星,叶俊优.数学模型[M].四版.北京:高等教育出版社,2010.
[3]Oder R R,Price C R. HGMS:Mathematical modeling of commercial practice[C]//American Institute of Physics,1976:641-643.
[4]Rivera R,Burnaev E. Forecasting of Commercial Sales with Large Scale Gaussian Processes[C]//IEEE International Conference on Data Mining Workshops. IEEE Computer Society,2017:625-634.
[5]King N,Bax T J. Using Grocery Store Point-ofSale Date to Correlate Consumer Purchase Habits to Nutrition Targets:,US20160133140[P]. 2016.
[6]Dorismond J. Supermarket optimization:Simulation modeling and analysis of a grocery store layout[C]//Winter SimulationConference. IEEE,2017:3656-3657.
[7]Pasichnyk R, Maslyyak B, Vitsentiy V. Modeling of products sale velocity and products recommended structure on the basis of a data reduction method[C]//Intelligent Data Acquisition and Advanced Computing Systems:Technology and Applications,International Workshop on. IEEE,2001:238-241.
[8]秦靖,刘存勇.Oracle从入门到精通[M].机械工业出版社,2011.
[9]秦靖,刘存勇.ORACLE从入门到精通:视频实战版[M].机械工业出版社,2013.
[10]王秀峰.数据分析与科学绘图软件ORIGIN详解[M].化学工业出版社,2008.