Data Warehouse Construction And Visual Analysis Of Parking Management

The problem of parking difficulty is becoming more and more serious,which not only reflects the resource planning of parking stations is not scientific,but also reflects the incomplete analysis and utilization to a large number of parking data information.Making full use of relevant data to analyze and make correct decisions requires complete and scientific enterprise solutions,the existing enterprise data management system is more inclined to the data query and storage function,and the application of business data analysis still has some shortcomings.However,business intelligence system provides multidimensional data analysis operation for users based on the technology of data storage and data query function,Through the use of business intelligence system,a set of intelligent data platform for relevant data processing,modeling and analysis can be systematically constructed,based on the data warehouse for enterprise data analysis function,the application of visualization technology to further display the results of data analysis,and achieve the support of enterprise related business decision-making.This paper mainly uses SQL Server Business Intelligence to build the business intelligence system of parking management enterprise.The core technologies include ETL process design,data warehouse construction and visualization technology research and application.In business intelligence system,ETL Technology is used to improve the quality of relevant business data of parking management department and integrate all kinds of source data;in the process of building data warehouse,relevant analysis business topics are formulated and multiple data dimensions are constructed to realize multi-dimensional analysis of parking management data;finally,data visualization technology is used to display the analysis results flexibly and intuitively of parking management data to provide data support for users to make relevant decisions.In ETL process design,the method of full table insertion is adopted for data extraction;data is modified to realize data cleaning design;and data is transformed by the method of unified data format.In the process of building data warehouse,five business items are formulated for the business rules of parking management enterprises,and the logical relationship between each item and its attribute groups is divided.Finally,the fact table and dimension table are constructed to realize the construction of data warehouse.On the basis of data analysis and display in the form of data reports,expanding the technology,and applying open source code,mapv and finereport to realize the comprehensive application of visual analysis based on data warehouse.Through the application of the technical methods studied in this paper,it helps enterprises analyze the actual situation,plays a positive role in the decision-making,and basically meets the needs of enterprises to solve practical problems.