App compatibility today…

1. Assessing Application Compatibility with App Health Analyzer for Desktop Analyticsand Office Readiness Toolkit

2. App compatibility today… Upgrade Readiness Windows Analytics is helping customers adopt data driven app validation approach

3. App compatibility today.. Upgrade Readiness Windows Analytics is helping customers adopt data driven app validation approach Lack of compat insights on LOB/3rd party desktop apps is still low

4. Introducing App Health Analyzer…..

5. App health analyzer at work… Desktop analytics 60-70% apps with no insights Run the tool on your devices to assess your LOB/critical apps

6. App health analyzer at work… Desktop analytics Run the tool on your devices to assess your LOB/critical apps Leverage the insights to accelerate your migration rate

7. Secret sauce Key features Advanced analysis of installed applications Use pre-defined rules for compatibility assessments Generate risk segmentation (High/Medium/Low) Analytics Data Ready for Windows + MS Known Issues

8. Demo

9. App Details Flyout- Without AHA Insights

10. App Details Flyout- with AHA Insights

11. Connect with us.. • Sign up for private preview today • Participate and co-develop the product with us • Get early insights into upcoming milestones • Reach out to (ahacore@microsoft.com) for additional information • Tell us about your experiences with app compatibility

12. Thank You!

13. Assessing Office Application Compatibility with the Readiness Toolkit Tom Doyle Program Manager

14. Your time is precious… Office upgrade is one of many critical IT projects Compatibility issues and concerns delay and make it hard to plan upgrade

15. Customer feedback – 800 enterprises “Thanks for the report. Although I knew it would provide informative data, I had no idea how effective it would be in assisting me to expedite the development and maintenance process. It pointed out specific areas of the applications I had not explored yet and allowed me to not only modify those sections but prompted me to look at other unexplored regions. I was confident yesterday but this has turned into absolute certainty today. Thanks for your assistance.” “I expected 15% of all our 600,000 Office 2007 files (90,000) to have VBA issues to fix. However the tool identified just 1200 files that needed remediation. That is incredible!” “Office Telemetry Dashboard is complicated to roll-out and use. Can you provide a simpler solution? Can you also provide objective add-in readiness assessment?”

16. Readiness Toolkit http://aka.ms/ReadinessToolkit Assess compat across devices in your organization Toolkit creates an Excel report with • VBA summaryTotal files, files with macros • Add-in summaryTotal, adopted, supported.

17. Readiness Toolkit Simple to configure and install • On one device • On MRU documents • On a folder/network share • On multiple devices • Using a deployment tool like ConfigMgr • Create report from all files

18. VBA Readiness

19. VBA Readiness Summary Default report: most recently opened files Focus on the files that people are using Breakdown of files with/without VBA Reality: Less than 10% of files have VBA VBA issues to remediate Reality: Very low usage of deprecated or modified APIs 64-bit readiness Mostly usage of DLLs, many easy to remediate Unique files Macros are frequently copied. This shows how many unique macros/files you have

20. VBA Object Model changes It’s a lot less than you might think (out of the 30,000+ total methods & properties) Usage is very low.

21. VBA Readiness – Detailed Results Detailed information on each issue identified All issues classified in severity of work required to remediate

22. VBA Readiness – Remediation Guidance Additional remediation advice for 64-bit Provides remediation advice for 64-bit VBA declare statements

23. VBA classification Current Guidance

24. Add-in Readiness

25. Add-in Readiness Summary Classification of adopted and supported add-ins Report settings to choose 32/64-bit etc. Add-ins installed with Office not shown by default

26. Add-in Readiness Details Add-ins show device count (installs)Readiness status and more details about the add-in (link) Upcoming: Usage information

27. Add-in Classifications

28. Add-in Listings

29. Listings Office Add-ins are listed in the Ready for Windows directory Adoption and supported status of Office add-ins IT Pros can search for key add-ins to gain confidence in upgrading • http://www.readyforwindows.com

30. Findings from enterprises

31. Enterprises that have run the tool… On average, only 6% of files have macros Of these, only 3.3% have macro issues That’s only 0.2% of files with compatibility issues 90% of the top 2,000 3rd party add-ins are adopted or supported in Office 365 ProPlus

32. Upcoming Improvements based on your feedback (ReadyForOffice@Microsoft.com) Improved add-in coverage (let us know key add-ins in your organization) Features Departments – admins can use labels to filter data based on department Add-in usage – highlight the most used add-ins in your organisation Improved legacy file scanning – PivotTables, ODBC connections New readiness status for add-ins

33. Call to action

34. Call to action: Get the toolkit Download the Readiness Toolkit for Office https://aka.ms/ReadinessToolkit We’d love your feedback (on the toolkit and on the coverage)ReadyforOffice@microsoft.com Other Solutions Ready for Windows: Add-in Readiness Listings on www.readyforwindows.com

35. Sign-off Flyout- Pilot

36. App Confidence Lift Risk segmentation for commercial devices which piloted AHA # of Enterprises: 10 # Unique desktop apps analyzed: 900 App Confidence up by 63%