Access your Pro+ Content below.
Microsoft tailors BI capabilities for users, IT in SQL Server 2012
This article is part of the SQL Server Insider issue of March 2012, Vol. 9
More on SQL Server BI best practices Count ’em: Three ways to scale SQL Server business intelligence Pry open the SQL Server business intelligence toolbox Some top reasons to get started with SQL Server 2012 If much of SQL Server 2008 R2’s focus was on making business intelligence (BI) more accessible to users as a self-service, then SQL Server 2012 is about building on that vision while making the concept of self-service BI easier for IT to manage, industry watchers say. Indeed, part of the charter of SQL Server 2008 R2 was the democratization of BI—that is, simplifying moderate to advanced BI capabilities like the ability to mash up data and create relationships and dimensions so the process was comfortable and familiar to any Excel user, according to Herain Oberoi, director of product management at Microsoft. “If you look at [SQL Server] R2 and the theme around managed, self-service BI … this is a continuation of that strategy,” Oberoi said. “It’s all about what we can do to help end users and what can we do to help IT.” In ...
Access this PRO+ Content for Free!
Features in this issue
Industry watchers weigh in on Microsoft SQL Server 2012, which offers added business intelligence capabilities for end users and IT. Features include Power View and master data management.
The Microsoft BI stack gains a few additions with release of SQL Server 2012, with new Excel-based Power View for business users and old standbys like Reporting Services.
News in this issue
Microsoft technical fellow David DeWitt is secretly developing a data management system that can do the jobs of both SQL and NoSQL databases. Can he bring the two sides together?