Wednesday, February 15, 2012

Zoho Reports

Brief Description of the tool:
Zoho Reports is an Online Reporting and Business Intelligence service that helps to easily analyze business data and create insightful reports & dashboards for informed decision-making.

It is easy to use, provides a user-friendly drag-and-drop user interface. It also offers a wide variety of reporting options like dashboards, charts and tabular reporting options that help you do your business intelligence analytics easily. It also provides advanced features such as - Pivoting (or Crosstabs), querying using SQL in all major database dialects, filtering, drill-down and extensibility with Application Programming Interface.

Being a cloud-sourced application, it requires no hardware or software installation. Also, it can easily be accessed with a browser and an internet connection, anytime, anywhere.

Some of the features of Zoho that we’ll be using:
1. Importing data from an existing database: Zoho lets us import data from an already existing database application such as Excel, Google Docs, MS Access, MySQL, SQL Server, Sybase, PostgreSQL and Oracle.




2. Drag-and-drop based Chart Creation: Zoho lets us use a drag-and-drop based designer to create required charts.




3. Multiple Chart Types: There are several chart types available to aid better visualization of data, such as: Line, Scatter, Bar, Stacked Bar, Funnel, Web and Table chart types. Both 2D and 3D charts are supported.




Description of Data used:

LinkedIn contacts of a particular user would form the raw data for the final presentation. Currently, LinkedIn does not provide option to export all contact related data in an easily usable format say csv. The basic ‘export connections’ would just extract the name of the person, current job and email ID into a csv file. So, we use a freeware available on the web called ‘LinkedIn Contact Manager’ (LICM) to get all contact related data into a single spreadsheet (screen shot shown below).





Additionally, a paid software titled ‘LeadGrabber Pro’ was used in trial mode to search LinkedIn connections with a particular keyword (say by Profession or by current city) and extract contact information from them. The relative advantage of this tool over the earlier one was that it allowed to search by specific keywords which gives more meaningful and relevant results than getting all contacts. But a relative disadvantage was also found in the fact that it extracted the records page by page and needed human intervention after each page (screen shot shown below)



Business Value

1. Better visualize your network – The combination of tools used will let the user better visualize his/her network on any Social Networking Site. The example data will be taken from LinkedIn to demonstrate the viability. The data can yield valuable insights about a user’s network such as – sorting of connections based on key attribute (city, industry, designation, number of connections).

2. It can be useful for Marketing Managers who can use their company’s official social media accounts, to help in –
  • Lead generation
  • New campaign launches
  • Market Segmentation and targeting for improving the effectiveness of Marketing communication.

3. It can be useful for the HR managers in ways such as –
  • To hunt for eligible candidates for recruitment.
  • To target a recruitment campaign based on – city, industry, job position.
4. It could be used by promoters of educational or industry events to target potential audiences and design effective communication/promotion material

Friday, March 18, 2011

A potential solution to plastic pollution problem


In a recent special gazette notification dated 4th February, 2011 the Ministry of Environment & Forests, directed all municipal authorities across the country to encourage use of plastic waste by adopting suitable technology such as in road construction. It was inspired by the work of Dr. R. Vasudevan, Dean and Head of the Chemistry Department at Thiagarajar College of Engineering (TCE), Madurai. He has been teaching since 1975 and worked on his idea of using plastic waste in road construction for more than a decade, developing and improving it.

He was further motivated by the 2001 visit of Dr. A.P.J. Abdul Kalam to TCE, then President of India when he asked him to carry on with his good work and set an example.

Dr. Vasudevan laid the first 60-foot road within the campus of TCE and hasn't looked back since. Numerous plastic roads have been laid in the state of Tamil Nadu, Andhra Pradesh, Kerala and Goa among others. The technology is simple. The bitumen gravel is heated with shredded plastic. The plastic instantly melts and forms a coating over the gravel thus making it more resilient to temperature and pressure. There are a number of benefits: Low cost of road construction, removal of waste plastic from the environment, increased strength of roads and lower consumption of bitumen coal.

Saturday, October 30, 2010

Oorja Video : The Energy Quest




Here is the link to our video.

Oorja

Oorja, meaning Energy is the thing that powers the whole world. With the days of industrial revolution, energy has become an indispensable part of our lives. We hope to bring out the technological innovations that are happening in this area in this blog. Keep watching this space for more.