The Design And Implementation Of BPTC IC Card Data Statistical Analysis System

Making full use of the data resources of the IC card, the application of today’smainstream science, technology and theory to establish the statistical analysis of databased on the IC card system, it makes the BPTC in a leading position in theincreasingly fierce competition in passenger markets. Statistical analysis of the ICcard system found that operation of law, adjustment capacity, improve service quality,and the play of public transport leading role of great significance.In this paper, Bl (Business Intelligence), the basic theory and technology, iscombined with the statistical principles and statistical methods to design andimplement the Beijing public transportation IC card data statistical analysis system.This paper first introduces the basic situation of the Beijing public transportationIC card system, according to actual demand, the application of business intelligencetechnology to solve the IC card data may not be effectively used, and to study theanalysis of the analysis required of the construction of IC card key technologies andmethods, data warehouse technology, ETL technology, on-line analytical techniques,data mining techniques and statistical methods; then the IC card system requirements,system requirements analysis, the overall design. Bus IC card data warehouse analysisand design of data warehouse implementation steps to determine the topic of systemsanalysis; data extraction, cleaning, transformation, load links are described, given thesystem OLAP (On-Line Analytical Processing) model design, and finally show thetools based on BI.Office analysis report design and implementation of the results ofthe analysis.The system has been tested and meet the design requirements, has beenrecognized by customers.