Science. Business. Society.
Vol. 10 (2025), Issue 2, pg(s) 53-56

SOCIETY

A Data-Driven Perspective on Demographic Changes in Veliko Tarnovo (1878–2024) Using Power BI

  • 1 University of Economics - Varna, Bulgaria, Science and Research Institute

Abstract

This study presents a data-driven exploration of the demographic evolution of Veliko Tarnovo from 1878 to 2024. By compiling population data from official census records and statistical yearbooks, the project builds a unified dataset covering nearly 150 years of urban development. The analysis focuses on population dynamics by gender and total population growth, identifying key periods of expansion and decline. The visualizations were developed using Power BI, providing an interactive and intuitive dashboard that enables users to explore trends, compare periods, and observe long-term demographic shifts. The study highlights a sharp population increase during the socialist era (1950s–1980s), followed by a significant decline in the post-1990 period, interpreted in the context of socioeconomic transformations and migration processes. The research offers both historical insight and a modern methodological approach, demonstrating how business intelligence tools can be effectively applied in urban demographic analysis and digital heritage projects.

Keywords

References

  1. National Statistical Institute. Population census and demographic data for Veliko Tarnovo (1878–2024). – В: Digital Statistical Library (accessed 2024). Available at: https://statlib.nsi.bg/bg
  2. Microsoft. Power BI Desktop: Business analytics software for data modelling and visualization. – В: Microsoft Corporation (accessed 2024). Available at: https://powerbi.microsoft.com
  3. Liu, J., J. Ren, B. Yang, M. Wang, Q. Li. Statistical analysis and visualization of demographic changes using BI tools. – Scientific Reports, Vol. 14, 2024, p. 11749. https://doi.org/10.1038/s41598-024-68857-y
  4. Kimball, R., M. Ross. The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling. New York, Wiley, 2013.
  5. Golfarelli, M., S. Rizzi. Data Warehouse Design: Modern Principles and Methodologies. New York, McGraw-Hill, 2009.
  6. Friendly, M., D. J. Denis. The early origins and development of the statistical graphics. – Journal of the History of the Behavioral Sciences, Vol. 41, 2005, No. 2, pp. 103–121. https://doi.org/10.1002/jhbs.20078
  7. National Statistical Institute (NSI). Demographic and Social Statistics – Population and Demographic Processes 2021. Sofia, NSI, 2022. Available at: https://www.nsi.bg

Article full text

Download PDF