Microsoft SQL Server contains enterprise-ready Business Intelligence technologies that unlock new insights with managed self-service options, large-scale data warehousing and powerful analytics solutions.
Visualize KPIs with SQL Server Analysis Services
With the SQL Server Analysis Services platform, build rich and high performance analytical models (multidimensional, tabular and data mining) that can be used for interactive data analysis, reporting, visualization and predictive analysis using a number of BI tools.
Continued support for the powerful online analytical-processing (OLAP) technologies that make SQL Server Analysis Services indispensable to BI specialists
Tools for IT professionals and developers who are familiar with dealing with data in rows and columns
Easily transition from a personal and team BI Solutions to the fully IT governed corporate BI solutions
Car Sales Report using Power View
Reporting Services accelerates report creation and eases collaboration and management by providing access to data from virtually any data source to meet your business reporting needs.
Visualize and interact with data in bold new ways with Power View
Extend Reporting to the Cloud with Windows Azure™ SQL Reporting
Address complex reporting needs with familiar tools and broad scale
Accelerate report creation with intuitive interfaces and a wide variety of formats
Create ETL workflows through a graphical user interface
Integration Services is a platform for building enterprise-level data integration (and ETL) solutions. You use Integration Services to create packages that automate tasks such as copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. Unlock and integrate the data in your SQL Server, Oracle, Teradata, CRM, SharePoint, real-time, and cloud-based applications.
Access data from all database standards (Oracle, SQL, DB2, Teradata), XML, flat files, and business applications through BizTalk and onnectors for SAP, ERP, CRM, Web Service, and mainframe applications
Graphical tools for complex data movement without writing a single line of code
Data Quality Services integrated into workflow to cleanse raw data
Real-time complex event processing (CEP) data into business processes and ETL solutions with SQL Server StreamInsight
Allow business users to manage data hierarchies and values directly through the Master Data Services Excel Add-in
Master Data Services is the SQL Server solution for master data management, focusing on creation, maintenance and storage of master data structures that are used for providing object mapping, reference data, metadata management, and dimensions and hierarchies for data integration operations, such as business intelligence and data warehousing, and integration between operational systems. With the Master Data Services Add-in for SQL 2012, business users can directly manage existing database or data warehouse dimensions and hierarchies from within Excel without IT.
Give end users the power to manage the database or data warehouse dimensions & hierarchies from within Excel, releasing IT from managing the data content
IT provides oversight to track and reverse changes made by the business
Human workflow to notify assigned owners of specific data elements by email of business rule violations
Support for a broad range of hierarch and attribute management strategies and requirements
Create cleansing rules in Data Quality Services
Data Quality Services (DQS) is a new offering as part of SQL Server 2012 allowing customers to cleanse, match, standardize, and enrich their data to deliver trusted information for business intelligence, data warehouse, and transaction processing workloads. Data Quality Services abstracts the creation of a knowledge base for end users who understand the business to manage the governance, and compliance of their data. IT can then rapidly deploy this knowledge base or other third party rules they can easily acquire from Azure Marketplace and be up and running within minutes.
Cleanse data to ensure accuracy and validity based on your discovered knowledge
Easily acquire third party knowledge rules from the cloud with Azure Marketplace integration
Cleanse data in ETL workflows with Integration Services (SSIS) Data Cleansing process integration
Find and consolidate duplicated data based on fine-grained matching policies
Mining historical data can provide new insights and form a reliable basis for accurate forecasting. Use predictive analysis in Microsoft SQL Server 2012 to inform your decisions. Business users gain advanced data mining within the simplicity and familiarity of Microsoft Excel with SQL Server 2012 Data Mining Add-ins for Microsoft Office. Developers appreciate familiar tools and a comprehensive development environment for building sophisticated data-mining solutions.
Test many data-mining models at once, and confirm stability
Build multiple, incompatible models in a single structure
Apply model analysis over filtered data
Blend optimized near-term and stable long-term predictions
All-up SQL Data Warehousing Offerings
Microsoft SQL Server Data Warehousing gives customers an enterprise ready platform that includes high availability capabilities, a generational leap in performance with xVelocity in-memory technologies and integrated BI capabilities exposed through familiar Office tools like Excel and SharePoint. With Microsoft SQL Server, you can get a mission critical data warehouse platform at the fraction of the cost to acquire, operate and maintain.
Generational leap in performance with in-memory capabilities
Benefit from true enterprise scale-up to 100s of terabytes
Fastest Time to Solution by both offering reference architectures and appliances (pre-tested, pre-configured, and pre-tuned integration with open industry standard x86 Intel servers
Lowest cost of acquisition and ownership (includes maintenance, IT staffing, installation, operations) where real life scenarios show savings of $100,000s migrating to SQL Server
Learn how SharePoint 2010 increases insight within the organization.
Read how organizations like yours utilize and benefit from SQL Server to achieve their goals.
Explore the SQL Server TechNet community: access a wealth of resources including blogs and forums, connect and learn from experts.
Get the resources you need to learn about the latest SQL Server capabilities or enhance your skills.