Data Quality Dashboard

LimnoTech - Summer 2024
Project Overview
LimnoTech is an environmental consulting company based in Ann Arbor, MI. A rapidly growing subsidiary, Freeboard Technologies, creates buoy and remote monitoring hardware. Their clients include the City of Toledo, Cleveland Water Alliance, Cook Nuclear Power Plant, and many more. As Freeboard adds new sensors, it needs an improved system for monitoring hundreds of sensors at a glance.
My Contributions
I built a data quality dashboard from scratch using Python (Pandas), FastAPI, and Dash, hosted on AWS EC2 + Docker. This modular, maintainable system was designed and built by hand and makes it easy for LimnoTech engineers to spot issues with any stations or sensors. Features include stacked dot plots, a pane for recently offline sensors, evaluations for every point for every sensor in the last 48 hours, and a suite of APIs for data quality results. This system directly enabled LimnoTech to double its sensor capacity to 1000+ sensors while maintaining strong data quality; the system can handle many thousands more.