Study and Realization of Supplier Business Intelligence System for Chain Supermarket

With the supplier data of supermarket, the business intelligence system was developed. The paper made use of data guiding into and guiding out service tool of Microsoft SQL Server 2005 as ETL tool. A mass of data needed for analyzing and decisionmaking were separated from affair database by taking out, transition, cleanout, loading. The data warehouse facing supplier theme was established by Microsoft Analysis Services developing system. Online analytical processing system was designed. Supplier management Agent managed the data of supplier data warehouse and incepted the information that distribution center Agent sent out. It combined the data mining algorithm of clustering analysis to choose type of suppliers and informed distribution center Agent. The business intelligence system made furthest use of data in the supermarket corporation affair database, transformed them into information and then sublimed the information into knowledge. The system provides effective support for decision-making of governor in supermarket supplier management.