Overview
Enter textThis project focuses on developing an automated system for analyzing and reporting water and waste alarms across different regions. The solution integrates data from Azure, implements sophisticated cleaning algorithms, and delivers insights through Power BI visualizations. The project streamlines alarm monitoring and analysis, enabling better operational decision-making across Thames Valley, London, and Network Management Center (NMC) regions
Key Objectives
Automate the import and cleaning of alarm data from Azure and SCADA interface for multiple regions
Implement intelligent alarm classification and desk management system
Create comprehensive visualization dashboards for monitoring trends and patterns
Establish automated reporting system with key performance indicators
Tech Stack
Data Processing: Python for data cleaning and transformation
Visualization: Power BI for reporting and dashboards
Data Source: Azure for raw data storage
Approach
Problem Understanding: The project addressed the challenge of managing and analyzing alarm data across multiple regions. A key focus was distinguishing between different types of alarms, handling repeated alarms, and ensuring proper desk assignment for efficient response management.
Data & Methods: The solution implemented comprehensive data cleaning procedures, including removal of test signals, configuration changes, and system trials. The system processes alarm status, state information, and implements repeat alarm indicators for better tracking.
Engineering: The project features automated Python cleaning processes with modular functions for desk division, alarm status processing, and error removal. The system includes sophisticated repeat alarm detection and regional classification capabilities.
Collaboration: The implementation involved close coordination between different regional desks (Thames Valley, London, NMC) and careful consideration of stakeholder needs, ensuring the reporting system met management requirements while maintaining operational detail
Results & Impact
Successfully automated the alarm reporting process across all regions
Implemented dynamic visualization with trend analysis and KPI tracking
Developed comprehensive alarm classification system with repeat alarm indicators
Created automated monthly reporting with percentage change tracking and RAG status indicators