Screenshot of a sensor uptime monitoring dashboard

Monitoring

Sensor Uptime Monitoring Dashboard

A monitoring dashboard built to detect sensor dropouts, latency issues, and abnormal posting intervals across multiple devices sending data into SQL.

Power BISQLArduinoDirectQuery ObservabilitySensorsLatency MonitoringOperational Dashboards

Outcome: Made it easier to identify failing or lagging sensors quickly instead of discovering data problems only after downstream analysis broke.

Problem

When sensors are posting data every few seconds, the real issue is not only the readings themselves. It is whether the data pipeline is healthy in the first place.

Wi-Fi-connected devices in particular were prone to dropouts and inconsistent posting intervals, which meant a separate monitoring layer was needed just to trust the incoming data.

Approach

I built a dashboard specifically to observe the behavior of the sensor network.

  • The dashboard checked whether each sensor had posted within the expected time window.
  • Conditional rules highlighted missing or delayed updates.
  • Posting counts and timing gaps were tracked to identify unstable devices.
  • The output helped distinguish between actual environmental readings and infrastructure problems.

What It Helped With

The system gave a clearer answer to questions like:

  • which device is late right now
  • which device is intermittently unstable
  • whether the problem is a full outage or just high latency

That is a different kind of analytics problem from ordinary reporting. It is closer to observability: building visibility into the health of the data-producing system itself.

Why It Mattered

This project reinforced a lesson that still matters in production work: if the data pipeline cannot be trusted, the dashboard built on top of it cannot be trusted either.

The monitoring layer reduced that uncertainty and made the wider sensor project more usable.