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)
Configuration of Scatter Plot:
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 | $50.17 | 53,546 | $248.31 |