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 http://data.cityofchicago.org 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 cityofchicago.org 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: http://bayareabikeshare.com

#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

Sunday, March 16, 2014

Which Quarterback has the most playoff touchdown passes?

When Tableau announced that March is going to be Sports Viz month, I first saw the news and thought to myself that I am going to take a pass on this one, as I am not much of a sports fan. Then being a Tableau fan and with a few viz’s in my bag, I embarked on the journey to create my first Sports Viz.

During my search, I came across lot of websites that listed out NFL quarterbacks passing touchdowns in regular season, but did not see sites that can show touchdown passes during the playoff season. While browsing through these sites my Tableau bulb went off and I decided to create a viz of quarterbacks touchdown passes during the playoff games.

Using sports data from sports-reference.com, below is my sports viz about “Which Quarterback has the most playoff touchdown passes?

I would like to thank sports-reference.com without which this viz would not have been possible. Also, I like to thank ESPN.com and Google/images for quarterback pictures.

Enjoy my Sports Viz ! #Tableau #IronViz

Wednesday, March 5, 2014

How Chicago gets around on Divvy?

Divvy is Chicago’s new bike share program with about 4,000 bikes and 400 stations across the city. Primary purpose of the Divvy program is to provide Chicagoans with an additional transportation option to getting around the city. Divvy means Divide and Share and is a fun way to getting around. 

In 2013, Divvy bikes traveled about 1.28 million miles, in about 261 thousand hours and made 759 thousand trips between different stations. Wow, that's lot of miles with smiles :)

Divvy riders are two types; members with annual passes who ride regularly, and casual riders or 24 Hour pass riders who wants to get around the city. 

Check out my Divvy Viz as part of the Divvy Data Challenge. 

Enjoy riding Divvy!

Wednesday, February 5, 2014

RunViz - Chicago Marathon Analytics

Crossing the 26.2 miles at the finish line amid the cheering crowd and loud music in addition to the adrenaline rush through the body brings excitement and a great joy to every Marathon Runner. It is a great accomplishment to cherish. 

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. 

Analyzing the runner's data from Chicago Marathon and using Tableau Software, I was able to answer the following questions:
  •       Who is running and who is winning?
  •       Countries participation and winners?
  •       Ideal temperature for runners?

Enjoy RunViz! and thanks for your voting!
RunViz - Winner of Tableau User Group Contest !