Business Intelligence Technology And Its Applied Research In Formula Support System

In recent years, with the economic development, the accumulated amount of data as well as competition, companies urgently needs to achieve fast and comprehensive business analysis to provide accurate information for business decision. So Business Intelligence (BI) software systems are developed quickly .In the industries with large amounts of date ,such as financial ,telecommunications, insurance and retail, Business Intelligence has been have a large number of applications and has achieved significant result. The corresponding BI technologies are mature and many big suppliers have also launched their own Business Intelligence products. However, in the field of manufacturing, especially the formulation products industries, due to different level of information, Business Intelligence has not been used well. Formulation enterprises have accumulated a large number of historical data, which contains many valuable experience and knowledge. Enterprises need to dig out the knowledge from the data, to translate traditional formula to scientific formula , for the purpose of stabilizing and developing the products'quality and enhancing the brand's overall competitiveness.Based on the analysis of Business Intelligence (BI) framework and it's key technology. This article introduces a Business Intelligence system solution which is applicable to formula products. The solution integrates to the common characteristic of formula products industries, for the purpose of stabilizing and improving the quality of the products, throughout the main line of the raw material analysis, formulation design and processing parameters analysis. Taking the computer-aided design system for cigarette formula as an example, and in light of the actual business needs , this article gives the building flow of the business intelligence system for formula product added design system. This article first introduces the concept of business intelligence as well as its key technologies, including Data Warehouse, ETL technology, OLAP technology and Date Mining technology etc. And then it analyzes the cigarette formula support system and its structure of Qing Dao cigarette factory. Using SQL Server 2005 Business Intelligence tools as the platform, the system's entire process are introduced. Business needs analysis describes the three major sectors of raw material, formulation and process. Logic and physical design introduces the date warehouse's main dimensional model , including the designing of the dimension tables and the fact tables. ETL process introduces the data extraction, transformation, load (ETL) system and the using of SSIS packages. The OLAP designing introduces the establishment of multi-dimensional data set , the dimension tables , fact tables and its relations. Date Mining introduces algorithms using in the cigarette production added system, including the decision tree , association rule and time series. Finally this article demonstrates some demos of the system in the perspective of data analysis. Different analytical methods and front-end display effect are used. This paper can provide some reference for the Business Intelligence using in formula industry.