Expedition Operations Dashboard

Google Sheets - FastAPI - PostgreSQL - React - Docker

Designed and built an operations intelligence system for expedition workflows where multiple divisions still input data through spreadsheets. The system centralizes shipment monitoring, exception handling, branch performance tracking, and admin synchronization through a structured PostgreSQL backend and a React dashboard.

View GitHub Contact

Operational scope

Spreadsheet-driven logistics monitoring with mirrored exception updates

Core flow: Google Sheets -> FastAPI -> PostgreSQL -> React Dashboard -> Google Sheets Mirror

Overview Dashboard Monitoring Dashboard Hidden Admin Page Exception Mirror

Project Snapshot

Key modules implemented in the current version

Input Tabs 13+

Supports multi-sheet operational inputs from several divisions

Core Layers 4

Sheets, API backend, PostgreSQL, and React dashboard

Dashboard Areas 3

Overview, Monitoring, and hidden Admin workflow

Update Flow 2-way

Dashboard writes to PostgreSQL and mirrors results back to Sheets

Business Problem

Why this system was built

  • Operational data is distributed across multiple spreadsheet tabs and divisions.
  • Manual monitoring makes it difficult to track SLA, exceptions, and branch performance in real time.
  • Exception follow-up needs a more controlled workflow than open spreadsheet editing.
  • Leaders need a dashboard-friendly summary instead of raw spreadsheet views.

System Solution

How the architecture addresses the workflow

  • Google Sheets remains the operational input layer for business users.
  • FastAPI handles ETL, validation, analytics, and API delivery.
  • PostgreSQL becomes the structured system of record for processed dashboard data.
  • React provides a clean monitoring interface for operations and admin users.

Data Flow

End-to-end movement from spreadsheet input to dashboard output

Stage Tool Role Output
Operational Input Google Sheets Pickup, delivery, exception, branch, and log input by different divisions Multi-tab spreadsheet records
Ingestion & ETL FastAPI + Python Read, validate, normalize, and aggregate operational records Structured shipment and analytics objects
Storage PostgreSQL Persist dashboard-ready data and exception update state Relational tables for API consumption
Dashboard Delivery React Render KPI overview, monitoring tables, and admin controls User-facing operational dashboard
Exception Mirror FastAPI + Google Sheets API Push admin exception updates back into a locked sheet `update_exception` audit trail

Overview Dashboard

Shows high-level metrics such as delivered shipments, delayed shipments, exception volume, branch performance, and visual summaries for decision-makers.

Monitoring Dashboard

Provides shipment tables, recent exceptions, and operational detail views that help teams monitor the latest delivery state.

Hidden Admin Module

Moves synchronization logs, validation logs, and exception management into a restricted route so regular users only see the business-facing dashboard.

Spreadsheet Design

Operational tabs covered in the current design

master_cabang input_pickup input_delivery input_exception update_exception log_sinkronisasi

Operational Controls

Admin-oriented governance built into the workflow

Sync trigger Refresh flow Password-protected admin route Locked mirror sheet PostgreSQL source of truth

Why This Project Matters

  • It reflects a realistic business scenario where spreadsheets are still the primary operational interface.
  • It demonstrates practical backend engineering with ETL, PostgreSQL modeling, and API delivery.
  • It shows dashboard thinking beyond charts by including admin workflows, exception control, and mirrored update handling.
  • It is portfolio-ready because it combines data engineering, process automation, backend development, and frontend delivery in one system.