Optimizing Smart Building Safety Management: A Descriptive Analytics Approach Using Microsoft Power BI and IoT Sensor Data

As the smart building paradigm establishes a global standard, ensuring occupant well-being has transitioned from a secondary utility to a fundamental safety requirement. Despite the widespread acquisition of environmental data through the Internet of Things (IoT), contemporary systems often suffer from "data overload" and fragmented silos, which obscure the longitudinal value of historical trends and result in reactive safety management. This research addresses these systemic gaps by developing a descriptive analytics dashboard using Microsoft Power BI to synthesize multi-source IoT data specifically CO2 levels, humidity, temperature, light intensity, and motion into actionable intelligence. Adopting a project-based methodology grounded in the Software Development Life Cycle (SDLC), the study operationalizes safety thresholds derived from ASHRAE and World Health Organization (WHO) standards through an "action-driven" traffic-light categorization system. Empirical results demonstrate that monitored environmental conditions remained within "Safe" thresholds for 99.7% of the observation periods. While CO2 (mean: 453.86 ppm) and temperature (mean: 23.52°C) remained stable within recommended ranges, light intensity was consistently observed below indoor standards. Furthermore, correlational analysis identified a direct relationship between occupant density and CO2 fluctuations, emphasizing the necessity of integrated sensing for strategic ventilation planning. By bridging the gap between raw sensing and strategic visualization, this research provides a robust framework for transitioning smart building management from reactive maintenance to a data-driven proactive model.

As the smart building paradigm becomes the global standard

1. Arsiwala, A., Elghaish, F., & Zoher, M. (2023). Digital twin with Machine learning for predictive monitoring of CO2 equivalent from existing buildings. Energy and Buildings, 284, 112851. https://doi.org/10.1016/j.enbuild.2023.112851 [Google Scholar] [Crossref]

2. Al‑Ghamdi, F. D., & Krarti, M. (2026). Review of digital twin modeling approaches and applications for building energy performance. Renewable and Sustainable Energy Reviews, 238, 117077. https://doi.org/10.1016/j.rser.2026.117077 [Google Scholar] [Crossref]

3. Casini, M. (2022). Chapter 11 - Advanced facility management. In (pp. 583–605). https://doi.org/10.1016/B978-0-12-821797-9.00003-9 [Google Scholar] [Crossref]

4. Deo, N., Stewart, R. A., Zhang, F., & Peerun, M. I. (2026). Digital Twin for building energy and thermal comfort management: A systematic review from an occupant-centric perspective. Digital Engineering, 10, 100104. https://doi.org/10.1016/j.dte.2026.100104 [Google Scholar] [Crossref]

5. Edje, A. E., Abd Latiff, M. S., & Chan, W. H. (2023). IoT data analytic algorithms on edge-cloud infrastructure: A review. Digital Communications and Networks, 9(6), 1486–1515. https://doi.org/10.1016/j.dcan.2023.10.002 [Google Scholar] [Crossref]

6. Ghansah, F. A. (2025). Digital twins for smart building at the facility management stage: a systematic review of enablers, applications and challenges. Smart and Sustainable Built Environment, 14(4), 1194–1229. https://doi.org/10.1108/SASBE-10-2023-0298 [Google Scholar] [Crossref]

7. Schmitt, T., Viklund, P., Sjölander, M., Hanson, L., Amouzgar, K., & Moris, M. U. (2023). Augmented reality for machine monitoring in industrial manufacturing: framework and application development. Procedia CIRP, 120, 1327–1332. https://doi.org/10.1016/j.procir.2023.09.171 [Google Scholar] [Crossref]

• The Indirect Effect of Liquidity and Activity on Company Value with Profitability as an Intervening Variable
• Effect of Financial Skills, Knowledge, and Attitude on The Financial Behaviour of Clergy
• A Decade of Review: Trends in Budget Execution and Financial Performance of Development Projects in Tanzania (2014/15-2023/24)
• The Influence of Pre-Project Planning on the Budget Absorption Rate of Public Funded Infrastructure Projects in Kenya a Comparative Case Study of Narok, Migori, and Kisii County Government Projects
• Assessment of Factors Influencing Digital Transformation in Hotels’ Facility Management in Abuja Metropolis, Nigeria