Automated harvest and labour reporting for a greenhouse producer
A performance management system in Power BI replaced manual spreadsheets across several greenhouses and cut manual reporting time by more than 80%.
Delivered by Rhyline’s founder as business intelligence and performance management analyst at HNG Farms, Queensland, Australia (August to December 2025).
-
Challenge
Harvest volumes, labour hours and costs were recorded in shared spreadsheets and online databases across several greenhouse locations. Reports were put together by hand, and productivity was not measured the same way at every site, which made it hard for management to compare crops, teams and locations.
-
Approach
Mapped how harvest, labour and cost data was recorded at each location, then defined the measures management needed: harvest yield per square metre, labour efficiency, standard versus actual productivity per hour, and harvest cost per kilo.
-
Solution
A relational data model linking harvest volumes, labour hours, costs, crops and greenhouse locations, with Power BI dashboards that show the operational KPIs as the data comes in. Data extraction from online databases, shared Excel workbooks and cloud folders was automated with Power Query and Power Automate, replacing the manual spreadsheets.
-
Result
Manual reporting time fell by more than 80%. Management used the new cost measures, such as revenue per labour hour and labour cost per harvest, for budgeting, planning and day-to-day decisions.