Microsoft BI – Context and Vision Maurice Martin Director, Server

Microsoft BI – Context and Vision Maurice Martin Director, Server and Tools Business Microsoft UK [email protected]

Microsoft Business Intelligence Vision Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions Comprehensive and integrated BI and performance management offering Agile products that adapt to how you use information Built on a trusted IT backbone 2

Microsoft BI Vision BI for Everyone 3 BI for a Few

Customer Insights & Tech Trends BUSINESS REQUIREMENTS CONSTANTLY GROWING Globalizati on Compliance & Risk Management Right Information At the Right Time IT Agility and Cost Efficiency GAME CHANGERS DRIVING TECHNOLOGY INNOVATION Digitally Born Data Virtualization Hardware Innovation Cloud Services

The Changing Business Environment No one wants to wait. Everyone wants to share. You want oversight and visibility. 5

3 Core Capabilities of a BI Solution

Microsoft Business Intelligence Use What You Already Know Business Productivity Suite Business Collaboration Platform Information Platform 7

Microsoft BI - Benefits Empower Your People to Innovate Increase individual productivity through familiar and intuitive tools Enable your end users to create their own BI solutions Improve end user sharing and discovery of insights Improve Organizational Effectiveness to Grow Increase team and organizational productivity through dashboards Improve visibility into key team and organizational objectives and metrics Increase business user efficiency with an integrated collaborative platform Enable IT Efficiency to Reduce Costs Cut cost and complexity by leveraging existing IT investments Scale-out to support Business Intelligence for all users at a lower TCO Increase productivity with familiar and intuitive development & management tools 8

Empowering the End User Introducing PowerPivot for Excel Enable users to perform selfservice analysis and intuitively build their own BI solutions Allow users to interactively explore and perform calculations on large data sets Integrate data from multiple sources Minimize dependence on IT support

Self-service Analytics Introducing PowerPivot PowerPivot for Excel 10 PowerPivot for SharePoint

Powerful Personal Analysis Tools Drive personal productivity and insight Easier navigation with Slicers Improved formatting and charts Microsoft Confidential, Prototype Only

Self-service Reporting Empower end users to author reports Report Builder 3.0 Familiar Microsoft Office 12 interface Intuitive report wizards and reusable report components Powerful query designer Flexible layout options with rich visualizations Can support all data sources, including SharePoint list or PowerPivot

Share Insights Get a common view of organizational performance Refresh workbook data manually or automatically Get access to unlimited data secure in SharePoint with PowerPivot Publish and share rich workbooks to SharePoint Get the same rich fidelity with a Web browser, including Ribbon and Excel functions Microsoft Confidential, Prototype Only

Microsoft BI - Benefits Empower Your People to Innovate Increase individual productivity through familiar and intuitive tools Enable your end users to create their own BI solutions Improve end user sharing and discovery of insights Improve Organizational Effectiveness to Grow Increase team and organizational productivity through dashboards Improve visibility into key team and organizational objectives and metrics Increase business user efficiency with an integrated collaborative platform Enable IT Efficiency to Reduce Costs Cut cost and complexity by leveraging existing IT investments Scale-out to support Business Intelligence for all users at a lower TCO Increase productivity with familiar and intuitive development & management tools 14

Industry leading capabilities PowerPivot has “obliterated the volume limits of Excel, operated in memory, and clearly placed analytic application authoring functionality into the hands of Excel users”. - AMR Excel is the BI technology used most extensively by businesses. - InformationWeek Analytics/Intelligent Enterprise 2009 Business Intelligence Survey Microsoft is the fastest growing Business Intelligence vendor. - IDC

Microsoft is a Leader in Gartner MQs Enterprise Information Web Horizontal Social BI Content Conferencing Platforms Unified Access Software Portals Management Technology Communications “Magic Quadrant Portals”, 17 September 2009 David Gootzit, Gene Phifer, Ray Valdes, Eric Knipp “Magic Quadrant for for Horizontal Unified Communications”, September 2009, Bern Elliot, Steve Blood Web 29 July12009, David Mario Smith Business Intelligence Platforms”, 29 January 2010 Rita L. Sallam, BillCarol Hostmann, James Richardson, Andreas Bitterer “Magic Access Technology”,2 September 2009, Whit Andrews Enterprise Content Management”, 15 October 2009, Toby Bell, Karen M. Shegda, Mark R. Gilbert, Kenneth Mick MacComascaigh “Magic Quadrant Quadrant for for Information SocialConferencing”, Software in the Workplace”, 22 October 2009, Nikos Drakos, Rozwell, Anthony Bradley, JeffreyChin, Mann The Magic Quadrant is copyrighted September 2, 2009 by Gartner, Inc. and is reused with permission. The Magic Quadrant is a graphical representation of a marketplace at and for a specific time period. It depicts Gartner's analysis of how certain vendors measure against criteria for that marketplace, as defined by Gartner. Gartner does not endorse any vendor, product or service depicted in the Magic Quadrant, and does not advise technology users to select only those vendors placed in the "Leaders" quadrant. The Magic Quadrant is intended solely as a research tool, and is not meant to be a specific guide to action. Gartner disclaims all warranties, express or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose. 16 The Magic Quadrant graphic was published by Gartner, Inc., as part of a larger research note and should be evaluated in the context of the entire report. The Gartner report is available upon request from Microsoft.

2010 Microsoft Corporation. All rights reserved. Microsoft, Microsoft Dynamics, the Microsoft Dynamics logo, and [list other trademarks] are trademarks of the Microsoft group of companies. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.