【摘要】 文章主要研究销售的大数据分析,以及客户需求对往后生产计划的影响。以VB.net和SQL还有Excel为平台,通过程序实现对销售数据的统计,销售数据的保存,销售数据的预测、产品生产过程中的故障与分析、成本优化等。销售数据可以通过SQL保存,可以通过Excel产出折线图从而对产品数据分析,销售数据也可以通过Excel进行周期性预测,生产过程的故障也可以通过检索相关信息达到检测目的;对上季度客户需求多的产品可以在下季度实现生产。更多还原

【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.更多还原