preloader-matrix

AACO Case Study

About AACO

The Australian Agricultural Company (AACO) is Australia’s largest integrated cattle and beef producer which was established in 1824. Today AACO owns and operates a combination of properties, feedlots, and farms totaling to 6.4 million hectares of land which equates roughly to 1% of Australia’s land mass. AACO specialises in grain fed beef and Wagyu beef production with primarily three product lines Wylarah, Westholme and Darling. Today AACO manages the largest cattle herd of 340,000 heads in Australia spread across properties in Queensland and Northern Territory. The company employs different tools to evaluate different important animal traits with high degree of accuracy.

Problem Statement:

Any organization with such extensive operations entailing different departments (Administration, Logistics Supply & Transport, Agriculture Nature & Animal etc.) can face information authenticity issues because all departments start operating in silos. AACO faced a similar problem where having a single source of data truth became hard. In July of 2020 AACO introduced a new stock management software (Stockmate). During this transition several assumptions were made which further led to data integrity issues.
AACO approached AMZ consulting with the primary requirement of building and deploying Power BI based reports that would help them in identifying data integrity issues of the data stored in AACO’s SQL Database. As a solution AMZ Consulting developed an Animal Integrity Report(s)s for AACO.

The Solution:

The Animal integrity report(s) were developed to check different characteristics of every Animal to highlight any abnormalities. Some of the key things the reports help identify are:
• Missing animal attributes
• Invalid Animal Characteristic combinations
• Animal duplications
• Animal activity monitors
• Missing animal arrivals
• Animal Yard activity
• Weight Outliers Report

1. Missing Animal Attributes Report


The Missing Attributes report constantly checks the data source for animals that are missing key identification attributes like Cattle Type, Breed, Year Brand and Gender. Once identified, these animals can be reported to Property Managers who can physically check the animals and update the missing information in the system thus removing this error. Furthermore, this information can be sliced based on different key dimensions like Cattle Type, Year Brand, Breed Group and Sex making it easier to dissect and analyze the data.

2. Weight Outliers Report


The Weight Outliers report checks the data source for animal weights that are abnormally low or high. This report segregates out animals that have an incorrect recorded weight because the weight of healthy animals usually falls within a particular range depending upon geographic characteristics. Furthermore, the report allows the filtering down of such animals based on Regions and Properties. Upon identification of such animals the details are shared with the Property Managers who can then physically visit the animal and take an accurate measurement of the weight and update the correct information into the database.

Result:

The overall objective of developing these reports is to ensure data integrity and to help piece together a process that continuously monitors data integrity. These reports help identify animals that are failing to meet the criteria so that corrective measures can be taken to rectify the data. This process which has been automated using Power BI reports leads to lesser errors and increased accuracy in animal Forecasting Functions that are being performed by AACO.

Are you looking for a similar solution? Let us help you through!