Microsoft Mobile BI: Empowering Business Anytime, Anywhere

1. NY, London, Paris, Munich Everybody’s Talkin’ ‘bout Mobile BI Paul Turley, Mentor SolidQ

2. Please silence cell phones

3. a little about me BI Mentor SqlServerBiBlog.com 2009 1989 1996 2013 1979 1994 2011 2004 2002

4. a little about you Continent Distance Job Role What did you Come to Learn… Returning to implement

5. Session Description In 1995, Bill Gates said the goal at Microsoft was "... empowering people through great software any time, any place, and on any device.” Taking that to heart, 2013 will be known as the year of Microsoft Mobile BI. A lot of innovation has come out of the product teams over the past few months, including some exciting new mobile BI capabilities that can put on-the-go business leaders and information workers in the information driver seat (but no data exploring while driving, please!). Practically every reporting and dashboard product has a mobile capability, and some new tools have been designed specifically for tablet devices. Use Power View, SSRS reports, and Excel visuals on your iPad and Surface RT. Build and use compelling visual dashboards and analytic exploration on almost any device. Most importantly, learn to design the semantic model layer and security to make all the magic happen for your business

6. What Makes a BI Solution “Mobile”? Touch gesture & tablet user interface Tactile, responsive & interactive Optimized for screen size & navigation Mobile browser capable

7. Understanding Mobile BI Requirements …no. Delivering optimized functionality with fewer features requires a better understanding of the most important requirements! Fewer features in a more streamlined UI should mean that there are fewer requirements to manage, right?

8. Mobile BI on the Microsoft Platform Requirement Capability Excel PivotTables, charts & slicers Renders HTML with basic Excel featuresCompatible with most devices & browsers Good mobile experience SharePoint EnterpriseExcel Services Reporting Services Renders HTML Compatible with most devices & browsers Good mobile experience SQL Server 2012all editions Power View Requires Silverlight capable browser No current support for iPad & Surface RT SQL Server 2012Enterprise & BI editions SharePoint Enterprise Power BI(Power View & Excel Services) Office 365 subscription (after preview period) Native Surface app HTML5 support for other devices

9. Mobile BI in the Cloud Power BI Components Power Query Excel Pivot Tables & Visuals Power Pivot Power View Q&A Power Map adaptive: Silverlight, HTML & Surface app Excel add-in only requires Silverlight Excel add-in only Excel add-in only Windows Desktop       HTML5 / mobile browser   if Silverlight supported n/a Native Surface RT/Pro  n/a Native iPad n/a ?

10. Mobile BI in the Cloud Azure Services Power BI Azure Websites Azure VM Azure SQL Reporting Through Data Management Gateway(Manual refresh currently supported in preview) On-premise data source

11. Demo Power BI on mobile devices

12. On Premise Mobile BI Non-SharePointMicrosoft Data Platform Third-party ToolsMicrosoft Data Platform SharePointMicrosoft Stack Excel Services UI / UX Reporting Services Reporting Services Power View Multidimensionalmodels Tabular models Power Pivot models Tabular models Tabular models Multidimensionalmodels Relational SQL Multidimensionalmodels

13. Products to Consider(examples - not an endorsement) Strategy Companion Web-based self-service analysis and dashboard tool, mature product, many features. Deep SSAS product heritage. Pyramid Analytics Emerging full-featured dashboard and analysis suite with a very good user experience concept and feature set. Enterprise Software Solutions Mature SSAS browsing, dashboard and analysis suite with a very good integration with SSAS & SSRS. Essential enterprise SSAS server monitoring & management tools. Tableau Industry-standard visualization and analysis tool suite; elite-class Desktop, server and new Personal tool Forerunner Mobility enhancements for native mode SQL Server Reporting Services. Streamlined menus and folders, extended parameter enhancements, personalization. Deep history with product. DataZen New product based on ComponentArt data custom development components. Very rich, interactive mobile dashbpards with native apps on Window 8 tablets, Windows phone, iPad and iPhone. Author on the tablet.

14. Demos Third-party mobile & custom UI on the Microsoft BI platform

15. Mobile Dashboard Design Essentials • Use well-established visual metaphors • Simplify! One of the greatest lessons learned in the new era of portable device user interface design is that less is more. We simply can’t just keep adding more features. • Provide interactivity • Encapsulate logic in the semantic model • Aggregations • Calculations • Hierarchies • KPIs • Formatting • One size does not fit all

16. Your Next Move ? To the Cloud Data size Compliance Control Cost Modelling & Architecture SharePoint On Premise Mobile Product

17. Q&A Paul.Turley@SolidQ.com SqlServerBiBlog.com Q&A

18. Explore Everything PASS Has to Offer Free SQL Server and BI Web Events Regional Event Free 1-day Training Events This is Community Business Analytics Training Local User Groups Around the World Session Recordings PASS Newsletter Free Online Technical Training

19. Session Evaluations ways to access Your feedback is important and valuable. Submit by 5pm Friday Oct. 18 toWIN prizes Go to passsummit/evals Download the GuideBook App and search: PASS Summit 2013 Follow the QR code link displayed on session signage throughout the conference venue and in the program guide

20. Thank you for attending this session and the 2013 PASS Summit in Charlotte, NC