Sunday, January 3, 2016

Who is the most valued MLB player based on the WAR value?

I have participated in the first #MakeOverMonday challenge by +Andy Kriebel to visualize who the most valued MLB players are based on their Wins Above Replacement (WAR).

In the article,, data was presented in a tabular form. Sometimes, data is much easier to understand visually than the tabular form and these are some reasons;

1. Hard to see what is the surplus across all players?
2. How are players salaries and WAR adjusted values are related?
3. Is the WAR changing over year?
4. How are players salaries compared to each other?

To answer above questions, I used dumbbell dot plots to show players salaries, their WAR adjusted values, and surplus amount.

First attempt was to showcase which MLB player has the most WAR adjusted value regardless of the year. This is the screenshot of the overall visualization and the link to view Tableau Dashboard.

Given the year as one of the dimension, I also attempted to show data by year and by player. Used dumbbell dot plots also for this version. This is the screenshot of the Per Year visualization and the link to view Tableau Dashboard.

Thursday, December 24, 2015

Which city has longer days; Aurora, IL or San Ramon, CA ?

The summer of 2015, my family and I relocated from Aurora, IL (suburbs of Chicago, IL) to San Ramon, CA (suburbs of San Francisco, CA). The first thing my family and I noticed was that there is definitely more sunlight in San Ramon. Thinking of sunlight, I asked my elder daughter Rishika if she thinks that the days in CA seem longer when compared to IL, she said, Why don't you viz that!” This is what I ended up with...

The first thing I did was look for Sunrise and Sunset times on the web and I came across website. I downloaded the data for Aurora and San Ramon for 2014 and started to visualize.

As I started to visualize, I was totally surprised to see that the two cities have longer days in different months. During the summer months, the Sun rose earlier in Aurora and the sunset was pretty close in both cities. Whereas in winter months, sun rose at the same time in both cities but the sun set a little later in San Ramon. Overall, to my surprise, Aurora, IL has 6 hours and 20 minutes of longer daytime in a year.

Here is the viz that gives which city has longer days daily, monthly, and annually.

Tuesday, August 26, 2014

Build Emerald City with Tableau!

When Tableau announced #VizAsArt a Data Visualization Art contest, I was thrilled and decided to participate in the contest. These are the two reasons why I decided to participate;
  • Data contests are fun and a good way to learn. This is how I actually got hooked onto Tableau with my first data visualization RunViz
  • I have an eye for the art and design, but was never good with my hand to create any art. Well with Tableau, as always, there are no excuses and thought to give it a shot.
I used Chicago 311 data from City of Chicago Data Portal for the contest.

In a typical data analysis project, data analysts will have the data and set of questions to answer or discover something from the data. Whereas, in a #VizAsArt projects, typically there are no requirements and all we have is the data and a White Canvas. Coming up with a non-functional art was challenging, but trust me it was fun and worth it.

How I came up with the “Emerald City” idea?

Idea for the “Emerald City” came to me while I working on a Customer Survey Project at work. Was looking to build a view to see the number of surveys done by channel and by the quarter. Dragged QUARTER (Date) continuous measure on to the column shelf, survey channel on to the row shelf, number of records to the color shelf, and QUARTER (Date) continuous to the Size shelf. The view ended up like below.

To make the marks appear clearly without overlapping, I reversed the size legend and the view ended up as below.

This looked to me like a sleeping Sears’s tower (or we call it Willis tower now). Immediately, my Tableau and artistic bulbs went off and my right brain was going crazy. I swapped Rows and Columns and it really looked like a building. 

That was the idea behind the Emerald City and really had no clue on how this would end up or look as the final product, I put on my construction hat on started to work.

Emerald City Under Construction

Dragged ‘Type of Service Request’ on to column shelf and ‘Week (Date)’ continuous on to row shelf, Number of records to color shelf, and finally Year (Date) discrete pill onto the size shelf to get a stacked bars. For the #VizAsArt contest, we were limited to use only four colors, so I changed the color pill to stepped colors and with two colors.  

I wanted to see how my building would look if I changed the Year (Date) to Quarter (Date) on the size shelf, BOOM! another building structure as below. Saved this as another sheet.

By changing mark types to circle creates a sheet. With mark type as Shape and with different types of shapes, and varying the Date on the size shelf to months, weeks, hours, etc. I ended up creating quite a few buildings, towers, etc. 


No two buildings are of the same height, filtered out some of the data randomly from some sheets and/or increase/decrease the axis in the other to get that effect. Now that we have few worksheets, played with the column filtering and kept one or two buildings on each worksheet, so when they are placed on the dashboard, adjacent buildings will not look the same. There you go...

Felt like something was missing from the art (remember I told you that I have an eye for the art), decided to add Sun to which would complete the art. 

I am deeply thankful to Dave Hart from InterWorks, EU for his Radial Bar Chart technique which I used to create the Sun. Check out his blog on how to create radial bar charts in Tableau.

Sun gave the finishing touch and I felt my #VizAsArt was complete.

Wait, every artwork should have a name and as the default color was green for the measures, I decided to call it “Emerald City”. 

Hope you like my art and I am sure you are ready to build your own towns, cities, skyscrapers, etc.

P.S I am already thinking about this year’s “Seasons greetings cards”. Star shapes make a nice Christmas tree :)

The City of Chicago ("City") does not endorse, sponsor, or provide preferential treatment to, any third-party websites or persons or other entities associated with third-party websites. The City does not control third-party websites and, therefore, does not warrant that third-party websites are accurate or reliable or have operational links. By selecting a link to a third-party website, users leave and become subject to the terms of use, privacy, and security policies of the owners/sponsors/operators of the third-party website. By selecting a link to a third-party website, users release the City from any liability for any injury to any person or property caused by the user's or users' accessing a third-party website via a link on the City's website. 

Using the Chicago 311 data from years 2012 and 2013.

Monday, August 11, 2014

Do we produce enough food to feed the hunger?

On one side we are wasting 33.3% of the food that is being produced in the world and on the other side 33% of the world's population is starving. 

This data visualization is an effort to tell a story using both Global food loss/wastage and hunger/malnutrition statistics.

CAUTION: Some of the data and story points in this viz could be disturbing.

#dataviz #foodloss #hunger #malnutrition 

Click on grey story points or <> arrows.

Friday, June 20, 2014

Chicago Marathon - Battle of the Sexes

Anytime of the day when you go out into the streets, there is a greater chance that you will spot a runner. Running as a sport, became popular when U.S. won the first Olympic gold medal in 1972 marathon. More and more people are taking up running and are participating in different races including; 5K, 10K, Half marathon, and Full marathons. 

#Tableau #dataviz #showandtell

Friday, April 25, 2014

Do all Bay Area cities look alike with their Bike Share Program?

When the weather is sunny and beautiful in Bay Area, it is always a pleasure riding bikes from Bay Area Bike Share program.
This is the information from their website:
“The Bay Area Bike Share is the region’s bike sharing system with 700 bikes and 70 stations across the region, with locations in San Francisco, Redwood City, Mountain View, Palo Alto, and San Jose. Intended to provide Bay Area residents and visitors with an additional transportation option for getting around the region, the Bay Area Bike Share is fun, easy, and affordable.”

Recently, Bay Area Bike Share announced their first open data challenge to find patterns in their data. As part of my data analysis, I wanted to compare all five cities in Bay Area and see if they are same or different. Check out my viz below using Tableau.

Want to know more about Bay Area Bike Share, check out their website:

#tableau @SFBikeShare #dataviz

Sunday, March 23, 2014

Cost of Human Life and Human Trafficking Worldwide

Human Trafficking is the trade of humans of all genders and age groups for the purpose of forced labor, sexual slavery, commercial sexual exploitation, low-level criminal activities, begging, and extraction of organs or tissues. Human Trafficking is a global problem and can occur within the country or internationally. Human Trafficking is a serious crime and a grave violation of Human Rights.

Slavery and the trade in human life considered an historical artefact, but it still very much persists in in the modern world. As per UNODC: Global Report on Trafficking in Persons (2012), annual profit generated by Human Trafficking for forced labor worldwide is US $31.6 Billion.

STOP Human Trafficking. 

Human Cost Data Viz Challenge designed for “The Kantar Information Is Beautiful Awards

#Tableau #InfoBeautyAward #DataViz