Case study

Project Tracking Dashboard

TypeAdmin dashboard
Project tracking admin dashboard

Overview

A production admin dashboard for tracking projects, users, and field locations. It includes AI chat support, geolocation features, scheduled metrics jobs, Google SSO for sign-in, and a custom database schema designed around the client's workflow.

Challenge

The dashboard had to bring together very different kinds of data — live field locations, user activity, and periodically computed metrics — into one responsive interface. Scheduling the metrics jobs reliably, integrating AI chat support, and securing everything behind Google SSO were the key technical pieces to get right.

Dashboard metrics and geolocation views
Technologies used for this project

Frontend: Next.js with TypeScript
Database: PostgreSQL with a custom schema
Auth: Google SSO

AI chat support inside the dashboard
Integrated chat view in the dashboard