Customer Success Stories
Improved analysis of the Flemish agriculture industry
Sound policy making must be based on solid facts and profound insight in sector activities. For this reason, the Department of Agriculture and Fisheries of the Flemish government recently implemented SAS solutions to improve their ability to thoroughly analyze the agriculture industry. The integrated SAS Intelligence platform enables them to more accurately revise and improve the annual profitability report as well as assess the sector’s environmental impact.
SAS solution maximizes information from available data
Comprehensive data collection is only a start
The Department of Agriculture and Fisheries of the Flemish government initiated comprehensive data collection back in 2003 through the implementation of accountancy software. The first goal was to analyze the profitability of the sector. To do so the Division for Agricultural Policy Analysis collects data of 720 Flemish farms. This virtual network of farms, called Landbouw Monitoringsnetwerk or LMN, is a representative sample of the entire population of 33,272 Flemish farms. Boris Tacquenier, Data Analyst and Policy Consultant at the Division for Agricultural Policy Analysis points out that this action was in fact only a start. “The database helped us in creating the annual profitability report, but its full potential wasn’t unlocked until the implementation of SAS in 2007.”
Integrated geo-economical data enable extrapolation
Indeed, SAS proved to be the perfect solution to enhance and empower the LMN database. The profitability report analyzes yields, production costs, revenues, and profits for all types of Flemish farms. Since the LMN database was only a sample, its data had to be integrated with geographical and typological data coming from the Statistics Division of the Belgian Federal Public Service Economy. “SAS ETL capabilities and data integration tools enabled us to accurately extrapolate the LMN sample to the entire population of Flemish farms,” says Tacquenier. “We used fine-mesh stratification in order to extrapolate the LMN data regarding the farm’s production and sales volumes.” In this mesh, all farms are classified into one of three size classes, five types of farming land, and a wide range of production types. The combination of these classes leads to a complex stratification mesh of 120 cells. “We have been able to successfully model the mesh in SAS,” says Tacquenier, “even though it was complicated by the fact that for some cells we did not have enough farms for as reliable a sample as we might have wished.”
Towards an automated profitability report
In order to automate the profitability analysis as much as possible, all data sources were analyzed and data marts were constructed. “The challenges in analyzing these data are quite diverse, ranging from simple data aggregation to very complex calculations,” observes Tacquenier. “Therefore we used various SAS tools as well as SAS coding, depending on the complexity of the required calculations. The good thing is that all of these methods can be neatly integrated into the same data environment, so we are able to gradually, but continuously, improve, expand, and refine our model.”
Data integration opens up new possibilities
Another outcome of the SAS implementation was the environmental impact assessment, published in April 2008 as “Milieudruk in de landbouw”. In this study, the environmental impact of the agriculture industry is measured by analyzing the amount of energy resources, herbicides and pesticides, and water used as well as other consumed and produced nutrients. The result is expressed as an indicator, showing the average energy consumption per hectare or number of cattle for seven types of farms. The study required the integration of a great deal of technical data, such as the composition of the various herbicides and pesticides, including information about the components’ environmental impact. “Clearly, this is a very complex study,” says Tacquenier, “and it required extensive coding in SAS to produce the report. But this coding is completely integrated into the total solution, which demonstrates the enormous versatility of the SAS platform. It is just one of the reasons we are so very confident that SAS will prove instrumental in all of our future studies, enabling a continuous improvement in our policy making.”
Looking for more information about data integration?
Contact your SAS office at +32 (0)2 766 07 00 (Belgium) or +352 26 11 84 (Luxembourg).
Contact SAS for pricing information and to learn more about our products and solutions.
Copyright © SAS Institute Inc. All Rights Reserved.
Department of Agriculture and Fisheries
Enable comprehensive reporting on Flemish agriculture industry
SAS® Enterprise Intelligence Platform, including complete data integration functionality.
Improved policy formulation based on:
“The full potential of our database wasn’t unlocked until the implementation of SAS, opening up new opportunities for more in-depth studies.”
“In order to assess the environmental impact, we had to include technical data on herbicides and pesticides. SAS enabled us to integrate these data seamlessly and accurately”
Data Analyst and Policy Consultant at the Division for Agricultural Policy Analysis