Search

DataChant

Chants of big data & bigger insights

Month

April 2016

Power BI Templates

Microsoft released today a new update of Power BI Desktop with some new cool features here. In particular, I find the new support for templates as one of the more powerful tools, as it allows me to easily reuse my dashboards in the most easier way 🙂

Let’s see an example using one of the dashboards that analyzes a specific Facebook Page:

Screenshot_50

I opened the .PBIX file and clicked Edit Queries.

Screenshot_52

There is a new button – Manage Parameters.Screenshot_53

Continue reading “Power BI Templates”

Advertisements

Watch our webcast at PASS Excel BI Virtual Chapter

Hi everyone,

If you missed our post here, or want to refresh your skills on Excel, Power Query and analysis of Facebook Page Insights, check out our recorded webcast at PASS Excel BI Virtual Chapter, which walk you through the creation of an Excel report that measures the engagement level of Facebook Pages.

In the demo we compare all US Election Candidates by their storytellers on Facebook.

Enjoy the movie 🙂

Presidential Word Cloud in Power BI – Part 2

As promised, today we will continue working on our Presidential Word Cloud that we have started here, and will focus on two important and useful techniques which are not only relevant for Facebook analysis in Power BI:

  1. We will learn how to extract words from textual columns without splitting the column to many columns.
  2. By splitting messages to single words, our Word Cloud visual in Power BI will work better, we will be able to resize it, and drill down from a single word to its original message.

Oh, and the relation to Ghostbusters will be revealed at the end.

To recap our current challenge – In our last tutorial we have created a Word Cloud which is not resizable.

Screenshot_1

To fix this limitation, we will need to create a new column in our query for the individual words, and feed this column to the Word Cloud visual.

Let’s start.

Continue reading “Presidential Word Cloud in Power BI – Part 2”

Presidential Word Cloud in Power BI

One of the visualizations that I really love is tag cloud, or Word Cloud as it is called in Power BI. It usually grabs the viewer’s attention and provokes emotional reactions that can help you to touch your audience. I have used it fervently in key presentations in the past (Here is a great website to create tagclouds for ad hoc presentations), and was eager to find a good excuse to use it, when Power BI announced the Word Cloud custom visual.

So today we will build a Word Cloud 🙂

To make it interesting, I thought it would be cool to continue our Facebook series and build a Power BI report with a Word Count of the Facebook posts of all the US Election Candidates. The tutorial will have two parts. Today we will focus on the first one that builds a quick and dirty word cloud report. To see what you can get after we go through the second part go here and enjoy the finished dashboard on Power BI.

In this tutorial you will learn how to extract your posts from your brand’s Facebook Page and load the words into Power BI (Or Excel, if you are familiar with the Power Query / Get & Transform user interfaces). You will also learn some cool tricks that will help you to extract multiple offsets from Facebook Graph API, and to load multiple pages (using the query function technique).

Continue reading “Presidential Word Cloud in Power BI”

Blog at WordPress.com.

Up ↑