NRVA
Developed a real-time data model using SSIS and OPC UA for water stream sensor data, enabling 5-second interval reporting on key metrics, visualized through Power BI.
Client
NRVA
Category
Consulting
Website
www.nrva.no
Date
03/05/2021
In the NRVA Data Warehouse, I utilized SQL Server Integration Services (SSIS) to extract data from an OPC UA Server, focusing on time-series data related to water stream tags collected from sensor networks at a frequency of 5 seconds. I developed a logical data model optimized for minimal latency, enabling real-time reporting on key metrics such as water usage, chemical composition, pH levels, and other laboratory data. Additionally, I leveraged Power BI to visualize the time-series data and ensure the accuracy and performance of quality assurance algorithms
Recent Portfolio
It is a long established fact that a reader will be distracted
