DATA ANALYSIS AND VISUALIZATION OF AN ONLINE VOTING SYSTEM BASED ON BLOCKCHAIN TECHNOLOGY USING POWER BI

As part of the research work (IRN AP23489791), an online voting system based on blockchain technology was developed and implemented. This article is devoted to the methodology and practical application of the Power BI business intelligence tool for analyzing and visualizing data generated by this system. Using business intelligence tools such as Power BI to analyze data from blockchain voting systems is an important step to validate their performance, security, and transparency. The blockchain is a decentralized digital registry consisting of a chronologically ordered chain of blocks. In the context of electronic voting, these blocks contain transactions that can represent various operations: registration of voters and candidates, submission of votes, and counting of results.
The key characteristics of the data in the blockchain that make them suitable for voting systems and subsequent analysis include: Immutability, transparency, decentralization, Traceability. Each transaction has a unique identifier and a timestamp, which allows you to track all transactions in the system.
The work demonstrates how Power BI enables the transformation of complex and distributed blockchain data into visual and easily interpretable graphs and dashboards, which is critical for evaluating the performance, security and transparency of the voting system. Key metrics and visualizations are presented, and the process of integrating blockchain data with an analytical tool is described. The results confirm that using Power BI is an effective approach for validating and demonstrating the benefits of decentralized systems.

1. DVTChain: A blockchain-based decentralized mechanism to ensure the security of digital voting system voting system / Syada Tasmia Alvi et al // Journal of King Saud University – Computer and Information Sciences. – 2022. – vol. 34(9). https://doi.org/10.1016/j.jksuci.2022.06.014.

2. Lakshmi Sai Priya K. Electronic Governance and Open Society: Challenges in Eurasia / K. Lakshmi Sai Priya, Ch. Rupa // 2nd International Conference on Innovative Mechanisms for Industry Applications (ICIMIA). – 2020. https://doi.org/10.1109/icimia48430.2020.9074931.

3. Internet of Things, Artificial Intelligence and Blockchain Technology / R. Lakshmana Kumar et al // Springer at 2021. https://doi.org/10.1007/978-3-030-74150-1.

4. Applying the ETL Process to Blockchain Data. Prospect and Findings / Roberta Galici et al // Information. – 2020. – vol. 11(4) by MDPI AG at 2020. https://doi.org/10.3390/info11040204.

5. Beros I. Usage of BI Tools in Analysis of the Tomas Croatia 2019 Survey / I. Beros, N. Hlupic, F. Dzapo // 44th International Convention on Information, Communication and Electronic Technology (MIPRO) by IEEE at 2021. https://doi.org/10.23919/mipro52101.2021.9597033.

6. Jones Daniel. Power BI: 3 in 1- Comprehensive Guide of Tips and Tricks to Learn the Functions of Power BI+ Simple and Effective Strategies+ Advanced Guide to Learn the Advanced Realms of Power BI, 2021.

7. Designing a Blockchain-Enabled Methodology for Secure Online Voting System / Saurabh Singh et al // International Conference on Intelligent Data Communication Technologies and Internet of Things (IDCIoT) by IEEE at 2023. https://doi.org/10.1109/idciot56793.2023.10053410.

8. A Vijaya Kumar. Blockchain Based Public Cloud Security for E-Voting System on IoT Environment / A Vijaya Kumar, Gabbita Viswa Sarvani, Dama Satya // IOP Conference Series: Materials Science and Engineering. – 2020. – vol. 981(4). – by IOP Publishing at 2020. https://doi.org/10.1088/1757-899x/981/4/042013.

9. Ruj S. Blockchains: A Handbook on Fundamentals, Platforms and Applications / S. Ruj, S.S. Kanhere, M. Conti // Advances in Information Security by Springer at 2024. https://doi.org/10.1007/978-3-031-32146-7.

10. El Madhoun N. Going Beyond the Blockchain Hype: In Which Cases are Blockchains Useful for IT Applications? / N.El Madhoun, J. Hatin, E. Bertin // 3rd Cyber Security in Networking Conference (CSNet) by IEEE at 2019. https://doi.org/10.1109/csnet47905.2019.9108966.

11. Advances in System-Integrated Intelligence / M. Valle et al // Proceedings of the 6th International Conference on System-Integrated Intelligence (SysInt 2022), September 7-9, 2022. Genova, Italy, https://doi.org/10.1007/978-3-031-16281-7.

12. Visualization of Blockchain Data: A Systematic Review / N. Tovanich et al // IEEE Transactions on Visualization and Computer Graphics. – 2021. – vol. 27(7). by Institute of Electrical and Electronics Engineers (IEEE) at 2021. https://doi.org/10.1109/tvcg.2019.2963018.