As somebody new to the concept of data visualisation, I found that creating data for web was pretty much a cakewalk especially after given the right set of tools. No longer were we manually making charts and graphs (as in the case of powerpoint presentations), but we were simply aiding the computer generated code by filling in the right set of fields to visualise data as charts, maps, graphs and timelines.
Here is a brief synopsis of how I went about learning basics of data visualisation with the help of Google Fusion Tables and Google Playground.
-An excel spreadsheet was created with information of me and my classmates and shared. The information included specifics like age, city, email IDs, state from which they belong, academic record of the past 5 years.
-After 'crowdsourcing', we went on Fusion Tables to enable visualisation of the information.
-The first information we wanted to organise was the collective age of my classmates. The class comprises of 20 students enrolled in MA in Convergent Journalism at Jamia Millia Islamia University, New Delhi. This information was attributed to the Fusion Table.
-To go to visualisation of the data:
Help>Get 'Classic Look'>Visualise
We found that the easiest way to represent the ages would be to show the data through bar graphs. Although we also attempted to show it through a Pie chart.
Visualise>Bar Graphs/Pie Chart/Scatter>Aggregate>Check 'age'>Change variables/entity to Count
Count will give a collective data of all the ages, rather than individual ages of each classmate.
-Next visualisation was to show the different states my classmates came from. For this purpose I had to check that the states were 'Geotagged'.. This means to checkif they were recognised by Google maps. The names of the states entered by my classmates and me created ambiguity for the software to recognise it. For eg: Jammu and Kashmir was written as 'Jammu & Kashmir' and 'J&K'. Such minor discrepancies led to information hidden from the map.
To show the data through the map:
Visualise>intensity maps> Check Location as States>Check Area as India
-The next visualisation we created was to show the academic record of 3 students over the period of 5 years. For this we chose 'Timeline' method of representation. However, our values in the google spreadsheet for Years 2009 - 2013 were not selected as 'Date/Time', so we had to create yet another table, specifying Value for Year as 'Date/Time' and names of students as 'Number' as their individual percentage.
-To add these visualisations to our blogs, we needed to generate a HTML code that could be embedded to them. For this purpose, we clicked on 'Get embeddable code'. The HTML link was simply copied and added to our tumblr accounts and Wordpress accounts.
Another tool used by us, was the Google Playground tool. Although at first it looked a little complex.Something that is used by coders and programmers. However, after choosing our API as Visualise. We were then given options to choose the manner of visualisation to depict our data. The Google Playground offered much more visualisations than Fusion Tables. However, we stuck with a familiar Pie Chart to show yet again, collective ages of the class.
For this,we had to directly interfere with the HTML code. This meant Changing Fields and Variables within the code without actually disturbing the structure of the code. After making these changes, we clicked 'Run Code' .
With the new data infront of us, we had the task of now embedding this data on our blogs.To do this we clicked on 'Edit HTML' that showed the whole HTML code. We copied it.
Now the task was to put it on our blogs. Wordpress proved to be complicated to accept this code. Next, we tried tumblr. After going to Setting>Dashboard, we changed the language from 'Rich text editor' to 'Plain HTML'.
This enabled greater ease of embedding the HTML code from Playground.
-All that was left was to press 'Publish' and voila! we managed to create our very own data.