Business Intelligence

Deliver credible, consistent insights to all users through familiar Office based tools.

SQL Server in concert with Office and SharePoint, helps you deliver Business Intelligence across your organization through the familiar Office user experience and provides a rich set of platform capabilities to ensure credible, consistent data and support todays analysis, data warehousing, and Big Data needs. Find out What's New in SQL Server 2012 for Business Intelligence.

SQL Server 2012 Reporting Services is a comprehensive, highly scalable solution that empowers real-time decision making. SQL Server 2012 enables the creation of operational reports for pixel-perfect printing and browser-based viewing as well as ad-hoc data exploration and visualization. Read the Microsoft BI Interoperability with SAP White Paper.

Learn More

What's New in SQL Server 2012

  • Visualize and interact with data in bold new ways.
  • Quickly generate reports using intuitive interfaces.
  • Create self-service reports in a wide variety of formats.
  • Simplify sharing and collaboration.

"We want to provide information in a meaningful manner so that end users can ask their own questions. Power View in SQL Server 2012 is a very elegant way to visually display and interrogate data."

Paul Brenchley
Strategic Account Manager, Anglia Support Partnership

Get the latest answers to technical questions about SQL Server 2012 Reporting Services to help you with implementation, development, and other topics.

Learn More

SQL Server 2012 Analysis Services empowers you to build comprehensive, enterprise-scale analytic solutions for predictive analysis and interactive exploration of aggregated data.

Learn More

What's New in SQL Server 2012

  • Simplify the process of building complex solutions.
  • Integrate analytical capabilities with real-time operations.
  • Provide a single consolidated business view of your data.
  • Rapidly interact with an unprecedented amount of data.

"By using SQL Server 2012 Analysis Services to create cubes, every day our MOLAP model can load 350 million rows of new Hive data, analyze 35 billion rows of information, and achieve an average query response time of less than 10 seconds."

Dave Mariani
VP of Engineering, Klout

Get the latest answers to technical questions about SQL Server 2012 Analysis Services to help you with implementation, development, and other topics.

Learn More

SQL Server 2012 Predictive Analytics combined with the simplicity and familiarity of Excel provide a highly advanced data mining solution.

Learn More

What's New in SQL Server 2012

  • Ability to test multiple data-mining models at once, while confirming stability.
  • Build multiple, incompatible models in a single structure.
  • Apply model analysis over filtered data.
  • Blend optimized near-term and stable long-term predictions.

"Identifying trends and asking 'what if' types of questions are the sort of things people will want to do going forward. Power View in SQL Server 2012 is quite a good exploratory tool for such purposes because it’s fast and very intuitive to use."

Jeremy Lane
Data Warehouse Manager, Anglia Support Partnership

Get the latest answers to technical questions about SQL Server 2012 Predictive Analytics to help you with implementation, development, and other topics.

Learn More

A powerful solution that provides users of all levels with new insights through familiar Microsoft Office tools. Organizations can create compelling reports and analytical applications, easily share insights, and collaborate with colleagues.

Learn More

What's New in SQL Server 2012 SP1

  • Access data from virtually any source.
  • Easily collaborate and share insight using Power Pivot.
  • Discover new insights and visualize data with Power View.
  • Inspire innovation in end users with data mashup capabilities.
  • All of the above capabilities available out of the box in Excel 2013.

"Using the SQL Server Power View tool and the BI Semantic Model in SQL Server 2012, our employees will be able to easily create multidimensional reports, providing better insight into business and customer data."

Andrea Franchi
BI Technical Lead, ABB S.p.A.

Provide unmatched analytical performance to process billions of rows at the speed of thought with Power Pivot, a powerful data mashup and exploration tool based on xVelocity in-memory technologies.

Learn More

SQL Server 2012 Big Data Solution allows you to unlock actionable insights from all your structured and unstructured data. Analyze Hadoop data with familiar tools, and at the same time enrich your information by connecting to the world’s data and services.

Learn More

What's New in SQL Server 2012

  • Analyze Big Data and gain insights with familiar tools.
  • Leverage Power Pivot and Power View for Big Data.
  • Access the world’s data with Windows Azure Marketplace.
  • Scale on demand in the private and public cloud.

"SQL Server 2012 and Microsoft BI tools work well with big data. We can use SQL Server Analysis Services and Microsoft BI tools to perform ad-hoc queries of big data on Hadoop at sub-second response times."

Dave Mariani
VP of Engineering, Klout

Get the latest answers to technical questions about SQL Server 2012 Big Data to help you with implementation, development, and other topics.

Learn More

Gain insights from critical information in near-real-time by monitoring, analyzing, and acting on data in motion with Microsoft StreamInsight. With StreamInsight, enterprises can make informed business decisions nearly instantaneously.

Learn More

What's New in SQL Server 2012

  • Process large volumes of data across multiple data streams.
  • Gain continuous insight by engaging historical data mining.
  • Lower development costs by utilizing existing skill sets.
  • Reduce management complexity and optimize deployment.

"Our analysts can use SQL Server Power Pivot for Microsoft Excel to get several sources of data and combine it very quickly, which saves them up to two days per week."

Jonathan Bellisha
Chief Technology Officer, Union Bank of Israel

Monitor, analyze, and act on data in motion and make informed decisions nearly instantaneously by using Microsoft StreamInsight.

Learn More