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

 

Reports hosted on SQL Azure reporting (preview) accessed via Windows Phone, iPhone and Android phones!

Standard

Here are screenshots of reports hosted on SQL Azure reporting preview accessed via Windows Phone, iPhone and Android Smartphone. I knew one can access reports using browser and so just wanted to test them on Windows Phone, iPhone and Android.

Note: Report is just for demo purpose. So I have kept it very simple.

Here are the screenshots:

1. Windows Phone:windows phone sql azure reporting

2. iPhone:iPhone SQL Azure reporting

3. Android Smartphone:
sql azure reporting android phone

Note: I have not tested it but I have heard reports on SQL Azure reporting are accessible via iPad too. 

Simran Jindal confirmed that It works great on iPad too!

Conclusion: These opens up a whole new world of possibilities for businesses. Business users would be able to get access to reports from anywhere in the world. Think of reports that are built on top of Data Marts hosted on cloud. They are kept in sync with Data that resides on-premise (locally). We have exciting times ahead!

Resource:
Getting Started Guide for Report Readers (SQL Azure Reporting)
Guidelines and Limitations for SQL Azure Reporting Preview