| 摘 要: 文章主要研究销售的大数据分析,以及客户需求对往后生产计划的影响。以VB.net和SQL还有Excel为 平台,通过程序实现对销售数据的统计,销售数据的保存,销售数据的预测、产品生产过程中的故障与分析、成本优化 等。销售数据可以通过SQL保存,可以通过Excel产出折线图从而对产品数据分析,销售数据也可以通过Excel进行周期 性预测,生产过程的故障也可以通过检索相关信息达到检测目的;对上季度客户需求多的产品可以在下季度实现生产。 |
| 关键词: VB.net;SQL;大数据分析;生产计划;故障分析;数据预测;成本优化 |
|
中图分类号: TP31
文献标识码: A
|
|
| Research on Big Data of Sales and Its Impact on Production Planning |
|
ZHANG Long, ZHONG Liangwei
|
(School of Mechanical Engineering, University of Shanghai for Science and Technology, Shanghai 200093, China )
zhanglong0520@126.com; zlvcad@126.com
|
| Abstract: This paper studies the big data of sales and the impact of customer demand for production planning. Using VB.net, SQL and Excel as platforms, sales data is collected, preserved and used to make sales predictions, for fault analysis and cost optimization of the production process. Sales data can be saved in SQL relational database, line chart can be produced in Excel to analyze product data, sales data can be periodically predicted in Excel, and faults in production process can be detected by retrieving relevant information. The products that the customers demand high in the previous quarter can be timely produced in the following quarter. |
| Keywords: VB.net; SQL; big data analysis; production planning; fault analysis; data forecasting; cost optimization |
