商业智能在校园一卡通中的研究与实践

Research and Practice of Business Intelligence in the Campus Card

摘要: 研究对象是校园卡的历年交易数据,以这些交易数据为基础,研究了商业智能技术在校园一卡通中的应用.实践以商业智能和数据挖掘的流程作为主线,首先是需求分析,然后是对于数据集成和多维数据集的构建,最后阐述了多维数据库的Web展现.本研究主要的价值在于对于商务智能技术和数据仓库构建进行了充分的说明,运用SQL Server商业智能组件:SSIS、SSAS、SSIS对商业智能在校园一卡通中的研究进行了分析.

Abstract: Based on the actual campus card over the settling down transaction data as the research object,study the business intelligence technology application on the campus card.Practice in business intelligence processes as a cue,the needs analysis from the beginning,to data integration,to build the cube,cube Web show,conducted one one explained.Summary of the business intelligence technology and data warehouse technology development prospects.Software development tools using SQL Server business intelligence components: SSIS,SSAS,SSIS.