Design and implementation of big data analysis and visualisation platform for the smart city

Through the construction of smart cities, the modernisation of urban governance systems and governance capacities can be improved. However, the constructions of smart cities face the challenges of data failure, lack of relevance, information fragmentation, fundamental data without accepting new data and innovative concepts. Business big data are extracted, and converted from different departments, and then these structured, semi-structured, and non-structured data are extracted and transformed to load in data warehouse by ETL through the data sharing and exchange platforms. Then joint databases and element searches were used to create multi-department data business views to support specific applications in smart cities. This research realises the smart city big data visual analysis system. The system architecture includes data access layer, data management layer, data analysis layer and release management layer. The system mainly includes four modules: people's livelihood service, citizen big data, urban operation and big data map. This system helps break data barriers, connect data islands, and digitise many municipal businesses, so as to perform data analysis and data visualisation, and provide support for refined governance decision making. The system realises the access, integration, transformation, visualisation and interactive decision analysis of various data of urban life.