Skip to main content
PDGRH

Productivity Dashboard

The Productivity Dashboard analyses labour productivity ratios across 4 axes: harvest, mill, oil production and transport.

Access​

Route: /dashboard/analytics/productivity
Roles: Admin, Manager, Supervisor
Module: Analytics & Performance

4 Key KPIs​

1. Harvest Productivity​

  • Measure: Units harvested / worker / day
  • Operations: Fruit collection, bunch cutting
  • Source: daily_work_entries (piece_work type)
  • Comparison: vs. previous month with trend indicator

2. Mill Productivity​

  • Measure: Units processed / worker / day
  • Operations: Nut tapping, nut pressing, loading/unloading
  • Source: daily_work_entries (piece_work type)

3. Oil Production​

  • Measure: Drums + jerry cans produced / day
  • Source: oil_stock_daily (entry_futs, entry_bidons)
  • Indicator: Average daily production volume

4. Transport Efficiency​

  • Measure: % weight loss between departure and arrival
  • Source: livraisons (weight_departure_kg vs weight_arrival_kg)
  • Note: The lower the %, the better the transport

Tabs​

Line chart over 6 months showing the evolution of the 4 ratios. Detects seasonal trends and anomalies.

Detail by Operation​

  • Bar chart: Average quantity and number of workers per operation
  • Detailed table: Operation, avg qty/worker, cost/unit, workers, entries
  • The 10 most active operations are displayed

Month Selector​

Monthly navigation with previous/next buttons. Cannot go beyond the current month.

Data Sources​

TableRowsUsage
daily_work_entries5,782Worker productivity
oil_stock_daily12Oil production
livraisons1+Transport efficiency
plantation_operations15+Operation categorisation

Multi-tenant​

All queries respect RLS isolation. Each tenant sees only their own productivity data.