Election in BC – Publishing and the Insights Part 3

In the first part I have prepared the data for the visualization, uploaded the data to the desktop version, deleted the unnecessary rows, populated the data in the empty rows and parsed the data. In the 2nd part I have created a custom color scheme using a designer that has generated a jason file and created some basic visualizations.

Now I got lazy, didn’t want to create the drill down visualization for the results by the regions and decided that PowerBI must create that for me using Insights.

The first step is to publish my local dashboard created in PowerBI desktop into my online account. I simply click Publish, login to my o365 client and publish to the group of my choice (Shipping). 

This action creates 2 objects:

  1. The report that I have just build
  2. The data set associated to the report that I have created from the 2 html pages in part 1

The next step is clicking on the small lamp icon to see all the insights! So I am getting the Quick insights by PowerBI:

or…I can create a dashboard, by going to the report and choosing to Live pin all the data visualizations.

The dashboard:

On the top I can ask questions about my data, such as: How many NDP? and get the answer: 717,073 NDP

Number of Candidates? was auto complete to Number of Candidates ballot names (this is the column name after all…) and the answer is: 369.

I can pin each data visualization separately, to get the insights, unlike with Live pin which only gets the visualization.  Even create another one with another color scheme, to which I can get the insights from the dashboard itself.

On the left, the default colored election results; on the right the insights by district

In order to share it with the entire Organization I have created an App! This is the new feature from PowerBI and this will be discussed in a separate post.

The report is right here with all it’s vibrant colors! I have added it by simply clicking File-> publish to the web and added the created i frame to the Text (code view) of this WordPress post