vida amorosa

Vizualyse PK

Hi Folks!! The world is getting more interesting with the ways we are experimenting with the data visualization. The journey started with the tableau followed by qlikview and now in google charts. The purpose of this blog is to make the candlestick chart on the stock prices of Tata Steel downloaded from Quandl website. Quandl is an interesting source of the data where we can download the stock prices of various companies listed under NSE. The other databases are premium and can be accessed only after we pay certain amount of money. It is a same old story. Lets get to the point. The reference of java script code is "http://visual.yantrajaal.com/2013/12/plotting-nse-stock-price-data-from.html". Google Chart Example

The Dashboard on this blog Data Source

Hi Folks!! We are back the main aim of this blog is to create a simple dashboard  showcasing the states with the hindus and buddhists count. However we are focusing on making the barchart for the same. 1) The sheet is "https://docs.google.com/spreadsheets/d/1RDq4f3L8NUIRpQu55F6Lfw2Tp1g3vJlZYHrXSmlXT0U/edit#gid=0" 2) the respective columns are A, B and F 3) The headers are 1 4)The columns are from A1 to I31 Basic Column Chart Showing All Data Data Source

Hey .... I am planning to work on an interesting piece mapping the dps addresses in google maps in Delhi Area. The referance has been taken from my professor's blog "http://visual.yantrajaal.com/2013/12/showing-addresses-on-google-map.html".

As part of learning continues we would plot the cities in the google map. The exercises mostly have been taken from https://developers.google.com/chart and http://visual.yantrajaal.com/2013/12/cities-of-india.html. Interesting Isn't It? We have a data that contains the number of registered vehicles in different years Steps to be followed: 1) The doc link is https://docs.google.com/spreadsheets/d/1rrz2aobU3Htc4Ez6Alcga_ROhRo2ZyzKsrkmL-cTOT4/edit#gid=0 where the shet is CityWise 2 and range is identified by sheet = CityWise2 2) The range is identified by range = B2:M23

The part 2 was a simpler example to create a chart on the google doc where we could manipulate the data as per our whims and fancies.  In reality the situation is quite difficult as the client google doc or even yours can have a huge amount of data. We need to manipulate the code to select a range of data We are running a series of two subparts of this blog Part A and Part B.  Part A I have taken reference entirely from the prof blog "http://visual.yantrajaal.com/2013/12/creating-google-charts-from-google-docs.html"  In this we need to look at the chart based on the following selection of the data  1) Data to be picked up from sheet named "Demo3"  2) Within this sheet, from the range C3:I23  3) Within this range from the columns C, D, G, H 4) Given the nature of the data we would like to multiply column G by 1000 before it is plotted # Sheet 2 Chart - Sheet, Range, Cols

In this part we are able to access the data from the google docs.Please refer the ink for the same https://docs.google.com/spreadsheets/d/1XlFRycSwEz5mmo8ZWgKjxGY9kyYjeFgFRk7ujTU6R6w/edit#gid=0 The changes you make would be updated in the blog. This is better in blog part 2 for data visualization compared to the blog part 1. Here compared to part 1 I have changed the width to 800 and height to 1200 Data from a Spreadsheet

This blog is a part of series I am starting to give you an insight into the beautiful world of story boarding with data. In this we would be using the google charts platform to create a simple chart First lets look into a simple pie chart that can be build  using the google charts. How Much Pizza I Ate last Night Interesting the catch here is not to eat pizza but to show a simple pie chart containing the ingredients While creating the blog we have a html option  the java code is written there and the article is published http://visual.yantrajaal.com/2013/12/basic-google-chart.html and here i can put some text