Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Contributor
0 Kudos

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

1 Comment
Labels in this area