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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
12 | |
7 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |