Skip to Content
Author's profile photo Lino Maggi

Data Geek Challenge – Brazilian Agribusiness

Hi,

Brazil has a particular variety of famous agriculture products like Coffee, Sugarcane, Soy, Meat and Corn. São Paulo is a large Sugarcane producer, but also is the largest Orange world producer. IBGE is a brazilian organization that collects and provides public information about how much is beeing planted, what is the size of the farms and product varieties (for obvious reasons, this data is in Portuguese only).

/wp-content/uploads/2013/07/image_galeria5_255088.jpg

There is a video I got from BASF, made as a tribute to Brazilian Farmers, and I include a personal joy with it by beeing part of a cattle-raising farmers family.

I got some data from  IBGE (http://www.sidra.ibge.gov.br/) and made a simple SAP LUMIRA query (in few minutes) to explore more than a 100.000 records.

https://youtube.com/watch?v=aQhKZJAZlIM

Considering permanent cultures In South-eastern region, the most industrialized Brazilian area Coffee and Orange (excluding Sugarcane and Soy, which are temporary culture, not considered in this analysis) production have the domain over Banana and Lemon:

/wp-content/uploads/2013/07/imagem1_255129.png

In the following screen we can see the production distribution over the country considering the property type of ownership (if is a land owner, a rental property or some kind of partnership, which is quite common in Brazil):

/wp-content/uploads/2013/07/imagem2_255130.png

IIn the next screen I excluded properties owned by farmers and it shows us that hetereogeneous culture is prominent for smaller farm administrators and partners:

/wp-content/uploads/2013/07/imagem4_255216.png

Looking at a different datasets, with a larger subset of cultures, is possibel to see how temporary and permanent cultures split play the game with cattle-raising. It´s also possible to see that cattle raising is prominent in Southern Regions.

/wp-content/uploads/2013/07/imagem5_255217.png

Hope you enjoy it !

Best,

Lino

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Custodio de Oliveira
      Custodio de Oliveira

      Nice work! Too bad the music ended unexpectedly 🙁

      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      good work.. !!!

      Author's profile photo Christiano Hage
      Christiano Hage

      Absolutelly amazing work! Congrats!!!!

      Author's profile photo Former Member
      Former Member

      Fantastic work! Lino Maggi captured the essence of the tool, demonstrating some data, not only in a "cold" way. The illustration with facts and background makes the partnership between tools and data a unbeatable team.

      Author's profile photo Eduardo Rezende
      Eduardo Rezende

      Very good work Lino!

      Author's profile photo Erico Mattos
      Erico Mattos

      Very nice Lino!!

      Congrats!!

      Author's profile photo Rafael Soares
      Rafael Soares

      Good work, Lino! You can show the SAP Lumira's power!

      Power users can do amazing reports in a simple way!

      Thanks!