Tracking project and/or portfolio progress, and forecasting future performance are the cornerstones of all project management methodologies. While the reporting requirement itself is common and generic in nature, every organisation has specific PM practices which demand unique reporting that will result in the requirement for custom-developed Project Server reports. To meet this need, Project Online provides reporting tools with rich capabilities to both create and distribute traditional or analytical reports, and to empower users to generate their own ad-hoc reports based on unplanned requirements.
Project Online reporting is based on a service called oData, this service exposes Project Server reporting data via a web service interface. The query is passed via a URL and results are returned as an XML document which can be consumed by reporting tools. Following are the options of the reporting tools that can work with oData
Excel Services has native support for oData consumption, Project Online comes with pre-installed oData-based data connections which are utilised by Excel-based reports. Using the oData of Excel 2013, tabular, graphical and pivot table-based reports can be created and published on SharePoint using Excel Services.
Excel Services with Power View
Power View is an interactive, data visualisation and exploration add-in for Excel 2013. This tool enables power users to create information-rich and interactive dashboards based on data models created in Power Pivot (Power Pivot can in turn be a consumer of oData feeds.)
Power View combines the interactivity of analytical reports like slicing, dicing, drilling up/down with rich user interface elements like Dashboards, Maps, Charts, Graphs, Tables and Images. It empowers day-to-day users to create attractive and useful dashboards.
Example of Reports
SQL Server Reporting Services (SSRS)
SSRS is a tool of choice of for developing traditional and user interface-rich reports. SSRS does not natively support oData feeds, however it is possible to consume oData feeds using XML data sources, but that requires setting up a SQL Integration Server (SSIS) to call the feed. It is recommended to have this server hosted on Azure.
Examples of Reports