Skip to Content

Because I am a big coffee drinker, I thought, why not see where coffee is produced and where it is consumed?  What are the top coffee consumers and producers?

First I ran a query at USDA site http://apps.fas.usda.gov/psdonline/psdQuery.aspx

Unfortunately you can only select one measure at a time.  First I selected consumption and saved it to an Excel file.  Then I selected production.  Now I have two Excel files and I want to compare production versus consumption.  I could use a VLOOKUP in Excel to join the two, but I have always struggled remember the syntax.  Also Excel is not always an “analysis-friendly” tool.

So now I will try it with Lumira:

First, acquire the consumption data.  Then add the production data

/wp-content/uploads/2015/12/1fig_858312.jpg

Go to the Visualization Tab to “Link Datasets”

/wp-content/uploads/2015/12/2figadd_858313.jpg

Define the link – in this case, based on country:

/wp-content/uploads/2015/12/4definelink_858323.jpg

Create a simple visualization from coffee production dataset

/wp-content/uploads/2015/12/5createviz_858324.jpg

Switch to consumption dataset

/wp-content/uploads/2015/12/6flipconsump_858325.jpg

Now rank the top 5 coffee producers

/wp-content/uploads/2015/12/8topproducers_858326.jpg

Brazil, Vietnam, Colombia, Indonesia and Ethiopia are the top producers

/wp-content/uploads/2015/12/topprod_858328.jpg

Maybe everyone knew about these countries – I didn’t realize that Vietnam was a top coffee producer

/wp-content/uploads/2015/12/topcon_858329.jpg

Top consumers include Europe, United States, Brazil (which makes both lists), Japan and Canada

Reference

Introducing Data Blending in SAP Lumira 1.27

Joining vs Blending in SAP Lumira 1.27

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply