POWER BI TUTORIAL: SURFACING POWER BI DASHBOARD IN POWERPOINT

~ nikilprabhakar ~ 1 Comment

Power BI Tiles add-in provides the capability to add interactive Power BI Tiles to PowerPoint. Let's see how to do it Open PowerPoint From the ribbon select Insert -> My Add-ins If you do not have Power BI Tiles add-in, click on Find more add-ins at the Office Store and search for Power BI Tiles … Continue reading POWER BI TUTORIAL: SURFACING POWER BI DASHBOARD IN POWERPOINT

More Robust Tile Pinning to Dashboards Introduced in Last Power BI Service Update

~ Business Intelligist ~ Leave a comment

Microsoft is making pinning a tile to a dashboard more user friendly with its last weekly Power BI service update. It was not always apparent what dashboard the tile would be pinned to; therefore, the dialog box above will make it much clearer to a user. More details for the weekly update are available here. … Continue reading More Robust Tile Pinning to Dashboards Introduced in Last Power BI Service Update

POWER BI TUTORIAL : HOW TO SURFACE EXCEL REPORTS IN POWER BI SERVICE

~ nikilprabhakar ~ 1 Comment

There are a couple of options to surface Excel Reports in Power BI Service. Download the sample file to OneDrive. The file contains a PivotTable report and a Power View report. Sign into PowerBI.com and from the left panel click on Get Data From the Get Data screen, click on Get button under Files section … Continue reading POWER BI TUTORIAL : HOW TO SURFACE EXCEL REPORTS IN POWER BI SERVICE

Power BI Tutorial: Transform data from folder data source

~ nikilprabhakar ~ 1 Comment

Data for the tutorial can be obtained by downloading CSV files from: https://www.census.gov/popest/data/intercensal/state/ST-EST00INT-02.html For the tutorial I downloaded data for Alabama, Alaska and Arizona into a folder. Open the CSV files, and notice that all of them have the same layout. In this tutorial we are going to: Read data from the folder data source … Continue reading Power BI Tutorial: Transform data from folder data source

Power BI Desktop Tutorial: Building a Star Schema from an Excel Source

~ nikilprabhakar ~ 2 Comments

An updated version of this tutorial (including a video lecture) is available here: https://businessintelligist.com/?p=2718 This tutorial shows how to create a Star Schema using Power BI Desktop. Data for the tutorial can be obtained by downloading Excel file from here Very often our analysis starts with a flat data set that contains all of the … Continue reading Power BI Desktop Tutorial: Building a Star Schema from an Excel Source

The Definitive Guide on Collaboration in Power BI. Tutorial on Groups, Sharing, Coauthoring and Content Packs.

~ Business Intelligist ~ 4 Comments

Well, not really that definitive actually… Before we jump into the details, I have to admit that I fully expect this post get outdated very soon. The collaboration features that have been released with GA of PowerBI 2.0 on July 24th 2015 are still not very refined and are very likely to become much more … Continue reading The Definitive Guide on Collaboration in Power BI. Tutorial on Groups, Sharing, Coauthoring and Content Packs.