The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI

We’re back with a new episode of The Fantastic 12 of 2012: Behind the Scenes Blog Series, where we’re providing unique insights from the SQL Server Engineering Team as they developed SQL Server 2012. This week we are jumping ahead to Number 6 of The Fantastic 12 of SQL Server 2012 (PDF) and we’ll revisit Number 5 in the weeks ahead. Be sure to catch the first four episodes here.

In this new episode John Hancock, Principal Program Manager, provides some interesting insights behind a major design decision around the new modeling capabilities including Key Performance Indicators, Hierarchies, and Perspectives and determining where those new capabilities ought to go into SQL Server 2012. Should those capabilities go into the professional environment or is there another approach? Find out how the team addressed and solved this challenge in the episode below!

PowerPivot for SharePoint: Balance the need to monitor, manage, and govern the data and analytics end users create with IT dashboards and controls that help IT monitor end user activity, data source usage, and gather performance metrics from servers.

Enable IT Efficiency

End user created, IT managed: SQL Server 2012 bridges the gap between end user created BI applications and IT managed corporate solutions by providing the ability to import PowerPivot models into Analysis Services so that they can be professionally managed and transformed into corporate grade solutions.

Ease of administration through SharePoint: Enable end user alerting from reports published to SharePoint and benefit from the ease of consolidated management through the SharePoint 2010 Central Administration.

SQL Azure Reporting: Extend rich user insights to even more people with SQL Azure Reporting that removes the need for deploying and maintaining a reporting infrastructure.