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
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
Merry Christmas Tammy Powlas and thanks for another great post.