All Collections
Integrations
Microsoft Power BI
PowerBI Report: Crop Performance
PowerBI Report: Crop Performance

How the Crop Performance report works in PowerBI and what the data shows

Emily Mertes avatar
Written by Emily Mertes
Updated over a week ago

The Crop Performance report in the Agworld PowerBI app gives you a single location to check on the current, past and future performance of the crops you grow.

Performance is measured in the form of a gross margin per area and a total gross margin. When you are in season, this is a forecast; an estimation based on your plan and your actuals to date and a yield and price you set in Power BI. At the end of the season, this will be a total gross margin for that crop (including all fields growing the same crop) based on the actuals you have recorded in Agworld and the yield and price forecast in Power BI.

This report has been design to give you an opportunity to:

  • Analyze your risk for each crop, based on minimum yields and prices

  • Understand your current position and forecast end of season position

  • Visualize your actual cost vs. expected cost over the season

  • Benchmark your current season on previous seasons

At the top of the screen, you will see a series of drop down menus. In here, you can:

  • Change the season

  • Change the crop

  • Select the growth method (irrigated/non-irrigated)

You can also manually assign a forecast yield and a forecast income using the test boxes - here you can simply type in different numbers to analyze different scenarios.

You'll notice that for each season, you have a yellow bar and a green bar in your charts. These represent your planned (yellow) and actual (green) costs. We also calculate a forecast costs, based on any open jobs in your Agworld account. This is represented in the image below:


If you're looking at this report, and your actual figures look incorrect, you can head to the Crop Cost Detail report to understand where your major costs are coming from.

Did this answer your question?