Business Analytics Capabilities

Insights for Everyone from Any Data, Any Size, Anywhere

Empower users of all levels with new insights through familiar tools while balancing the need for IT to monitor and manage user created content. Deliver access to all data types across structured and unstructured sources.

Empower end users with self-service analysis and interactive data visualization...

PowerPivot empowers users of all levels to access and mashup data from virtually any source. Users can create their own compelling reports and analytical applications, easily share insights, and collaborate with colleagues through Microsoft Excel and SharePoint. SQL Server 2012 introduces Power View, providing SharePoint users with highly interactive, browser-based data exploration, visualization, and presentation capabilities. With Office 2013 release, both PowerPivot and Power View capabilities are available to users right in the Excel 2013 box.

...while IT manages and protects data without hampering creativity

IT insight and oversight are provided with PowerPivot IT Dashboards in SharePoint to monitor end user activity, data source usage, and server performance. SQL Server 2012 introduced the ability to transform user created applications into corporate grade solutions by seamlessly importing them into SQL Server Analysis Services where they can be managed by the IT department. In addition, with Excel SharePoint 2013 release, customers can improve governance and compliance and easily track business critical Excel assets by discovering and assessing user-created spreadsheets with SharePoint 2013 and by comparing, tracking lineage, and conducting interactive diagnostics with Inquire in Excel.

> Case Study: Great Western Bank Gains Customers and Maximizes Profits with Microsoft BI Tools

Deliver rich dashboards and scorecards

Microsoft SharePoint Server 2010 provides a full set of rich dashboard and scorecard capabilities including advanced filtering, guided navigation, interactive analytics and visualizations. Further enhance your dashboards with Visio Services to display live data onto diagrams created in Visio.

> Case Study: NCR Executives Gain Critical Insights with Dashboard Solution Built in Four Months > Learn More about the dashboard and scorecard capabilities of SharePoint Server 2010

Provide built-in support for mobile access through SharePoint Server 2010

Browser-based mobile access to your corporate BI content is provided through Microsoft SharePoint Server 2010. Users can navigate existing reports, dashboards, scorecards, and analytical applications across iOS, Android, and Windows devices.

> Learn more about our Mobile BI Roadmap

Increase productivity and collaboration with SharePoint Server 2010

Delivering BI as a seamless part of SharePoint Server 2010, Microsoft couples BI with the rich collaboration, social, enterprise content management, search, and workflow capabilities available to users in SharePoint Server 2010. Through one integrated experience users can find information, share insights, and collaborate with peers for increased productivity and decision making.

> Case Study: Mexico’s Electrical Utility Sees Saving Millions of Dollars through Collaborative > Learn more about the integrated collaboration platform of SharePoint Server 2010

Improve decision-making with an extensive array of reporting capabilities

Microsoft SQL Server 2012 covers the full range of reporting from highly interactive and explorative self-service reporting for end users (Power View), to powerful operational report authoring and rendering environments for IT professionals and developers (SQL Server Reporting Services). Microsoft also provides additional deployment agility by extending reporting to the cloud with SQL Azure Reporting, allowing you to take advantage of the accessibility and elasticity of the cloud.

> Case Study: Yip In Tsoi & Jacks Ltd. Improves Decision-Making > Learn more about SQL Server 2012 Reporting Services

Enable a full spectrum of BI capabilities with SQL Server 2012’s BI Semantic Model

SQL Server has been helping organizations build comprehensive, enterprise-scale analytic solutions that deliver actionable insights for over a decade. SQL Server 2012 continues the tradition with a marquee new capability called the BI Semantic Model. The BI Semantic Model is a single model enabling a full spectrum of BI capabilities – reporting, analytics, scorecards, dashboards, and custom applications. Microsoft uniquely provides a modeling experience to support end user Self-Service solutions, rapid solution prototyping, and support for the largest enterprise grade solutions through a flexible modeling experience, rich sophisticated business logic, and best of class scalability and performance.

> Case Study: Leading Israeli Bank Transforms Culture and Data Insight > Learn more about SQL Server 2012 Analysis Services

Unleash insights from all your structured and unstructured data

Microsoft’s Big Data solution unleashes actionable insights for everyone from all their data through familiar tools. It also enables customers to uncover new insights by connecting to the world’s data through an open and flexible platform.

For customers with large or diverse datasets, Microsoft’s Big Data solution unleashes actionable business insights to drive smarter decisions from structured, semi-structured and unstructured data. Unlike the competition, it offers insights to everyone through integration with familiar Microsoft tools such as Excel, PowerPivot and Power View. In addition it enables customers to discover new insights by connecting to publicly available data and services from Azure Marketplace and social media sites such as Twitter and Facebook. Microsoft Big Data offers an Enterprise-ready Hadoop distribution through integration with key Microsoft components including Active Directory and System Center, and an open platform with full compatibility with Apache Hadoop APIs.

> Case Study: Klout uses Microsoft BI and Hadoop to Boost Insight into Big Data > Learn more about Microsoft's Big Data solution > Learn how to sign up for the Developer Preview for the Apache Hadoop based Services for Windows Azure

Built in analytics to solve complex problems and can help predict future outcomes

Microsoft SQL Server Analysis Services provides predictive analytics through powerful data mining capabilities to identify trends, problems, or relationships in the data; identifying the root cause of problems or predicting future outcomes.

> Case Study: Credit Suisse Uses BI for Next-Generation Global Risk Management > Learn how SQL Server Data Mining capability can extend Analysis Services into Predictive Analytics

Ensure credible, consistent data throughout the organization

Deliver credible, consistent data to the right users across the organization with a complete end-to-end Enterprise Information Management solution. Seamlessly integrate data from any data source with SQL Server Integration Services and maintain master data across the organization with SQL Server Master Data Services. SQL Server 2012 introduces Data Quality Services, a new tool to cleanse organizational data and improve data quality by using organizational knowledge and 3rd party reference data to profile, cleanse, and match data.

> Case Study: RealtyTrac Gives Customers High Quality Data For Trusted Decision Making > Learn more about SQL Server Integration Services > Learn more about SQL Server Master Data Services

Data Warehousing solutions from Microsoft deliver choice, flexibility, and scale

SQL Server 2012 Data Warehousing gives customers an enterprise ready platform that includes high availability capabilities, a generational leap in performance with in-memory technologies, and integrated BI capabilities exposed through familiar Office tools like Excel and SharePoint. With SQL Server 2012, you can get a mission critical data warehouse platform that scales beyond 600 TB at the fraction of the cost to acquire, operate and maintain.

> Case Study: Protective Life Insurance saves $600,000 over two years migrating from Teradata to Microsoft SQL Server Data Warehousing > Learn more about SQL Server Data Warehousing capabilities

Office 2013
Find out how Microsoft is changing the self-service BI landscape with Excel 2013 and SharePoint 2013.
> Learn More
Customer Stories
Learn why some of the world’s most successful companies are choosing Microsoft to improve efficiency and decision making.
> See the BI Case Studies
Industry Reviews
Forrester Research positions Microsoft as a leader in Self-Service BI Platforms.
> View The Report
> View More Reports
> Gartner recognizes Microsoft as a leader in business intelligence
> PowerPivot featured as one of eWeek's 2010 Products of the Year
> Go Back
Find A Partner
Microsoft Gold Business Intelligence Partners can help evaluate, plan, deploy, and manage the right BI solution for your organization. Find a partner today.
> Search Now