Saturday, December 22, 2012

Interactive R&D Spend Analysis Tool

Presenting the “Interactive R&D Spend Analysis Tool”.  The motion chart, as used by Hans Rosling, is an extremely effective data visualization tool. I’m using the same to bring into perspective the business performance of technology companies.

As of now, the tool covers 27 companies spread across the following industries: Aero, Auto, Medical, Telecom, Consumer Electronics, Industrial/Heavy Equipment Manufacturers, ISV’s, Storage & Semiconductors.
I'll keep adding data points for other major companies to make this tool more effective.  Comment on the companies that you would like to see in this tool.


How to use the chart:    
Default settings: 
Y-axis plots the R&D Spend
X-axis plot the Net income
Size of the bubble indicates revenues
All figures are in USD Millions.
Data source: google finance & Annual Reports.

1.   Clicking the play button traces the movement of the companies since 2008.
For example, with the default settings you can see Toyota’s bubble running to the left indicating a sharp dip in profits.
2.   The smaller play button controls the speed of the playback. Scrolling it down makes the playback longer and easier to follow.
3.  You can select the Y-axis parameter by clicking the small arrow on the top of the axis label.  Similar selection can be done for the X-axis.
4.   The parameters for size and color of the bubble can be selected on the right side of the chart.

Play around and have fun.