About Makeover Monday
MakeoverMonday is a social data project which “offers inspiration and a dose of perspective for those who communicate data, and allow people to explore different perspectives and approaches to create more effective visualizations.”
To be more specific, “Each week we post a link to a chart, and its data, and then you rework the chart. Maybe you retell the story more effectively, or find a new story in the data. We’re curious to see the different approaches you all take. Whether it’s a simple bar chart or an elaborate infographic, we encourage everyone of all skills to partake. Together we can have broader conversations about and with data.”
Inspired by Dong Yu (an amazing data analyst also graduated from USC), I started this project from January 2019 and hope to better understand how to interpret data and translate insights into impactful visualizations.
All my Tableau visualizations can be found here through my Teableau Public profile.
Makeover Monday Week 9
This week the dataset focuses on the bicycle industry in the UK. The dataset basically contains the quarterly number of e-bikes and manual bikes that the country has imported throughout 2010 to 2016. The reported also calculated a Gross value added (GVA) to represent the economic value of the industry, but due to lack of sufficient industry related knowledge, I decided to leave that one out for my visualization here.
The original visualization and dataset is here in case you are interested, and the data source is from a SQW report.
I compared the same quarter over the differet years to rule out the possible seasonality.
Insights
- We can clearly see that, over these years, the number of imported e-bikes is gradually increasing, while the number of imported manual bikes is decreasing. People in the UK starts to prefer electric bikes to traditional bikes.
- The increase of e-bikes is exceptionally significant in Q4 in 2015, when for every imported manual bike, there are 8 e-bikes been imported.