I have this problem and was wondering if anyone can help. I have a number of data feeds (CSV files, web APIs) that I would like to report on but can't find anything open source or paid that can do the job. Basically I want to be able to attach any data feed to this system and build a simple report (select fields, couple of aggregations) which are then distributed to my team. The system could either be a desktop app or web based, don't mind. Each member of my team would have different levels of access to this and the report would present the data in tabular formats, charts and pivots. I looked at Tableau and Qlikview but they are not ideal for real time reporting.
Any ideas if there is anything like that out there?