Advanced Business Intelligence Solutions Using Microsoft Excel + Excel Services

2. DBI335 Advanced Business Intelligence Solutions Using Microsoft Excel + Excel Services Kevin Fan Program Manager, Excel Manpratap Suri Program Manager, Excel Services Microsoft Corporation

3. ?

4. Export to Excel

5. Setting the Scene… • BI Investments in Excel 2007 • The goal: Make Excel & Excel Services the tool of choice for users doing Business Intelligence

6. The Response • Terrific feedback from analysts, partners, customers • Yet customers wanted more • More features for the BI power users • More ability to share and manage BI done in spreadsheets • Excel 2010 picks up BI where Excel 2007 left off…

7. Excel 2010 Vision User Experience and Collaboration Data Analysis and Visualization Hosted Spreadsheets and Programmability Analyze with Slicer… Work together... Excel Services Spot trends with Sparklines ...across thePC, phone, and browser... Extensible Platform REST API Web Services API JavaScript OM PowerPivot Self-Service Business Intelligence ...to bring ideas to life. High Performance Computing 64-Bit Excel

8. 3 things to remember • Excel everywhere • Powerful BI capabilities • Integrated BI platform

9. Excel and Excel Services BI Features Kevin Fan Program Manager Excel demo

10. Kevin Manpratap Program Manager Program Manager Excel Excel Services Sales Manager Sales Manager ContosoContoso

11. What You Just Saw • Excel Services • Named Sets • Slicers • Writeback & What-If Analysis • Sparklines • Search in Filters

12. Hosted Excel Services and Collaboration Manpratap Suri Program Manager Excel Services demo

13. What You Just Saw • Next generation Excel dashboards • Customization for increased interactivity and insights • Projecting BI beyond the spreadsheet and the web page

14. 3 things to remember • Excel Everywhere • Powerful BI capabilities • Integrated BI platform

15. Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub. Track Resources • The Excel and Excel Services Blog • Office 365 Beta Sign Up • Office 365 Beta Blog

16. Excel 2010 Focus Areas & Features User Experience And Collaboration Data Analysis and Visualization Hosted Spreadsheet and Programmability • Under the Hood/Cutting Edge Hardware • 64-bit support • Multi-threading support in File I/O • Multi-threading support in PivotTable sorting • Multi-threading support in row height calculations • Enhanced responsiveness • OfficeArt performance enhancements • Chart performance enhancements • Graphics improvements • High Performance Computing integration • Visualizations • Sparklines • Conditional Formatting icon enhancements • Databar visualization enhancements • Negative databars • Proportional databars • Cross-sheet Conditional Formatting • .DisplayFormatting Object Model Property • Chart dialog enhancements • PivotChart interactive filters • Chart object model in PowerPoint • Chart object model in Word • Increased chart limits • Functions • Improved statistical function accuracy • Improved statistical function consistency • Solver improvements • Business Intelligence • Slicers • Writeback • Named Sets creation from the UI • Named Sets MDX creation • Named Sets support for Dynamic Named Sets • Support for non-visual totals on Named Sets • Enhanced PivotTable Show As • Right-click Show As • Multiple copies of measures on PivotTables • Calculated member filter improvements • Table AutoFilters in sheet headers • Table Tokenizing [#This Row] • Table Search in AutoFilter • Excel on the Web • Greater support for different browsers • Basic editing • AutoSave • REST Publish from Excel • Continue in Excel • Formatting • Formula auto-complete • Tables • Undo • Cut/copy/paste • Images • Multi-user editing • Near real time • Conflict model • Excel Services in SharePoint14 • Web part properties • More part-to-part • Powershell • Trusted locations • Claims authentication • External data error msg improvements • External data periodic refresh • Excel Services Java Script OM • Syndicating Excel Services Content • Programmability • Asynchronous User Defined Functions • VBA XLM-parity features • Macro recording for Shapes • User Defined Functions on a HPC Cluster • Custom Data Parts • Excel Services REST API • Excel Services JSOM • Miscellaneous • Compatibility Checker Improvements • Smooth Scrolling for Win7 Touch • New Keyboard Shortcuts • … and PowerPivot for Excel and PowerPivot for SharePoint!

17. What’s Next? • Follow, Tweet and Enter to win an Xbox Kinect Bundle • GAME ON! Join us at the top of every hour at the BI booth to compete in the Crescent Puzzle Challenge and Win Prizes • Sign up to be notified when the next CTP is available at: microsoft.com/sqlserver Join the Conversation @MicrosoftBI /MicrosoftBI

18. Resources • Connect. Share. Discuss. http://northamerica.msteched.com Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers http://microsoft.com/technet http://microsoft.com/msdn

19. Complete an evaluation on CommNet and enter to win!

21. © 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. 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.