Quick post to let you know that the SSIS component to export data via ODATA that was mentioned here is now available for download, see the link below:
http://www.microsoft.com/en-us/download/details.aspx?id=42280
This will enable you to copy data from Project Online into a custom SQL database, from there you can easily create SSRS reports, custom OLAP cubes, integrate into other LOB systems etc. Look out for more details soon.
