Data Mining Application In Sales System

In recent years, along with the decoration market lasts hot, decorative products increased traffic and the constant expansion of traditional management mode, cause there are too many defects, its incomplete data management means each adornment company is restricted by the management and development of the bottleneck. To solve these problems, and improve the work efficiency, reduce the burden of sales personnel, based on data warehouse and the data mining technology is introduced into the decorative products sales analysis.Data warehouse and data mining technology in recent years with database information is one of the hottest technological research direction. The data warehouse is an integration, facing the thematic, time-varying, as nonvolatile data collections of four characters, data warehouse system allows integration will all the application systems for information processing, provide support for analysis, the historical data of unity provides a strong platform. Data mining is using artificial intelligence method from stored in database, data warehouse or other databases of large amounts of data analysis, the process of acquiring knowledge. At present the data mining technology in e-commerce, enterprise production, commercial field had certain applications. In adornment product sales system, the introduction of data mining technology, will originally simple sales data query evolved to find the reasons influencing product sales, targeted really enhance work efficiency, improve the competitiveness.Based on the data warehouse theory and data mining technology in the understanding of, first of all, introduces the data warehouse and data mining relevant theoretical knowledge; Secondly, using Microsoft SQL Server 2005 for multi-dimension data order Service with the modeling process, the adornment trading Co., LTD, sales management system, based on product sales data warehouse, including product sales data warehouse structure design, model design and data extraction, conversion and loading; Finally, through the data mining decision tree algorithm is applied to established product sales data warehouse, using decision tree algorithm of decision tree analysis generated sales of different products with what factors relevant, complete sales analysis of decision tree model was established. Through analysis of product sales, can unearth a lot of valuable data information, will carry out and reform of company has an important guiding significance.