Ic Card Transaction Data Mining And Analysis

This thesis has explained how to apply data analysis technology to the administrative decision of operation development on public transit. It is pay attention to using the new technology, new tool, has adopted Microsoft' s newest database tool Microsoft Analysis Manager to combine the database which uses Microsoft SQL Server, it is used OLAP analysis tool and Data Mining tool in its Analysis Manager, made the solution more rational , more convenient and more practical, and has improved working efficiency greatly .This thesis according to the step of the database administrative skill, base on source data filter and trimness, establish relevant database, form data warehouse, establish OLAP Cube and set up Data mining Model etc., have carried on overall expatiation to the whole procedure.Among them, it is including in analysing the source data structure, arrangement method to provide source data in source data trimness. Among establishing relevant database, define this thesis necessary analysis data, determine database structure. Data warehouse that had formed, get rid of the noise because of technological in the source data, have revised the form of the data again. According to the purpose of the data analysis received of this thesis, through establishing OLAP Cube, establish and analyse Dimension and Measure of the data, and it is combine the fact that...