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.
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.
Hi Chinmay,
ReplyDeleteThis moving chart is interesting.
Could you please include Schneider Electric too on your chart?
thanks,
Omkar.
Thank you so much for this review! I found it very helpful, this seem like a program that would be of great use to me. Keep it up!
ReplyDeleteAAV Advisories - company law, company formation law, accounting management, agricultural management, project consultancy consultant
Hi Chinmay,
ReplyDeleteThis is awesome! A few observations:
1. MS seems to be trying hard but not able to move the sales needle much.
2. HP is just stationery across all parameters. Its a steep downhill slope for them it seems.
3. It's interesting to observe how Samsung moves in this graph. The dividends of high R&D spend seem to have come in last 2 years or so.
4. Can't help but notice how Volkswagen seems to be growing like a startup! And how Toyota seems to be struggling at the same time.
A few requests:
1. Can you increase the time window so that it starts from say 2003.
2. Would love to see Google in this plot.
3. Can you please share how did you make this chart?
Overall, great and interesting work. Please keep it up!
-Nikunj
Schneider included.
ReplyDeleteAlso included Google and Xerox.
ReplyDeletehello Chinmay
ReplyDeletevry nice and interesting. Would like to see one exclusive for Telecom OEM companies.
thanks
Raman V