Smart City Gnosys

Smart city article details

Title	Business Intelligence Tools In The Interpretation Of The Ranking Of Smart Cities
ID_Doc	13171
Authors	Babić A.; Zron A.
Year	2024
Published	2024 47th ICT and Electronics Convention, MIPRO 2024 - Proceedings
DOI	http://dx.doi.org/10.1109/MIPRO60963.2024.10569892
Abstract	In the age of Big Data, it is necessary to use various tools to quickly identify data trends, i.e. to visualize large datasets in graphical form. This paper explains the steps of extracting, transforming and loading (ETL) data from various sources, i.e. the use of business intelligence tools in interpreting large datasets for a large number of cities. Three basic phases of collection, processing and visualization of 38 indicators by six dimensions of a smart city for 127 Croatian cities are presented. Data collections were made through web scraping, secondary searches on the official websites of public institutions and through official requests to authorized institutions and cities. The second phase involved structuring, normalization, formatting, data cleaning and the calculation of the Croatian Smart Cities Index, which is the average of all standardized indicator values for all six dimensions of a smart city. The third phase concerned the interpretation of the results, i.e. the visualization of all dimensions of smart cities in Power BI and Tableau. © 2024 IEEE.
Author Keywords	Big Data; Business Intelligence (BI); Power BI; Ranking; Smart Cities; Tableau

Similar Articles

Id	Similarity	Authors	Title	Published
18559	0.874	Sun K.; Liu N.; Sun X.; Zhang Y.	Design And Implementation Of Big Data Analysis And Visualisation Platform For The Smart City	International Journal of Information Technology and Management, 22, 3-4 (2023)
59006	0.871	Farmanbar, M; Rong, CM	Triangulum City Dashboard: An Interactive Data Analytic Platform For Visualizing Smart City Performance	PROCESSES, 8, 2 (2020)
15885	0.859	Tiwari P.; Ilavarasan P.V.; Punia S.	Content Analysis Of Literature On Big Data In Smart Cities	Benchmarking, 28, 5 (2019)
4288	0.858	Malik M.; Chaturvedi R.; Kaushik A.; Ritu; Poonam	A Review On Smart Cities With Big Data Analytics	2022 2nd International Conference on Advance Computing and Innovative Technologies in Engineering, ICACITE 2022 (2022)
41865	0.856	Porras E.M.; Lievens B.; Heyman R.; Ballon P.	Performing Smart Cities Research Based On Existing Datasets: A Methodology Framework	5th IEEE International Smart Cities Conference, ISC2 2019 (2019)
3261	0.855	Osman, AMS	A Novel Big Data Analytics Framework For Smart Cities	FUTURE GENERATION COMPUTER SYSTEMS-THE INTERNATIONAL JOURNAL OF ESCIENCE, 91 (2019)
50087	0.853	Soomro K.; Bhutta M.N.M.; Khan Z.; Tahir M.A.	Smart City Big Data Analytics: An Advanced Review	Wiley Interdisciplinary Reviews: Data Mining and Knowledge Discovery, 9, 5 (2019)
1962	0.851	Sharifi, A	A Global Dataset On Tools, Frameworks, And Indicator Sets For Smart City Assessment	DATA IN BRIEF, 29 (2020)
53139	0.85	Rai A.; Kumar R.; Kumar N.; Fatima S.	Strategies And Tools For Big Data Analytics In Smart City Environments: Algorithms And Data Types	Advances in Electronics, Computer, Physical and Chemical Sciences (2025)