How to use: Events Industry & UN SDG Dashboard

-
For this week's Makeover Monday, I created a dashboard to better explore the data set.  Here's a video highlighting how to take advantage of all the filters in the dashboard. 





Comments

  1. AnonymousNovember 26, 2019 at 9:56 AM

    Hi, I've just seen your updated version (which looks great by the way) and I saw you added a button to toggle between metrics. How did you do this please?

    ReplyDelete
    Replies
    1. haengbokehNovember 27, 2019 at 11:09 AM

      Hello, thanks for your interest! I used the optional metrics feature to enable the toggle. Here's the Data Studio Help Centre Article on it - https://support.google.com/datastudio/answer/9484925?hl=en

      Delete
    2. AnonymousDecember 1, 2019 at 5:26 PM

      Thankyou so much. I must have somehow missed this feature. Very useful.
      By the way the sunshine hours one is fantastic. Can't wait for you to publish this. Creating these is beyond me so rely on clever people like you to make them.
      Thanks again and keep up the great work your doing

      Delete

Post a Comment

Popular posts from this blog

Tip: Create a radar chart in DS using built-in area charts

-
Image
For this week's Makeover Monday , I made a 4 sided radar chart in Data Studio (DS) with the built in area chart. Note: This method works well for 4 sided radar charts but may not work with more variables due to limitations within Data Studio 1. Data Preparation Date for X values An area chart in DS requires a date for the X axis and a metric for the Y axis. Since I wanted to put Spring/Fall on the Y Axis and Winter/Summer on the X axis, I had to convert the Spring/Fall percentages to dates. I did this by choosing Jan 1 2019 (an arbitrary date) to be "0" and added/subtracted by the percentage point to get the final date values. Use a top and bottom area chart My area chart is actually composed of two area charts - one for the top and bottom. The reason for this is because DS doesn't handle negative Y values well and the background colour gets affected. You'll get something like Figure 1 if you use a negative Y value and it would be a hassle to fix the ba...
Read more

Trip Report: Japan - Oct 2019 (Part 1)

-
Image
A couple weeks ago, I went on my first trip to Japan (solo). It was a very rewarding experience but I had my share of unexpected events that I had to deal with. Part 1: Tokyo - Asakusa, Shinjuku  Day 0 -  Canada / US / Japan     I had difficulties even at the start of my journey because I tried to bring a hiking pole as part of my carry-on. Security wouldn't let me through with it. The airport storage fees were too expensive so I decided to test my luck and left my hiking pole in a washroom stall. Sadly, I never saw it after that ..    On my flight from Chicago to Tokyo, I realized how much I hated long distance flights. It was especially rough because the person sitting in front of me decided to maximize their chair's recline. On a positive (?) note, I set a record of watching 5 movies on the flight. I thought American Airline's flight food was better than my previous experiences with Air Canada, although I couldn't say it really impressed me....
Read more

Creation of ISS Spacewalks - Makeover Monday

-
Image
Earlier this year, I created one of my first Makeover Mondays on Spacewalks . This post walks through my data preparation steps and considerations I made while creating the visualization. Preparing the data set 1. Examine the data set for completeness  I sorted each column to find missing data. The Spacewalkers column had some "n/a" fields so I filled in these values manually. 2. Add extra information to data set I wanted to add the nationalities of the Spacewalkers and countries of the spacesuits to the data set.  For the nationalities, I used a vlookup to append the data based on the name. However, I did have to be careful about different name spellings used in the data set compared to Wikipedia .  As for the spacesuits used in a spacewalk - I entered this manually based on the footnote symbols in Wikipedia . American spacesuits and Russian spacesuits were used depending on where the mission took place.  3. Final check I recreated the ori...
Read more