Amazon QuickSight – Business Intelligence by AWS

Re:Amazon QuickSight – Business Intelligence by AWS by jameshart on Wednesday October 07, 2015 @01:17PM (#10347359)

It's all just pivot tables, in the end. Excel solved most data slicing/drilldown problems years ago. Only issue has always been data size limits and access to live, up to data data (though Excel's also been able to hit external OLAP services for data for a long time too).

[ Parent | on HN ]

Re:Amazon QuickSight – Business Intelligence by AWS by 6stringmerc on Wednesday October 07, 2015 @02:47PM (#10348069)

I'd like to affirm your claim that Pivot Tables and Excel can match pretty much any BI related inquiry where data is available. Caveat - the data will fit in Excel

Source: Experience in Wall Street, Fortune 500 risk management, and dumping stuff from SalesForce to make it useable beyond what our implementation would report (or what leadership could get it to do).

[ Parent | on HN ]

Re:Amazon QuickSight – Business Intelligence by AWS by caractacus on Wednesday October 07, 2015 @04:58PM (#10349052)

And the data size limit is excel is stifling. 1m maximum rows? That can get filled very quickly.

[ Parent | on HN ]

Re:Amazon QuickSight – Business Intelligence by AWS by mistermann on Thursday October 08, 2015 @12:33AM (#10350907)

With Power Pivot it's quite a bit better, this guy did 122 million rows:

http://www.microsofttrends.com/2014/02/09/how-much-data-can-...

If that's not enough you can do SSAS Tabular + DirectQuery (although to be fair, that's no longer "pure Excel", but an end user likely doesn't care):

https://msdn.microsoft.com/en-us/library/hh230898.aspx

[ Parent | on HN ]