基于Power BI桥梁监测数据可视化研究

Research on Visualization of Bridge Monitoring Data Based on Power BI

在当前我国桥梁发展由建设向养护转移的重要背景下,因为长期积累的桥梁监测数据类型繁多、评价标准不同,导致数据可视化差、企业决策困难。以武汉市城市桥梁智慧管理平台桥梁监测数据为例,开展多源监测数据的标准化集成和基于Power BI的商业数据分析工具的可视化,对原始数据进行建模转换,实现异构数据源的集成,多维角度观察数据,通过可视化界面展开,提高桥梁数据展示能力,支持企业战略决策需求。

In the current important background of bridge development in China shifting from construction to maintenance,long-term accumulation of bridge monitoring data has many types and different evaluation standards,resulting in poor data visualization and difficult decision-making for enterprises.Taking the bridge monitoring data of Wuhan City Bridge Smart Management Platform as an example,the standardized integration of multi-source monitoring data and the visualization of commercial data analysis tools based on Power BI are carried out,and the original data is modeled and converted to realize the integration of heterogeneous data sources,and observe the data from a multi-dimensional perspective and expand it through a visual interface to improve the ability to display bridge data and support corporate strategic decision-making needs.