【摘要】：公共交通數(shù)據(jù)可用性的增加很大程度上改變了公共交通系統(tǒng)數(shù)據(jù)分析的模式。一個特別有前景的領域是應用商務智能系統(tǒng),它可以幫助分析交通行業(yè)能源高消耗問題,改善客戶體驗,提高經營業(yè)績。然而,從公共交通系統(tǒng)中提取商業(yè)智能并不是一件容易的事情。傳統(tǒng)的數(shù)據(jù)分析工具通常不善于處理大型、復雜、動態(tài)的分布式數(shù)據(jù)。為此,我們開發(fā)一個可以從不同的業(yè)務的角度探索大量數(shù)據(jù)的數(shù)據(jù)分析系統(tǒng)。本文提出一個面向SQL Server Business Intelligence,適用于公共交通公司數(shù)據(jù)倉庫建設的模型。數(shù)據(jù)分析系統(tǒng)的數(shù)據(jù)來自不同的信息系統(tǒng),通過運用ETL技術提取來自不同數(shù)據(jù)源的異構數(shù)據(jù),根據(jù)用戶需求,清洗數(shù)據(jù),最后將所有的數(shù)據(jù)加載到目標數(shù)據(jù)倉庫。通過構建一個多維的目標數(shù)據(jù)倉庫,用戶可以集中管理數(shù)據(jù),并且能夠從多個角度分析數(shù)據(jù)。本文通過開發(fā)基于SSRS的報表系統(tǒng)展示數(shù)據(jù),常見的報表形式有表格和圖形。用戶可以從多維度查詢報表數(shù)據(jù),比如,時間維度和屬性維度。最后,數(shù)據(jù)分析系統(tǒng)通過應用Reporting Service,對報表進行管理。
[Abstract]:The increasing availability of public transport data has greatly changed the pattern of data analysis in public transport systems. A particularly promising area is the application of business intelligence systems, which can help analyze high energy consumption in the transport industry, improve customer experience, and improve business performance. However, extracting business intelligence from public transport systems is not easy. Traditional data analysis tools are usually not good at dealing with large, complex, dynamic distributed data. To this end, we develop a data analysis system that can explore a large number of data from different business perspectives. This paper presents a model oriented to SQL Server Business Intelligence, for data warehouse construction in public transport companies. The data of the data analysis system comes from different information systems. The heterogeneous data from different data sources are extracted by using ETL technology, and the data is cleaned according to the user's needs. Finally, all the data are loaded into the target data warehouse. By building a multidimensional target data warehouse, users can centrally manage data and analyze data from multiple perspectives. In this paper, we develop a report system based on SSRS to display data, the common forms of reports are tables and graphics. Users can query report data from multiple dimensions, such as time and attribute dimensions. Finally, the data analysis system uses Reporting Service, to manage the report.
【學位授予單位】：西安電子科技大學
【學位級別】：碩士
【學位授予年份】：2014
【分類號】：U495

【參考文獻】

相關期刊論文 前1條

1 鄭洪源,周良;商業(yè)智能解決方案的研究與應用[J];計算機應用研究;2005年09期

，

本文編號：2227375