A dashboard checking sensor posting times, missing readings, and delays in a SQL data feed.
Outcome: Helped identify late or unstable sensors before their missing data affected analysis.
Wi-Fi sensors sometimes dropped out or posted at irregular intervals. I needed to distinguish missing data from changes in environmental readings.
I built a Power BI dashboard over the SQL feed using DirectQuery. It checked whether devices had posted within their expected time windows, highlighted late or missing updates, and tracked posting counts and timing gaps.
The monitoring view helped identify which devices were late, intermittently unstable, or offline. It supported the sensor experiment by making problems in data collection visible before analysis.