NY, London, Paris, Munich Everybody’s Talkin’ ‘bout Mobile BI
October 15-18, 2013 Charlotte, NC
Paul Turley, Mentor SolidQ
Please silence cell phones
October 15-18, 2013 | Charlotte, NC
a little about me BI Mentor SqlServerBiBlog.com
1979
1989
1994
1996
2002
2004
2009
2011
2013
a little about you
Continent Distance Job Role What did you Come to Learn… Returning to implement
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
5
What Makes a BI Solution “Mobile”?
Tactile, responsive & interactive Optimized for screen size & navigation
Mobile browser capable
6
Touch gesture & tablet user interface
Understanding Mobile BI Requirements Fewer features in a more streamlined UI should mean that there are fewer requirements to manage, right?
…no. Delivering optimized functionality with fewer features requires a better understanding of the most important requirements! 7
Mobile BI on the Microsoft Platform Requirement
Excel PivotTables, charts & slicers
SharePoint Enterprise Excel Services
Capability Renders HTML with basic Excel features Compatible with most devices & browsers Good mobile experience
SQL Server 2012 all editions
Renders HTML Compatible with most devices & browsers Good mobile experience
Power View
SQL Server 2012 Enterprise & BI editions SharePoint Enterprise
Requires Silverlight capable browser No current support for iPad & Surface RT
Power BI (Power View & Excel Services)
Office 365 subscription (after preview period)
Native Surface app HTML5 support for other devices
Reporting Services
8
Mobile BI in the Cloud Power BI Components Excel Pivot Tables & Visuals Windows Desktop
HTML5 / mobile browser Native Surface RT/Pro Native iPad
9
Power Pivot
Power View
Excel add-in only
adaptive: Silverlight, HTML & Surface app
n/a
n/a
n/a
?
Power Query
Power Map
Q&A
Excel add-in only
Excel add-in only
requires Silverlight
if Silverlight supported
Mobile BI in the Cloud Power BI
Azure Services Azure Websites
Azure VM
Azure SQL Reporting
Through Data Management Gateway (Manual refresh currently supported in preview)
On-premise data source
Demo Power BI on mobile devices
11
October 15-18, 2013 | Charlotte, NC
On Premise Mobile BI SharePoint Microsoft Stack
Non-SharePoint Microsoft Data Platform
Third-party Tools Microsoft Data Platform
Excel Services
Power View
Power Pivot models
Reporting Services
Tabular models
Multidimensional models
12
Reporting Services
Tabular models
UI / UX
Multidimensional models Multidimensional models
Tabular models
Relational SQL
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.
13
Demos Third-party mobile & custom UI on the Microsoft BI platform
14
October 15-18, 2013 | Charlotte, NC
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 15
Your Next Move
?
To the Cloud
Data size Compliance Control Cost
Modelling & Architecture SharePoint On Premise
Mobile Product
16
Q&A
[email protected] SqlServerBiBlog.com
17
Explore Everything PASS Has to Offer
18
Free SQL Server and BI Web Events
Free 1-day Training Events
Regional Event
This is Community
Business Analytics Training
Local User Groups Around the World
Session Recordings
PASS Newsletter
Free Online Technical Training
Session Evaluations
Submit by 5pm Friday Oct. 18 to WIN prizes
Your feedback is important and valuable.
ways to access
Go to passsummit/evals
19
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
Thank you for attending this session and the 2013 PASS Summit in Charlotte, NC
20
October 15-18, 2013 | Charlotte, NC