In 2015 more than 20 million Indians travelled abroad. In the same year India’s diaspora population was the largest in the world with 16 million people from India living outside their country.
These two figures made us curious to find out who visits India. The available credible public information came from data.gov.in, the original source being Ministry of Home Affairs. We were able to aggregate count of India Visa issued across Indian Missions abroad by year/ month/ date. The time period for which data was available is July 2010 till January 2014. Note: The published data was missing information from 33 countries with Indian Mission and 9 Visa Types.
Below are the insights gained after feeding the aggregated data through the Data Explorer tool
2013 was the year in which largest count of Visa was issued
Most foreign nationals apply for Tourist Visa, followed by Business Visa.
In USA most of the Visa are issued in New York and San Francisco Missions and not Washington DC
Top 5 countries where most Visas are issued – Bangladesh, United Kingdom, United States of America, Germany and Sri Lanka
Top 5 countries where most Employment Visa, by count, are issued – Germany, Japan, United Kingdom, Korea and Australia.
Top 5 countries where most Student Visa, by count, are issued – Nigeria, Bangladesh, Korea, Yemen and France
Top 5 countries where most Missionary Visa, by count, are issued – USA, Armenia, Norway, Egypt and Kenya
Interestingly Pakistan is the only country where Pilgrimage Visa were issued per available data
Gramener’s Richie Lionell writes in defense of Excel
I come from a tribe whose first brushes with data visualization began with Excel. It all started when my former boss in early 2011 said, “Have you heard of charts that fit into an Excel cell? Please can you find out what that is all about?” In-Cell charts were an eye-opener but thankfully my eyes were also opened to what one could do with shapes, colors & tweaked charts. The world of Python, D3.js, design & story telling then beckoned me and it was hard to resist. I took the plunge but in the overflow of joy that followed I haven’t left Excel behind.
Excel????? – People cringe and then I show them a few unconventional visuals we’ve created using Excel;
A 0.5 grid Lat-Long weather map of India we created on Excel cells – supported by VLOOKUP, IFERROR, a scrollbar & conditional formatting – is a major draw at our Dataviz trainings. It is a visualization of dry days in every 0.5 degree Lat-Long grid from 1977 to 2005. No images or shapes were used. Yup, no VBA too & created using Excel 2010.
How about using Excel for some story telling? This one is the story of Hollywood stars, the data coming from an Excel table.
No, the pictures of the celebrities are not images. They are Dingbat fonts (Ever wondered the use for Webdings & Wingdings?). No VBA here too, just the usual suspects – VLOOKUP, IFERROR – and a bunch of radio buttons.
Here’s a simulation of a chess game (Dingbats again).
You can do all of the above using Excel 2007. Yes, you read that right. Now open your Excel application and plead for forgiveness. With this newfound respect for Excel you can now learn how to Visualize Sensex returns in Excel.
It’s fascinating to watch the ebb and flow of traffic in Bangalore. Here’s an animation of the Monday traffic at the Silk Board junction, which is notorious for congestion.
Through the night, the traffic is fairly slow. But from around 5:00am, a slow build-up of traffic starts from the south. This is mainly the commercial and bus traffic from Tamil Nadu entering Bangalore, to the point that there is a jam on Hosur Road by 5:30am. This stabilises by around 6:30am though.
Up to 7:30am, the junction is fairly free. From then on, the heavy traffic builds up on the east-west Outer Ring Road. Eastward traffic from BTM layout and Westward traffic from HSR layout get bottleneck-ed at the signal. The north-south Hosur Road is relatively free.
But by 8:30am the signal is completely choked and stays that way through the morning.
This continues until post-lunch, when the traffic gently lets up. At 2:30pm, Silk Board isn’t dangerous.
But by 3:30pm traffic starts building up again to the point that by 5:30pm the signal is completely choked.
By 6:30pm, Silk board is a signal you don’t want to cross. It would save you an hour to get off your vehicle, walk a kilometre across the signal, and get into another vehicle.
By around 11:00pm, the traffic has let off.
On the other hand, Sunday is a significantly better experience. There’s really heavy traffic only between 5:00pm to 8:00pm.
About the images
We used Selenium to take screenshots of Bangalore traffic every 5 minutes from Google Maps and animated these. ImageMagick helped crop to Silk Board and animate it as GIFs.