Social sentiment on #NetNeutrality

I've been harvesting social conversation on #NetNeutrality, now its just a day to go before TRAI's deadline for comments by public ends. Here is a 3 hr snapshot looks like,

Cheers, StaticFix
PS. I’m using Power BI (viz)/MongoDB (data store) combination.

Convert EPOCH timestamp to MSSQL (TSQL) timestamp

Easy conversion by below multiple dateadd calls is the only option available

select dateadd(ms, cast ([Column Name] AS BIGINT)%(3600*24*1000), dateadd(day, cast ([Column Name] as bigint)/(3600*24*1000), '1970-01-01 00:00:00.0'))
from

Note: Assuming [Column Name] is imported in varchar format

Data storytelling with Power BI

With open data and Power BI (Excel 2013)

Online JSON editor

Found this one helpful, so sharing an online JSON Editor here http://braincast.nl/samples/jsoneditor/

Also has a quick XML to JSON converter