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:

RankCompanyRevenue (USD Billion)EmployeesMarket cap
1Samsung Electronics$188.10221,726$200
2Apple$156.5076,100$427.62
3HP$120.30331,800$32.46
4Foxconn$1191,230,000$27.20
5IBM$104.50433,362$229.45
6Panasonic$99.65327,512$22.70
7Microsoft$73.7294,000$231.03
8Dell$62.07106,700$22.97
9Amazon.com$61.0988,400$120.03
10Fujitsu$54.46173,155$125.83
11Intel$53.34104,700$105.26
12Google$50.1753,546$248.31

 

What do you think? Leave a comment below.