Data visualization: List of largest IT companies in the world

Standard

I was going through the list of largest IT companies in the world. And I thought, it would be great to see it visually! so here it goes:

[created using Power View in Excel 2013)

power view scatter chart excel 2013Configuration of Scatter Plot:

fields list power view scatter chart excel 2013

Some of observations:

– Foxconn has low revenue/employee ratio (I guess, it’s because they must be employing a lot of workers for their electronic manufacturing plant at low cost)

– Samsung is ranked number 1 and Apple is ranked 2. But apple has better revenue/employee ratio. Also Apple’s market cap (represented by Size of bubble) is greater then that of Samsung

– there’s a cluster that comprises of MS. Google, Amazon.. etc Also one more cluster of HP, Panasonic and IBM

And here’s the Data that I’ve used:

Rank Company Revenue (USD Billion) Employees Market cap
1 Samsung Electronics $188.10 221,726 $200
2 Apple $156.50 76,100 $427.62
3 HP $120.30 331,800 $32.46
4 Foxconn $119 1,230,000 $27.20
5 IBM $104.50 433,362 $229.45
6 Panasonic $99.65 327,512 $22.70
7 Microsoft $73.72 94,000 $231.03
8 Dell $62.07 106,700 $22.97
9 Amazon.com $61.09 88,400 $120.03
10 Fujitsu $54.46 173,155 $125.83
11 Intel $53.34 104,700 $105.26
12 Google $50.17 53,546 $248.31