OLAP technology as a tool for multidimensional analysis of ambient air quality parameters in real time
DOI:
https://doi.org/10.34121/1028-9763-2025-3-4-54-65Keywords:
OLAP, environmental monitoring, air quality, Power BI, air pollution, analytical system, multidimensional analysis, lysis, air quality index (AQI, CAQI), environmental safety, KPI indicators, monitoring system, pollutantsAbstract
This article explores a modern approach to environmental monitoring of ambient air quality using OLAP (On-Line Analytical Processing) technologies. The relevance of this research stems from the high levels of air pollution in urbanized areas, which lead to serious environmental and social consequences. Existing monitoring systems often lack real-time access to multidimensional analytics and are unable to effectively support decision-making processes. The proposed information-analytical system is based on OLAP cubes, enabling flexible data analysis across various dimensions — such as time, location, pollutant type, and quality indices. Two separate analytical blocks have been developed: one for analyzing measured concentrations of harmful substances (Measurements), and the other for detecting exceedances of regulatory thresholds (ThresholdExceed). Data are integrated from multiple sources, including automated stationary stations and community-based sensor networks. The system is implemented in Power BI, providing interactive visualizations, KPI indicators, and analytical dashboards. It enables anomaly detection, seasonal pattern analysis, and a comprehensive overview of pollution dynamics. In particular, abnormal PM10 values were recorded in 2024, along with radiation spikes observed in 2022. The proposed approach demonstrates the effectiveness of OLAP technologies as tools for developing flexible, scalable, and visually-oriented environmental analytical systems that can be integrated into national environmental monitoring frameworks.
References
1. Popov O., Iatsyshyn A., Kovach V., Artemchuk V., Kameneva I., Taraduda D., Sobyna V., Sokolov D., Dement M., Yatsyshyn T. Risk Assessment for the Population of Kyiv, Ukraine as a Result of Atmospheric Air Pollution. United States. 2020. 1 March. URL: https://ehp.niehs.nih.gov/doi/10.5696/2156-9614-10.25.200303.
2. Air quality in Kyiv. URL: https://www.iqair.com/us/ukraine/kyiv/kyiv-c.
3. Bogolubov V.M., Holub B.L. Informational and analytical system for assessing the state of atmospheric air. Proc. of VII International scientific and practical online conference «Sustainable development» — 21st century (scientific readings named after Igor Nedin). Kyiv, 2021. P. 235–246. URL: https://nubip.edu.ua/sites/default/files/u423/materials21.pdf.
4. Shahid S., Brown D.J., Wright P., Ahmad M. Khasawneh Innovations in Air Quality Monitoring: Sensors, IoT and Future Research. Sensors, 26 March 2025. URL: https://www.mdpi.com/1424-8220/25/7/2070.
5. WHO Global Air Quality Guidelines: Particulate Matter, Ozone, Nitrogen Dioxide, Sulfur Dioxide and Carbon Monoxide. World Health Organization (WHO), 2021. URL: https://www.who.int/publications/i/item/9789240034228.
6. IoT Solution for Smart Cities’ Pollution Monitoring and the Security Challenges. URL: https://www.mdpi.com/1424-8220/19/15/3401.
7. Rollo F., Bachechi Ch., Po L. Anomaly Detection and Repairing for Improving Air Quality Monitoring. Sensors. 2023. 6 January. URL: https://www.mdpi.com/1424-8220/23/2/640.
8. Air quality in Europe — European Environment Agency (EEA) Report 05/2022. URL: https://op.europa.eu/publication-detail/-/publication/f2bf4bce-72ee-11ee-9220-01aa75ed71a1/.
9. World Health Organization. WHO Global Air Quality Guidelines: Particulate Matter (PM2.5 and PM10), Ozone, Nitrogen Dioxide, Sulfur Dioxide and Carbon Monoxide; World Health Organization. Geneva, Switzerland, 2021. P. 1–267. URL: https://apps.who.int/iris/handle/10665/345329.
10. Azevedo R., Silva J.P., Lopes N., Curado A., Nunes L.J.R., Lopes S.I. Designing an IoT‑enabled Data Warehouse for Indoor Radon Time Series Analytics. Proc. of the 17th Iberian Conference on Information Systems and Technologies (CISTI), IEEE. 2022. URL: https://ouci.dntb.gov.ua/en/works/7WQLQwzl/.
11. Discussion of the Kyiv City State Administration Report on Atmospheric Air Quality Monitoring Results in Kyiv for 2023. URL: https://nubip.edu.ua/node/141976.
60
10
