Power BI Story in PPT Slides with Comments

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

2016-09-05_11h29_50

This is not story of Power BI in Power Point slides. This post is about how to use Power Point integration with Power BI for story telling of Power BI reports and dashboards through slides, and also give some users features such as commentary. This features is not a new feature, it has been released almost a year ago! but because many people still are not aware of such feature, I intended to write about it in a post. In this post you will learn;

  • Enabling Power BI Power Point Integration
  • Pin Live reports and dashboards elements in Power Point Slides
  • Using Power Point and Power BI from storytelling with commentary feature

If you want to learn Power BI, read Power BI online book; from Rookie to Rock Star.

Prerequisite

Dashboard and reports used in this example are sourced from Power BI Desktop; The First Experience.

Power BI Tiles

Power BI Tiles is an add-in for Excel, Power Point and few other Microsoft Office products version 2013 SP 1 or later. This component is developed by DevScope. Please note that this is not Microsoft built-in feature. However it can be used easily with Microsoft Power BI and Power Point. This component enables Power BI reports and dashboard elements to be pinned in Power Point slides. Download this component and install it from there, or from your office project.

Installation

Open Power Point, create a blank slide deck, then insert a BLANK slide, and from Insert menu option, click on My Add-ins

2016-09-05_09h59_42

From My Add-ins you might see Power BI Tiles if you have installed that before. otherwise go to Store tab, and search for Power BI

2016-09-05_11h16_12

After adding this add-in you will be ask to enter Power BI account related to this, and also authorizing Power BI tiles to access reports and dashboards in your Power BI cloud storage. After authorization you will see a box including list of dashboards in your work space will appear.

2016-09-05_11h18_17

Adding Power BI Tiles to Slides

This box is Power BI Tile added to your slide. You can select any of dashboards you want. for this example I use the dashboard which is related to Pubs Data Analysis Demo I’ve done before. After choosing a dashboard you will see one of its tiles appear here.

2016-09-05_11h21_03

This is only one of the tiles in the existing dashboard, You can navigate between tiles by two navigator arrow buttons highlighted above.

2016-09-05_11h22_42

Here is the dashboard in full view in Power BI service. as you can see in Power BI Tiles add-in we can navigate between tiles individually.

2016-09-05_11h24_12

Once you chose the tile, you can leave it there. It is already embedded into your Power BI slide. You can now add another Power BI Tile, again from My Add-ins and this time Power BI Tiles is there. Note that you can build similar dashboard here in Power Point with adding each item as a tile.

Storytelling with Power BI and Power Point

2016-09-05_11h29_50

You can see here that I’ve added a title for this slide in Power Point, and also a Textbox with text “Psychology has the most sales”. Yes, with this method you can add commentary to Power BI reports and dashboards, you can tell the story behind the data with integration of Power BI and Power Point. very simple feature but really useful.

Under each Power BI tile in Power Point there will be a link to Power BI

2016-09-05_11h35_33

When you click on this link, it will open that Power BI dashboard or report in a browser. This provides you the navigation from a high level story point to the detailed report in Power BI service.

Images or Re-Loaded Tile Feature

By default Power BI Tiles are interactive tiles that can be refreshed and clicked, highlighted, and interactive. However if you want them as an image only tile, you can choose it from top right hand side of Power BI tile.

2016-09-05_12h47_57

Working with other Work Spaces

You can navigate to all other work spaces that you are part of, and see all reports and dashboards under it. by default Power BI Tiles will look into “My Workspace” (named as Personal Workspace), but you can change it from the top side of Power BI Tile.

2016-09-05_12h50_17

You can also bring a Power BI public report ( a report that is published to web) into a tile

2016-09-05_12h51_13

Reports in Tile

If you choose dashboard, then you can pick one element of dashboard in each tile. but if you choose a report. For example “Pubs Analysis” report we’ve built in another example, then you will see the whole report in tile, with all report pages, and filter pane.

2016-09-05_12h55_43

The view of report is fully interactive here. For example if you hover on something or click on something you will see it responds like any other Power BI reports (but in Power Point slide)

2016-09-05_12h57_16

Summary

Power BI and Power Point integration helps to tell story behind the data much easier. You have presentation and story telling features of Power Point, plus interactive visual, refresh-able from cloud features of Power BI.  Good news is that Microsoft team is working on another integration feature named “Export to Power Point” which will be released very soon I believe. I’ll put together another post when that feature comes live.

Save

Save

Save

Save

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Reza Rad
Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in Data Platform for seven continues years (from 2011 till now) for his dedication in Microsoft BI. He is author of some SQL Server and BI books, and also Power BI online book; from Rookie to Rock Star.

4 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">