A great short post about some of the aspects that make up Business Intelligence
Business Intelligence: What’s the difference between Statistics, Metrics and Analytics?
If you would like to know more about the Azure platform, and the various services and capabilities it provides, have a look here:
http://azureplatform.azurewebsites.net/
And here’s a link to some more in-depth information about Azure
https://azure.microsoft.com/en-us/overview/what-is-azure/
A quick video to show you how to add PPM dashboards from the SharePoint App store to your Project Online instance. Please note that the sequences have been shortened.
A 2 minute 40 second overview of the out of the box PPM dashboards now available for Project Online from the SharePoint Apps store.
Also available: iPad versions from the Apple App store.
Recent improvements to Project Online include easier access to sample reports and data connections. The Business Intelligence (BI) Center site will no longer be created automatically for new Project Online sites, and new lists/libraries are used for reporting content.
Read this article to learn more about these changes, including what to do if you want to continue using your old BI Center site.
This link describes how you can use SQL Server Integration Services (SSIS) to replicate your reporting data from Project Online to a separate SQL Server database, using the Open Data protocol (OData).
It explains how to install the add-on, the high level details of the replication process and how to get started in Visual Studio with the Integration Services project template to create a project that automatically pulls your data based on a schedule.
While Project Online: SSIS package for OData delta sync provides an example SSIS package that demonstrates how to perform a delta sync to reduce download times. The package retrieves Project Web App (PWA) data only for projects that changed since the last sync. This sample applies to Project Online reporting when report data is replicated to a local SQL Server database.
On April 9th 2014 a number of updates were applied to my laptop and after that I was unable to access the ODATA feeds. Excel returned the following error: Invalid pointer array
To resolve the issue I had to apply the following hotfix: http://support.microsoft.com/kb/2837666
You experience one of the following problems if you have recently applied the October 2013 Cumulative Update for Excel (KB 2825655) or a later version, but you have not updated your version of the PowerPivot add-in:
