Makeover Monday 2019 Week 8: Wind Power in the United States

This week’s Makeover Monday dataset looks at the status of wind power in the USA.

What works well?

  • The chart is sorted which makes it easy and quick to see the states with the highest wind power capacity.
  • The investment figures below the x-axis add some context to the viz.

What could be improved?

  • The turbine bar charts are unnecessary and distracting. It is harder to make comparisons since the shapes block the bars of other states. Using simple bars would be clearer.
  • The labels get very small on the right side of the chart making them hard to read. The chart could be widened to give the labels more space.
  • The y-axis scale is not accurate. The distance from 100 to 1,000 looks the same as from 5,000 to 10,000.

What Ryan did:

  • Created a hex map chart to show the wind power capacity of each state. I also wanted to bring attention to the states with zero capacity.
  • Looked into why the Southeast lacks wind power capacity and added an annotation (source).

What Marc did:

  • Created a bar chart focusing on the top 10 states by wind energy production.
  • Added scorecards to summarize the key wind energy metrics.
  • Applied chart interactions in Data Studio to allow the bar chart to be used a filter for the scorecards.
View in Data Studio

Makeover Monday 2019 Week 7: President Trump’s Official Schedule

This week’s Makeover Monday gives us a peek into how President Trump schedules his time, based on 3 months of leaked private schedules.

What works well?

  • Didn’t use a pie chart!
  • Minimalist design; High data-ink ratio
  • Clear titles and labels

What could be improved?

  • Honestly, not much.
  • Percentage labels would help more accurately compare the breakdown between categories.

What Marc did:

  • Recreated the original chart in Data Studio. There’s not much in need of a makeover.
  • Added percentage labels to the bars.
View in Data Studio

What Ryan did:

  • Created a Gantt chart to show Trump’s full schedule.
  • Coloured the periods of executive time in orange.
  • Added reference lines to frame the working hours.
  • Annotated some key events that took place from Nov-Feb.

Makeover Monday 2019 Week 6: Chinese New Year vs. American Thanksgiving

It’s Chinese New Year this week, and for Makeover Monday we get this chart that compares the Spring Festival in China with Thanksgiving in the United States.

What works well?

  • Colours are distinct and intuitive.
  • Values are labelled.
  • Circles are visually pleasing.

What could be improved?

  • Comparing the areas of circles is extremely difficult. Using bar charts would be much more effective.
  • Metrics are absolute totals and don’t account for the difference in population between China and the U.S.

What Ryan did:

  • Converted the total expenditure and trips to a per person amount and the TV viewership to percentage of population. Since China has a larger population, this makes comparisons easier.
  • Created bar charts for each measure comparing China and the USA.
View in Tableau Public

What Marc did:

  • I re-created the original graphic, converting the concentric circles to side-by-side bar charts.
View in Data Studio