A guide to online data plotting

http://www.livemint.com/2012/01/24211809/A-guide-to-online-data-plottin.html

A guide to online data plotting

When you’re deal­ing with com­plex data, visu­al­iz­a­tion tools can help you sim­pli­fy it and, more im­port­antly, spot key trends and gain new in­sights

Shweta Taneja

Sales fig­ures, con­sumer be­ha­vi­our and mar­ket re­search – the work we do of­ten in­volves un­der­stand­ing and com­mu­nic­at­ing a lot of com­plex in­form­a­tion. To make good de­cisions, you need to be able to un­der­stand the data, and quickly. Visualization tools can sim­pli­fy data, and make it easi­er to un­der­stand and spot key trends.

According to Deloitte’s “Tech Trends 2011: The Natural Convergence of Business and IT” re­port re­leased in March, data-visualization tools were the fast­est de­vel­op­ing area in soft­ware last year.

Data in, graphic out: Visual representations of data are easier to understand.

Data in, graph­ic out: Visual rep­res­ent­a­tions of data are easi­er to un­der­stand.

“Data visu­al­iz­a­tion com­presses in­form­a­tion quickly,” says S. Anand, 37, chief data sci­ent­ist, Gramener, a Hyderabad-based data-visualization com­pany. “For ex­ample, in a chart, a bar can give you a data set with its height, col­our and thick­ness, so you have already com­pressed a table with three columns in­to one graph,” he ex­plains. “A 40-page re­port can eas­ily be con­ver­ted in­to a single page of graph­ics.” By do­ing this, a large amount of data be­comes eas­ily ac­cess­ible, and trends and high­lights are easy to pick out, com­pared to a table of num­bers.

“Data-visualization tools are typ­ic­ally de­signed to high­light rel­ev­ant in­sights, rather than just present raw data as in a dash­board,” ex­plains Stewart Langille, co-founder, Visual.ly, a new on­line visu­al­iz­a­tion tool. Another use­ful as­pect of view­ing data as visu­als is that you can high­light the in­form­a­tion that’s really im­port­ant and even get new­er, com­pletely un­ex­pec­ted in­sights in­to the data sets.

Like the idea? We list some of the most in­nov­at­ive on­line data-visualization tools:

Tableau Public

Website:www.tableausoftware.com/public

After you in­stall the soft­ware, you en­ter the data either as a spread­sheet (Microsoft Excel, Microsoft Access) or text file with tab spaces. The soft­ware reads the file to identi­fy vari­ables. Once you choose the rel­ev­ant vari­ables, it cre­ates a visu­al chart of your data. The soft­ware auto­mat­ic­ally tries to give the right kind of chart, but you can also manu­ally choose from op­tions such as bar charts, his­to­grams, scat­ter plots, bubble charts, pie charts, bul­let graphs, maps and heat mat­rix, etc. Tableau charts can also be in­ter­act­ive, so view­ers can re­arrange the data to ana­lyse it from dif­fer­ent per­spect­ives. The chart is saved on www.tableausoftware.com

The down­side is that visu­al­iz­a­tions and data are pub­lic — any­one can down­load your work. To keep it private, and for ad­ded fea­tures such as more fil­ters and rep­res­ent­a­tions, you could buy the Personal Edition for $999 (around Rs. 50,300), or the Professional Edition for $1,999.

Cost: Free to use, with paid edi­tions start­ing at $999.

Many Eyes

Website:www-958.ibm.com

Many Eyes, launched in January 2007, is one of the first data-visualization tools, and was cre­ated by IBM Research. You have to up­load your data to the site, and can view it as a scat­ter plot, mat­rix chart, net­work dia­gram, bar chart, block his­to­gram, bubble chart, graph, pie chart, tree­map, and many oth­er visu­al­iz­a­tions. The up­load pro­cess is cum­ber­some, though — you can copy-paste, but only from a prop­erly format­ted text file, not a spread­sheet. It ac­cepts a spe­cific style of rows and column data. So even if you have a spread­sheet, you might need to ed­it it to make sure Many Eyes un­der­stands your data.

As with Tableau Public, whatever data you up­load be­comes pub­lic prop­er­ty, but un­like Tableau, there is no paid, private op­tion.

Cost: Free to use

Spotfire Analytics

Website:spotfire.tibco.com

The soft­ware cre­ates an in­ter­act­ive dash­board which shows your data and your company’s pro­gress to you at a glance through 3D graphs. You can also use the dash­board to give your cli­ents or in­vestors a clear pic­ture of ex­actly what they are in­vest­ing in. All you need to do is drag and drop your Excel or CSV-formatted text files in­to Spotfire, and then start play­ing around with your data. The ana­lys­is can be shared or em­bed­ded on web­sites, blogs or so­cial net­works, and there is no down­load needed as it runs off the Web. A paid ser­vice, Spotfire keeps your data private.

Cost: Starts from $199 per month.

QlikView

Website:www.qlikview.com

QlikView is meant to find new busi­ness an­swers to prob­lems through data ana­lys­is. The tool also of­fers com­par­at­ive ana­lys­is of a pro­duct or per­son. QlikView also has ver­sions for smart­phones and tab­lets, and is well suited to use on touch screens.

Cost: QlikView Personal Edition soft­ware is free, but you can only use it to ana­lyse data, not share your res­ults. To share data, you need the en­ter­prise ver­sion. Pricing var­ies, so con­tact www.qlikview.com

Visual.ly

Website:Visual.ly

A col­lec­tion of in­fograph­ics from vari­ous pro­fes­sion­als in the in­dustry, Visual.ly al­lows users to eas­ily share charts and in­fograph­ics. In March, the com­pany plans to launch a free on­line tool to con­vert data in­to visu­als — there is a small de­mo avail­able on the web­site where you can con­vert your Twitter feed in­to an in­fograph­ic about you.

The in­put data has to be in known data sets like Excel and CSV files. Users need to cre­ate a lo­gin for the tool, in­put their data and se­lect from a choice of tem­plates to cus­tom­ize.

Cost: Free. Paid pack­ages are ex­pec­ted but have not yet been an­nounced.

FusionCharts Suite

Website:www.fusioncharts.com

FusionCharts Suite is an Indian com­mer­cial visu­al­iz­a­tion tool which can con­vert any data­base or Web script in­to Flash or HTML5 charts, gauges and maps. Creating the chart takes 15 minutes, and you can choose from over 90 types of charts. The visu­al­iz­a­tion helps in ana­lyses of data by giv­ing trend­lines, col­our ranges and num­ber scales. You can choose sub­sets, tips, ex­port charts and do visu­al edit­ing. Once you are ready, the chart is rendered and can be shared or em­bed­ded in a web­site. You can choose wheth­er the chart is ed­it­able by oth­ers, and can use the soft­ware to cre­ate real-time charts that up­date auto­mat­ic­ally.

Cost: One-time pur­chase for com­mer­cial use starts at $1,299. For per­son­al use, you can get a li­cence for $499. Also avail­able as ex­ten­sions for Flex (start­ing at $299), Dreamweaver (start­ing at $69) and VisualBasic 6 (start­ing at $99).

Leave a Reply