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

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


Go to the Visualization Tab to “Link Datasets”


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


Create a simple visualization from coffee production dataset


Switch to consumption dataset


Now rank the top 5 coffee producers


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


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


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


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