Friday, October 23, 2009

Assignment No. 2 T D Google Visualization API

A project manager wants to track the progress of his project.The Manager wants this information to be available to the other members of his team and also to his Superiors in the Organization.The Project Manager can achieve this by making a Gantt Chart for the project.A Gantt chart is a type of bar chart that illustrates a project schedule. It is a graphical representation of the duration of tasks against the progression of time.It is a useful tool for planning and scheduling projects and also monitoring the progress of projects.

Using Google Spreadsheets and the Google Visualization API the Gantt Chart can be made available to the entire team.The Gantt chart component can be added as a Gadget to the Google Spreadsheet and to publish the Gantt chart on a web page the Google Visualization API can be used.Google Visualization API enables you to expose your own data, stored on any data-store that is connected to the web, as a Visualization compliant datasource(in this case a Google Spreadsheet).Furthermore,if the manager wants other members of the team to update their progress on the Spreadsheet,he/she can enable this by using the Google Spreadsheets API.The team members can track their progress as well as the progress of the entire project .As and when the data in the Google Spreadsheets gets updated, the Gantt Chart made using the Google Visualization API will get Updated as well.

The fact this can easily be embedded in HTML pages gives it an advantage over other Gantt chart implementations such as no additional software needs to be installed to view the Gantt Chart and the Gantt chart can also be viewed over mobile devices with internet browsers.

The following is an example of how this can be achieved:

GANTT CHART:



The Google Spreadsheet from which the Gantt chart is being populated can be viewed here:

http://spreadsheets.google.com/pub?key=tH_dK_13Xc0UMaSYPbQdWKQ&single=true&gid=0&output=html

No comments:

Post a Comment