Capabilities

Rapid data exploration and visualization

Discover new insights at the speed of thought with Power View, an interactive, browser-based data exploration, visualization, and presentation experience. Power Pivot helps users access and mash-up data from virtually any source, including Big Data using familiar tools.

High performance analytics

Our in-memory analytics engine provides a generational leap in performance while allowing an interaction with an unprecedented amount of data. In-memory capabilities are built right into the SQL Server analytics engines for flexibility and ease of use.

Credible, consistent data

IT can better control and manage data through a BI Semantic Model, which provides consistent view across heterogeneous data sources, and enhancements to SQL Server Integration Services.

Robust data quality

Improve data quality by using organizational knowledge and 3rd party reference data providers to profile, cleanse, and match data.

Master data management

Maintain master data across the organization structures used for object mapping, reference data, and metadata management.

Basic availability, security and data management

Business Intelligence edition also includes the core database capabilities of SQL Server Standard for departmental applications including Windows Server core support and user-defined roles for setting up separation of duties.

Greater uptime, manageability and security

Reduce OS patching by as much as 50-60% with support for Windows Server Core. Create VMs efficiently with PowerShell 2.0 support, and enhancements to Sys Prep. Easily manage permissions for data access with user-defined server roles to support separation of duties.