Skip to Content

Data Blending Made Easy

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

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