Click to edit Master subtitle style

Power BI Sites and Mobile BI

What You Will Learn

• Sharing and Collaboration

• Introducing Power BI

• Exploring Power BI Features and Services

• Partner Opportunities

• Resources

Sharing and Collaboration

• Excel BI solutions are authored by using the Excel client• It is usually inappropriate to share the solutions by forwarding the

workbook to other users- Requires that the user has Excel installed, and possibly the add-ins

- The user can view data model data, and modify data model/query/report definitions

- Current data may not be available as data refresh may not work from their location, or by using their credentials

- Workbook versions are difficult to control

- IT cannot monitor usage

- Permissions can no longer be centrally managed

Sharing and Collaboration (continued)

• It is preferred to share Excel BI solutions in managed ways• Microsoft provide three managed alternatives:

- SharePoint 2013 (on-premise) – Enterprise Edition

- Office 365 (cloud) – ProPlus and E3 Editions

- Power BI for Office 365 (cloud)

Sharing and CollaborationSharePoint 2013

• SharePoint include Excel Services to enable the loading, calculation, and browser-based rendering of Excel workbooks- The user does not need Excel installed

• SharePoint 2013 can also be extended with SQL Server add-ins:- Power Pivot for SharePoint- SQL Server Reporting Services

Sharing and CollaborationSharePoint 2013 – Power Pivot for SharePoint

• The Power Pivot for SharePoint add-in installs a collection of server components that provide query processing and management control for Power Pivot workbooks that are published to SharePoint- Maximum supported document size is 2GB

• Features:- Power Pivot Gallery site template to preview workbook contents, and to

launch new analytic experiences and a new Power View report

- Self-service configured automated data refresh

- Logging and a dashboard to enable IT to monitor server health, workbook sizes, number of connections and queries, and data refresh failures

Sharing and CollaborationSharePoint 2013 – Reporting Services

• When Reporting Services is integrated with SharePoint, it enables the creation and rendering of Power View reports in the web browser

• Supports the same Power View capabilities as those available in Excel 2013, in addition to:

- Connecting to multidimensional data models (with SQL Server 2012 CU4)

- Producing a report consisting of multiple views

- Printing reports

- Exporting a report to produce a PowerPoint presentation

- Previewing the reports in the Power Pivot Gallery

Sharing and CollaborationOffice 365

• Office 365 provides cloud storage for documents• Excel Web Apps can render Excel workbooks in the cloud

- Users can view and interact with reports based on the Power Pivot data model, including Power View sheets

• Data refresh and IT monitoring is not supported• Maximum supported Power Pivot workbook size is 10MB

Sharing and CollaborationPower BI for Office 365

Collaborate in Office 3651 in 4 enterprise customers on Office 365

Share Find

Q&A

Mobile

Insights in Excel1 Billion Office Users

Analyze VisualizeDiscover

Scalable | Manageable | Trusted

Sharing and CollaborationPower BI for Office 365 – Continued

• Power BI provides powerful new ways to work with data and Excel in Office 365- Self-service BI with the familiarity of Office and the power of the cloud

• Empower users with self-service in Excel• Enables connecting and collaborating in Office 365

- Maximum supported Power Pivot workbook size is 250MB

- Support for data refresh from on-premise data sources

- Includes many new compelling capabilities and features

Introducing Power BIEmpowering Users with Self-service in Excel

Analyze

Visualize

DiscoverSearch and combine public and internal data with Power Query

Model & analyze 100’s of millions of rows lightning fast with Power Pivot

Explore and visualize data in new ways with Power View and Power Map

Introducing Power BIConnecting and Collaborating in Office 365

Share queries & workbooks and refresh from on-premises data with BI Sites

Find answers with search-based data visualization in Q&A

Stay connected from anywhere with HTML5 and the Power BI mobile app

Share

Find

Q&A

Mobile

Exploring Power BI Features and ServicesPower BI for Office 365

• The following services extend the self-service BI capabilities in Excel by making them available in a collaborative online environment- Power BI Sites

- Power BI Q&A

- Query and Data Management

- Power BI Windows Store App

Exploring Power BI Features and ServicesPower BI for Office 365 – Power BI Sites

• Power BI sites application customizes a SharePoint Online site for Power BI purposes and activities

• Available with a subscription to Power BI for Office 365• Only supports Excel workbooks, which, when rendered to the

browser, are viewed with the Excel Web App- Power View reports can be optionally displayed by using

HTML5• Supports workbooks up to 250MB in size• Sites provide access to a management portal to:

- View usage analytics for published queries- View and manage data sources

Exploring Power BI Features and ServicesPower BI for Office 365 – Power BI Windows Store App

• Provides live mobile access to the important business information stored in a user’s Office 365 account

• The app enables viewing and interacting with Excel and Power View content

• Requires Windows 8 or Windows RT tablet or PC, including Surface• Currently, the app is not supported on:

- Windows 8.1, iPad, Mobile phones or Android devices

Consider viewing them in browser with SharePoint Online site by using HTML5

Exploring Power BI Features and ServicesIT Infrastructure Services for Power BI

• From an IT infrastructure perspective, these services get Power BI running, and enable IT professionals to provide, manage, and secure Power BI services• Provision Power BI for Office 365• Power BI Admin Center• Data Management Gateway

Exploring Power BI Features and ServicesIT Infrastructure Services for Power BI – Provision

• IT administrators are responsible for provisioning a Power BI tenant• Presently, Power BI can only be provisioned in preview• The process is documented, and relatively straight forward and

quick (~15 minutes)• As an administrator, users and groups can be then be added• Samples can be added to explore the Power BI capabilities

Exploring Power BI Features and ServicesIT Infrastructure Services for Power BI – Power BI Admin Center

• Allows IT administrators to:- Expose data from on-premise data sources as OData data feeds

- Enable users to refresh Excel workbooks in SharePoint Online with data from on-premise data sources

• A Data Management Gateway must be installed and configured to provide access to on-premise data- At least one gateway must be installed in a corporate environment before

creating data sources in the portal

Exploring Power BI Features and ServicesIT Infrastructure Services for Power BI – Data Management Gateway

Enabling Corporate OData Feeds

Enabling Excel Workbook Data Refresh using

SharePoint Online

Enabling Discovery in Power Query

X

capabilities

Power BI Admin CenterData Management Gateway

Power BI for Office 365Licensing and Availability Overview

Available early 2014

Priced per user per month

Subscription model

Cloud based

How to Buy Power BI

22

On-premises Cloud-based

Flexible BI Solutions: On-Premises or Cloud

Partner Opportunities

• Use Power BI to maintain a secure, widely-accessible and centralized site for discovering and sharing “single version of the truth” data, logic and reports

- Reduces the barriers to deploying a BI environment for sharing reports and accessing information

• Publish Power Query queries for discovery and data consumption

• Enable manual or automatic data refresh of data models, even to on-premise data sources

- SQL Server, SQL Azure, internet OData data feeds, SharePoint lists, Power Query queries

• Use natural language query to enable intuitive report requests

• Deliver Power View reports to any HTML5-capable mobile device

- Without a dependency on Silverlight

©2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Office, Azure, System Center, Dynamics 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.