Back from vacation and catching up on the last two Makeover Monday exercises. I tried the New Zealand RTI one from week 4 first.
The first thing I created was a line chart that showed the RTI by visitor type by period. I filtered the dashboard to just the Total Region and excluded 2008 from the chart. The definitions listed RTI as the change in expenditure by Region comparing the month to the average month in 2008, so, I figured 2008 didn’t need to be included.
There were a lot of options with this data set and I spent longer than it may seem on this one. The thing I kept coming back to was the difference in the RTI in Winter between domestic and international visitors. So after reading a lot about New Zealand weather I decided to go with that.
The viz itself is simple – a line chart to show the RTI trends by visitor type and a list of the 10 Regions with the largest difference in RTI between domestic and international visitors during the winter months.
Let me know if you think I missed the mark here or have any suggestions or feedback!