ny london paris munich n.
Skip this Video
Loading SlideShow in 5 Seconds..
NY, London, Paris, Munich PowerPoint Presentation
Download Presentation
NY, London, Paris, Munich

Loading in 2 Seconds...

play fullscreen
1 / 20

NY, London, Paris, Munich - PowerPoint PPT Presentation

  • Uploaded on

NY, London, Paris, Munich. Everybody’s Talkin ’ ‘bout Mobile BI. Paul Turley, Mentor SolidQ. Please silence cell phones. a little about me. BI Mentor. SqlServerBiBlog.com. 2009. 1989. 1996. 2013. 1979. 1994. 2011. 2004. 2002. a little about you. Continent. Distance.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

NY, London, Paris, Munich

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
ny london paris munich

NY, London, Paris, Munich

Everybody’s Talkin’ ‘bout Mobile BI

Paul Turley, Mentor


a little about me
a little about me

BI Mentor











a little about you
a little about you



Job Role

What did you Come to Learn…

Returning to implement

session description
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

what makes a bi solution mobile
What Makes a BI Solution “Mobile”?

Touch gesture & tablet user interface

Tactile, responsive & interactive

Optimized for screen size & navigation

Mobile browser capable

understanding mobile bi requirements
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?

mobile bi on the microsoft platform
Mobile BI on the Microsoft Platform



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

mobile bi in the cloud
Mobile BI in the Cloud

Power BI Components

Power Query

Excel Pivot Tables & Visuals

Power Pivot

Power View


Power Map

adaptive: Silverlight, HTML & Surface app

Excel add-in only

requires Silverlight

Excel add-in only

Excel add-in only

Windows Desktop


/ mobile browser

if Silverlight supported


Native Surface RT/Pro


Native iPad



mobile bi in the cloud1
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



Power BI on mobile devices

on premise mobile bi
On Premise Mobile BI

Non-SharePointMicrosoft Data Platform

Third-party ToolsMicrosoft Data Platform

SharePointMicrosoft Stack

Excel Services


Reporting Services

Reporting Services

Power View


Tabular models

Power Pivot models

Tabular models

Tabular models


Relational SQL


products to consider examples not an endorsement
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.


Industry-standard visualization and analysis tool suite; elite-class

Desktop, server and new Personal tool


Mobility enhancements for native mode SQL Server Reporting Services. Streamlined menus and folders, extended parameter enhancements, personalization. Deep history with product.


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.



Third-party mobile & custom UI

on the Microsoft BI platform

mobile dashboard design essentials
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
your next move
Your Next Move


To the Cloud

Data size




Modelling & Architecture


On Premise

Mobile Product





explore everything pass has to offer
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

session evaluations
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

thank you

Thank you

for attending this session and the 2013 PASS Summit in Charlotte, NC