Microsoft Vision: Project Portfolio Management

This is a brief summary from the Project 2014 Conference in Anaheim, CA Feb 2014. This is really about consolidating Microsoft assets: Project online, Office 365, SQL Servers, Azure, Project Apps and so on and how they are going to play out in the future.

Details of Project Online here:
http://office.microsoft.com/en-us/project/

                
There is a 1 hour long marathon video on the following site detailing the road map for project portfolio management:
http://channel9.msdn.com/Events/Project/2014/KEY002
Here are some screen shots:

 

 

 

 

 

No project without reporting!

 

Also watch this SSRS Report Enabler for Project Online by Project Hosts here:
https://www.youtube.com/watch?v=10tDxtla3NI
 

Easy to follow no-nonsense books on Reporting Services:

 

 

http://www.packtpub.com/learning-sql-server-2008-reporting-services/book

 

 

http://www.packtpub.com/learning-sql-server-reporting-services-2012/book

Power View, Data Alert and other features with SQL Server 2014 CTP2

Report Integration for SQL Server 2012 and SharePoint 2010 was described comprehensively in my latest book:

The new features Power View and Data Alerts were treated in two complete chapters:

Chapter 6: Power View and Reporting Services
Six hands-on exercises

Chapter 7: Self service Data Alerts in SSRS 2012
Three hands-on exercises

The SharePoint 2010 used in the book should work equally well with SQL Server 2014 CTP2.

SQL Server 2014 CTP1 installation was described here.
http://hodentekmsss.blogspot.com/2013/09/installing-sql-server-2014-ctp1-on.html

Programs have been updated and new versions have appeared.
SQL Server 2014 is now in CTP2

Now how does one start working with features like Power View and Data Alerts?

You need to install and work with recent versions.

You need the following :
Microsoft® SQL Server® 2014 Reporting Services Add-in for Microsoft SharePoint®, Community Technology Preview 2 (CTP2)

You can download the above from here:
http://www.microsoft.com/en-us/download/details.aspx?id=40738

Details from the above site are here:

·         The SQL Server 2014 CTP2 Reporting Services Add-in for Microsoft SharePoint technologies deploys the Reporting Services user interface pages and features on a SharePoint web front-end server.

• The SQL Server 2014 CTP2 version of the Reporting Services add-in supports SharePoint 2010 and SharePoint 2013.
• To use connected mode features of Reporting Services with the 2014 CTP2 add-in, the report server version must also be 2014 CTP2 version.
• For more information on supported versions, see “Supported Combinations of SharePoint and Reporting Services Components”.
• For more information on Local mode and connected mode, see “Use Access Services with SQL Reporting Services”.

After you install the Reporting Services Add-in and configure your servers for integration, you can publish Reporting Services content to a SharePoint library and then view and manage those documents directly from a SharePoint site.

More details here:

 http://hodentekmsss.blogspot.com/2013/11/download-this-sql-server-2014-reporting.html