In this second post looking at some of the new capabilities of SQL Server 2012 and how they can be leveraged in your Project Server farm, we are going to look at PowerView. PowerView was originally announced as Project Crescent and has wowed pretty much anyone that has seen it. In essence, PowerView allows you to build visualisations of your data using a simple drag and drop interface that are ‘Presentation Ready’ meaning there is no nasty wiring up of data, simply drag your data onto the surface and being analyzing it.

Project Server has a fantastic reporting story, with a dedicated reporting database containing pretty much every piece of data you put in, and a myriad of ways to retrieve, tabulate and visualize that data for the end user. With a little customization or configuration it is possible to build reports that will show the status of the project portfolio, risk and issues and just about anything you want to see. With such powerful reporting it can quickly become difficult for a Project or Portfolio manager to identify the projects or information they are interested in seeing.

Back in 2011 I sat in a session at TechEd Australia where Carolyn Chau showed off a number of the reporting enhancements coming in SQL Server 2012. SQL Server 2012 is a massive release, providing a stack of new features across all aspects of the server . Some of my favourites include things like Availability groups, support for Server core, a new Visual Studio based management to name but a few.

It’s always sound advice to try and keep your Project Server 2010 environment patched to the latest cumulative update, typically these include bug fixes or small enhancements to keep your environment running smoothly. Back in December, Microsoft released the December Project Server 2011 CU, which included a number of fixes and changes to timesheets amongst other things. As Project Server runs on top of your SharePoint environment, it’s also necessary to patch SharePoint at the same time.

Out of the box, Project Server 2010 is arguably the most business intelligence heavy application that Microsoft build on the SharePoint platform. It’s a bold statement, but when you think about it, a default installation of Project Server will implement a dedicated relational reporting database and provides the capability for numerous analysis services instances, each containing up to 14 OLAP cubes, all configurable from within the tool. With the reliance on SharePoint 2010 Enterprise, a number of new and improved capabilities are made available, including PerformancePoint Services & Visio Services which provide new and improved ways of visualising project data to quickly expose trends and possible issues so they can be corrected.