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. Online 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.
展开▼
机译：具有B / S框架的商业智能系统由超市的销售数据开发。选择了Microsoft SQL Server 2005的管理工具的数据被选为ETL工具。通过提取，过渡，冲洗和加载，分析和决策的质量数据与Affair数据库分开，旨在基于Microsoft Analysis Services的开发系统建立了超市销售主题的数据仓库。通过采用Web技术设计在线分析处理系统，通过在Web接口上展出了决策的知识。随着数据挖掘算法的雇用分析，客户分别通过评估客户的采购行为和消费习惯来分别通过分别进行分类，并通过各种促销方式。 Business Intelligence System最远利用Affair数据库的数据，将其转化为信息并进一步了解。该系统为超市销售领域的管理人员提供了有效的支持。
展开▼
