Seequal 2012 BI edition

SQL Server 2012 Business Intelligence edition, a new product edition, providing premium corporate and self-service BI .The Business Intelligence Edition will include premium BI features as well as all of the Standard Edition features. BI edition has all the features in Standard edition and Enterprise edition has all the features of BI edition.

Licencing :Business Intelligence Edition will be available in the Server + CAL(Client Access License ) model, based on users or devices

Major Capabilities –

PowerPivot: Empower users to access and mash-up data from virtually any source and easily collaborate and share insight using familiar tools with PowerPivot.
Power View: Discover new insights with Power View, an interactive browser-based data visualization and presentation experience for users of all levels.
BI Semantic Model : Provide  consistent view across heterogeneous data sources and easily transform end user created apps into corporate BI solutions.
Master Data Services :Maintain master data across the organization structures used for object mapping, reference data and metadata management.
Data Quality Services :Help improve data quality by using organizational knowledge and 3rd party reference data providers to reliably profile, cleanse, and match data.
xVelocity :xVelocity in-memory analytics engine provides a generational leap in performance while allowing an interaction with an unprecedented amount of data.

What we can do on 2012 ?

Rapid data exploration & visualization :

Discover new insights at the speed of thought with Power View, a highly interactive, familiar browser-based data exploration, visualization, and presentation experiences for users of all levels, Additionally, PowerPivot helps empower users to access and mash-up data from virtually any source, including Big Data sources using familiar tools

Managed self-service BI

Balance the need to monitor, manage, and govern the data and analytics end users create with IT dashboards controls across SQL Server and Microsoft SharePoint that help IT monitor end user activity, data source usage, and gather performance metrics from servers. New to SQL Server 2012, IT can also transform end user-created BI applications in PowerPivot into corporate-grade solutions managed by IT.

Corporate and scalable reporting and analytic

Build and deploy advanced scalable, secure and manageable BI corporate solutions with advanced analytics and reporting, tabular BI Semantic Model and xVelocity in-memory analytics engine. Business users gain advanced predictive analytics with the simplicity and familiarity of Microsoft Excel with SQL Server 2012 Data Mining Add-ins for Microsoft Office.

Credible, consistent data

With SQL Server 2012, IT can better control and manage data through a new BI Semantic Model and enhancements to SQL Server Integration Services. Meanwhile, new Data Quality Services uses organizational knowledge and 3rd party reference data providers to reliably cleanse data and a new Master Data Services Add-in for Excel makes it easy for end users to manage and maintain central data.

Greater Uptime, Manageability, and Security

Reduce OS patching by as much as 50-60% with new support for Windows Server Core. Meanwhile, SQL Server Management Studio introduces Database Recovery Advisor to help simplify the ways DBAs restore databases, PowerShell 2.0 support, and enhancements to Sys Prep to help IT more efficiently create VMs. Security enhancements help IT more easily manage permissions around data access with User-Defined Server Roles to support separation of duties. Increase manageability and decrease complexity of database schema through new Default Schema for Groups that allows a default database schema for Windows group user accounts.

Finally , What microsoft claims ?

“SQL Server 2012 delivers an ROI of up to 189% with a 1 year payback period..”


Reference  :


Comment please...

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s