Automated NUR Reporting Pipeline
The Challenge
The weekly Network Unavailability Ratio (NUR) reporting was a highly manual, time-consuming process. Extracting raw logs, cleaning the data, and applying business rules took approximately 16 hours of manual work per week, delaying critical executive decisions.
Solution Architecture
Due to strict data confidentiality (NDA), the raw code cannot be shared. However, the solution was engineered using a fully automated ETL pipeline:
- Extraction: Scheduled SQL Server scripts pull operational network logs.
- Transformation: Python (Pandas) scripts clean the raw data and calculate NUR metrics dynamically.
- Visualization: The clean data is pushed to a Power BI Star Schema, driving a real-time dashboard.
Business Impact
- Efficiency: Processing time was slashed from 16 hours to under 3 minutes.
- Accuracy: Eliminated manual data entry workflows and zeroed out human error.