Train Vs Plane: MakeOverMonday W38 2018

Pretty simple dataset but datavisualization can do wonders in pointing out the outliers and getting audiences focus in areas the dataviz author wants to. Here is the original viz.

I like the original viz because it’s neat and gets the message accross by comparing the ticket prices w.r.t to how many weeks ahead they were bought. So the data is a comparison of the variance of Plane and Train ticket prices for different source and destinations.

I had been itching to create a viz using Jump plot, that I have learnt after reverse engineering @NilsM09 and @MarkBradbourne vizes. This data was pretty apt for that. Had to do some dataprep using Alteryx.

In the viz, the x axis signifies the % difference between ticket prices of Train and Plane. While the hieght of the jump plot signifies the Train tickets price. The outcome is quite surprising, given that sometimes the Train ticket prices are higher than flight prices, although it’s not often.

 

Avocado Price: MakeoverMonday W40 2018

This particular one was a bit interesting as the data was in very detailed format. There was a lot of interesting and wonderful dashboards already created by the makeover monday crew and I was wondering how to visualise the data a bit more differently. Before we get there here is an overview of the original visualisation.

Its an average overall dataviz.

What I wanted to do was to compare the average and total price of avocado quarterly. In order to do so I decided to blend and edit the data in Alteryx. The idea was to get the Weeks for each date, then to which quarter of the year it belongs to and lastly count the weeks for each quarter and reset the week to 1 for each quarter.

In the final dataviz I have got a line chart comparing current quarter with the previous quater and the previous year’s same quarter as current quarter.

Look at total price of Avocado region wise. Look at QTD total price, volume, days left. Glimps of last 5 days total Avocado price. Also a quaterly metric of total price for conventional and organic Avocado.

 

Makeover Monday W28 – 2018, Volcano Eruptions

It was a very informative Makeover Monday this time. I had to go through a few articles to understand the data-set properly. I have a little better understanding of which countries have volcanoes and what the main rock type or the primary volcano type is, and about the ring of fire etc.

I liked the original viz. Please see below:

It denotes different volcano types with different shapes and colored with respect to the eruption date from past to present, representing past to present as lighter to darker.

What I tried to do is to focus on one of the countries. My pick was Japan, including Japan administered by Russia. My aim was to:

1. Have a closer look at the volcanoes on the map to know their exact location,
2. Highlight the main volcano type in Japan, and
3. Visually represent the volcanoes below and above sea level.

Japan is heavily affected by volcanoes and hence I thought it would be a good pick for analysis. Please find my viz below.

 

 

Click here for interactive viz

 

 

Monday Makeover W27-2018 – Rat Sightings in NYC

New York city is densely populated by rats. It doesn’t matter if the area is highly populated or less populated. They are all over the place. They can pick up disease and can be carriers, causing more destruction to the environment. In this week’s Makeover Monday we have tried to recreate the data viz originally done by Jowanza Joseph . It’s very well done.

What I tried to do is:

• Created another viz to compare the 2017 Rat Sighting with other years, month-wise
• Show a heat map of Rat sighting reported year-wise
• See how the different boroughs of NYC did with Rat Sighting from 2010 to 2018

Interactive Viz here.

Here is the post code map.

Interactive viz here