We’ve crossed the halfway point in The Fantastic 12 of 2012: Behind the Scenes Blog Series and would be delighted to get your feedback on the series as well as The Fantastic 12 of #SQL2012 Twitter Contest. Please share your feedback in the comments section below or send us messages on either Facebook or Twitter. Your feedback will help us plan future blog series, so please let us know what you think if the series and what else you’d like to see from us!

In this week’s episode, Ashvini Sharma, Lead Program Manager, talks about Analysis Services in SQL Server 2012 and the broad scope of a new feature their team developed. Ashvini covers how the team worked really hard to determine what this new feature should support given the timelines they had to work against. So what is this new feature is he’s talking about? Watch the video below to find out as well as hear how the team blew off steam battling each other including trying to use helicopters!

Download The Fantastic 12 of SQL Server 2012 (PDF) and catch up on all the previous video episodes here. Don’t forget the Twitter Contest that accompanies this series happens every Thursday at 10:30am PT, where you could win one of the new SQL Server T-Shirts of your choice!


Fantastic 12 of SQL Server 2012

7 Credible, Consistent Data

Deliver credible, consistent data to the right users across the organization with a complete end-to-end solution

One Single Semantic Model

  • BI Semantic Model: A single, scalable model for Business Intelligence applications, from reporting and analysis to dashboards and scorecards, that helps provide a consistent view across heterogeneous data sources. IT and developers can create a single model to be consumed by front-end tools for their BI Applications across both tabular and multidimensional models.

Seamlessly Integrate Data

  • Integration Services: Help reduce time-to-solution for innovative, team-based data integration across data sources, including the cloud, by utilizing the industry-leading tools in Integration Services (SSIS) that help deliver credible, consistent data reliably and efficiently. New improvements include significant improvements in the user experience for dramatic efficiencies.

Cleanse Organizational Data

  • Data Quality Services: Help improve data quality by using organizational knowledge and 3rd party reference data providers, including cloud-based providers, by enabling data managers to reliably profile, cleanse, and match data — run as a standalone tool or leverage within SSIS.

Efficiently Manage Data

  • Master Data Services: Help create, maintain, store, and access master data structures used for object mapping, reference data, metadata management with Master Data Services (MDS), while a new MDS Add-in for Excel makes it easy for end users to manage and maintain central data.