PROGNOZ 5 Applications
Global Agriculture
Built on the Prognoz 5 Platform, Global Agriculture is a web-based analytical platform that offers data access to three most commonly used global databases on agriculture. The platform also provides powerful multi-dimensional data engine (OLAP) with analytical and visualization capabilities, and digital data maps.
Our unique solution integrates data from three different data sources:
UN COMTRADE (the most complete database on foreign trade):
This dataset can be used for monitoring, analyzing and forecasting agricultural commodities trade flows among most countries. Users can work with data in up to six dimensions through any choice of:
▪ Reporting Country / Region (~250 countries),
▪ Destination Country / Region (~300 countries or other areas),
▪ Flow (exports, imports, re-exports, re-imports, trade balance, or total trade),
▪ Commodity (in the Harmonized System, ~5000 commodities at the 6-digit level, classified by nature of composition and used for customs purposes),
▪ Measure (value, weight, quantity, or unit price), and
▪ Time (annual since 1988).
NOTE: The current version of the Global Agriculture application comes with all agricultural-related commodities out of all UN COMTRADE commodity coverage. A list of available commodities is available upon request.
USDA PS&D and EUROSTAT Agriculture:
Widely known as the most commonly-used database for international analysis of agricultural commodities, USDA’s official data covers most agricultural commodities and various concepts/attributes (area harvested, imports, production, exports, yield, etc.) for all countries. The PS&D dataset covers Europe as an aggregate (EU-15, EU-25, and EU-27) but doesn’t cover individual countries. The EUROSTAT Agriculture database is used as a complementary source for individual European countries.
UN FAO PRODSTAT:
Another extensively-used agricultural dataset is FAO PRODSTAT. It covers more commodities than USDA PS&D but
the number of attributes per commodity is limited.
Key Features: The application comes with OLAP, an efficient analytical tool for performing multi-dimensional queries on each existing data set. Via this functionality, users can easily manipulate data and conduct customized analyses by dragging and dropping dimensions from one component to another within the Control Bar, creating a table view that best meets research needs. Additional functionality also allows users pivot tables, change the precision of the displayed data points, and highlight cells according to specific conditions, as well as introduce statistical functions over the data rows and columns. Users can also choose to display their data in tables, charts and maps. The results of user queries can be printed, saved and/ or exported to appropriate Microsoft Office products and/ or other common file types.