Skip to content

CROPIA - Harvest Operations Dashboard

Data Analyst & Full-Stack Developer

Python (Pandas, NumPy)SQLReact

CROPIA is a data tool I built to run the picking operation of a 400+ tonne strawberry farm: tracking harvest volumes and picker productivity across a 50+ person seasonal team, with forecasting to project end-of-season output and feed planting decisions for the following year.

_screenshots coming soon

The Challenge

I was managing the operation, and spreadsheets and Notion could not keep up with the volume of daily harvest and labour data. The goal was to centralise that data, make it queryable, and forecast where the season was heading, so planning stopped relying on manual tallies.

Daily picking produced a lot of data (volumes per picker, per plot, per day, plus labour) spread across disconnected spreadsheets. There was no quick way to see who was productive, how each plot was yielding, or where the season would land.

The Approach

  • •Built a Python pipeline (Pandas, NumPy) to ingest and clean daily harvest and labour records
  • •Modelled and stored the data in SQL so it could be queried instead of re-entered
  • •Built a React interface to visualise picker productivity and per-plot yields across the season
  • •Added forecasting to project end-of-season volumes from in-season picking data

Deliverables

  • •A central data model for harvest, labour and yield data
  • •Dashboards tracking picker productivity and per-plot yield across the season
  • •Forecasts of end-of-season volume

The Impact

  • •Replaced manual spreadsheet tracking with a single queryable system
  • •Gives in-season visibility into picker productivity and per-plot yields that was not available before
  • •In its first season, the yield data is starting to inform planting decisions for the next year: identifying which plots and varieties performed well to guide what gets replanted

Lessons Learned

Building this is what convinced me that operational problems are often data problems. It moved me from running operations to wanting to build the systems behind them, which is the direction I am taking now.

_live site

Visit the website

_client

Self-initiated (Ets Brajon)

_industry

Agriculture / Food production

_work

Data Pipeline

Data Modelling

Forecasting

Dashboard Development

_date

March 2026 - Present

CROPIA - Harvest Operations Dashboard | Brajy