Paying The President: W38 2018

Trump has been a menace and an eye sore in the world of politics since the day he decided to stand as a Presidential cnadidate. “Make America Great Again” is becoming more and more a necessity as days go by and we wake up to Trump ruling the U.S.A. This dataviz was one of my favourites as it showcases how Trump and his associates has been abusing the system since his presidential campaign and it’s still continuing.

Here is the original viz in pro publica.

 

Honestly I loved this viz. It conveys the message accross and highlights all the critical areas. Hard to top the original one.

In my viz I have used pareto chart to identifiy where did the Trump administration spent most of tax payers money. I have also used an interactive scatter plot which changes with each type of spending, with the month/year as the X axis and $ value as the Y axis.

Also this time I have added an info icon with information on how to read the chart while also highlighting that some of the data is missing for a certain period in the source file.

 

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.