Study and Realization of Supermarket BI System Based on Data Warehouse and Web Technique

Business intelligence system with B/S framework was developed by sales data from supermarket. Data guiding into and guiding out service tool of Microsoft SQL Server 2005 was selected as ETL tool. By extraction, transition, rinse and loading, mass data for analysis and decision-making were separated from affair database, and data warehouse aiming at sales theme of supermarket was established based on exploitation system of Microsoft Analysis Services. On-line analytical processing system was designed by adopting web technique, through which knowledge of decision-making was exhibited on web interfaces. With the employment of data mining arithmetic of clustering analysis, clients were classified and diverse manners of sales promotion were adopted respectively via assessing customers´ purchasing behaviors and customs of consumption. The business intelligence system furthest utilized data from affair databases, transforming them into information and further into knowledge. This system provides effective support for managers´ decision-making in the realm of supermarket sale.