← All projects
Analytics React TypeScript PostgreSQL

[Confidential]

A device telemetry intelligence platform enabling analysts to query a large database of device events using a composable filter system, virtualized data tables, and saved query presets.

Context

Intelligence analysts needed to slice through large volumes of device telemetry data without writing SQL. The core challenge was building a filter interface expressive enough to handle multi-column, multi-value queries with date ranges, while remaining fast enough to handle thousands of record result sets.

What I built

I owned the dashboard including a filter bar, active filter panel, saved-preset modal, and back-end API integration.

Filter Bar — composable query builder with autocomplete, match highlighting, and full keyboard navigation and supporting CSV input.

Virtualized data table — Built on react-virtualized: click-to-sort with ASC/DESC indicators, expandable rows showing raw key/value pairs and pagination.

Back-end integration — Server-side query endpoints supporting multi-column filtering, date range constraints, and latest-record lookups via Knex.js.

A performant analyst tool handling thousands of record result sets with virtualized rendering, no-SQL querying, and saved filter presets — giving non-technical analysts direct access to complex device telemetry data.