Parallel coordinate plot in Tableau: a workaround

The parallel coordinate plot is useful for visualizing multivariate data in a dis-aggregated way, where we have multiple numerical measurements for each record. A scatter plot displays two measurements for each record by using the two axes. A parallel coordinate plot can display many measurements for each record, by using many (parallel) axes – one for each measurement. While not as popular as other charts, it sometimes turns out to be useful, so it’s good to have it in the visualization toolkit. Software such as TIBCO Spotfire and XLMiner include the parallel coordinate plot. There’s even a free Excel add-on. But … Continue reading Parallel coordinate plot in Tableau: a workaround

Data liberation via visualization

“Data democratization” movements try to make data, and especially government-held data, publicly available and accessible. A growing number of technological efforts are devoted to such efforts and especially the accessibility part. One such effort is by data visualization companies. A recent trend is to offer a free version (or at least free for some period) that is based on sharing your visualization and/or data to the Web. The “and/or” here is important, because in some cases you cannot share your data, but you would like to share the visualizations with the world. This is what I call “data liberation via … Continue reading Data liberation via visualization

ASA’s magazine: Excel’s default charts

Being in Bhutan this year, I have requested the American Statistical Association (ASA) and INFORMS to mail the magazines that come with my membership to Bhutan. Although I can access the magazines online, I greatly enjoy receiving the issues by mail (even if a month late) and leafing through them leisurely. Not to mention the ability to share them with local colleagues who are seeing these magazines for the first time! Now to the data-analytic reason for my post: The main article in the August 2010 issue of AMSTAT News (the ASA’s magazine) on Fellow Award: Revisited (Again) presented an “update to … Continue reading ASA’s magazine: Excel’s default charts

Creating map charts

With the growing amount of available geographical data, it is useful to be able to visualize one’s data on top of a map. Visualizing numeric and/or categorical information on top of a map is called a map chart. Two student teams in my Fall data mining class explored and displayed their data on map charts: one team compared economic, political, and well-being measures across different countries in the world. By linking a world map to their data, they could use color (hue and shading) to compare countries and geographical areas on those measures. Here’s an example of two maps that … Continue reading Creating map charts

Cycle plots for time series

In his most recent newsletter, Stephen Few from PerceptualEdge presents a short and interesting article on Cycle Plots (by Naomi Robbins). These are plots for visualizing time series, which enhance both cyclical and trend components of the series. Cycle plots were invented by Cleveland, Dunn, and Terpenning in 1978, and seem quite useful. I have not seen them integrated into any visualization tool, although they definitely are useful and easy to interpret. The closest implementation that I’ve seen (aside from creating them yourself or using one of the macros suggested in the article) is Spotfire DXP‘s hierarchies. A hierarchy enables … Continue reading Cycle plots for time series

Webcast on Analytics in the Classroom

Tomorrow at 11:00 EST I will be giving a webcast describing several term projects by MBAs in my data mining class. Students have been working on real business projects in my class for 4 years now, with many of the projects leading to important insights to the companies who provided the data (in most cases the students’ workplaces). For each of several cases I will describe the business objective; we’ll look at the data via interactive visualization using Spotfire, and then examine some of the analyses and findings. The webcast is organized by Spotfire (now a division of TIBCO). We … Continue reading Webcast on Analytics in the Classroom