Today we were given a much cleaner set of tables, but were challenged instead by being restricted to using Power BI. Since we have only done an introductory session on Power BI, I feel like this was a “thrown in the deep end” type of challenge. It’s also a great way to learn!

Our task was to use the plastic waste data given to us, and possibly supplemented data, to try and convince George Clooney to re-think his role at Nespresso®, and to focus on a more environmentally friendly industry.

I was able to make a couple of dashboards for this challenge. The first one provides an overview of global plastic waste generation, I found doing a dashboard like this was a great way to tune my Power BI skills, and to move away from thinking like a Tableau user.

 

 

It was really great learning about the Power Query Editor while doing this Dashboard, as well as making new columns and measures using DAX Formulas.

Quadrant Clusters = if(‘plastic-waste-per-capita'[Plastic waste (kgs per person per day)]>MEDIAN(‘plastic-waste-per-capita'[Plastic waste (kgs per person per day)]),if(‘plastic-waste-per-capita'[Total Generated Plastic Waste (tonnes)]>MEDIAN(‘plastic-waste-per-capita'[Total Generated Plastic Waste (tonnes)]),”Upper Right Quadrant”,”Lower Right Quadrant”),if(‘plastic-waste-per-capita'[Total Generated Plastic Waste (tonnes)]>MEDIAN(‘plastic-waste-per-capita'[Total Generated Plastic Waste (tonnes)]),”Upper Left Quadrant”,”Lower Left Quadrant”))

I’m not sure it’s as readable as tableau’s formulas, but it is very similar to writing functions in excel!

 

I next made a dashboard that looked at the environmental impacts of the countries that heavily produce coffee;

 

 

This dashboard shows visually which countries are the top producers of coffee, and how that coffee production has been dramatically rising over time. It also shows a potential relationship between plastic waste and coffee production.

I didn’t find much overall trend between CO2 emissions and coffee production, however it is interesting to see that Venezuela (who has the highest per capita emissions in the data set) consumes ~91% of their produced coffee domestically, which is far higher than the average 27%

I really enjoyed playing around with the interactivity within Power BI, the transitions between views made by selections look smoother than Tableau.

 

 

After looking at some article on the impact of Nespresso® and other coffee pods on the environment, there are divided opinions. Some argue that since the pods use less coffee, and are more energy efficient than other methods, that they have less of an impact. Others focus on the whether the pods are made to be recycle-able or not, and how much is actually ending up in land fill.

 

George Clooney is ambassador to Global Coffee Pod Company, Nespresso®. Given it’s overall negative impact to the environment, should our beloved batman/bank robber set his gaze on another industry?

I argue that regardless of it’s impact, perhaps Mr. Clooney could complement his role with Nespresso® by also working with a company called “SCafe”, a company that has invented a way of transforming coffee grounds into wearable textiles!

Or perhaps he can leave the coffee industry all together, and focus on representing the smart, sophisticated high quality products made with Pinatex, which uses Pineapple fibers to make leather.

Data Links

Coffee Production Data

CO2 Emissions Data