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

Election in BC Part 2 Colors!

In the first part I have prepared the data for the visualizations, I was complaining about colors in the existing article so let’s start by making this all look like a circus!

Preparing custom color scheme –

I did mention that I didn’t like the colors int he existing news story so I have tried the Color Scheme Generator, in the PowerBI tips and tricks blog (Really recommended!!!) recommended by @Chass in his video Better use of colors in Power BI (Guy in a cube channel). I have created a scheme of my own!

 After Choosing the colors, I have downloaded the color theme to my computer and Upload it to my PowerBI desktop.

The scheme was imported using the Switch Themes  in the home ribbon tab.

I love the Tree Map visualization, also a heat map comes in mind. For the parties in each region it seems like a good fit even without the regions actual map. Another version of the same is the brick map. The simple bar chart gives more accurate information but the Tree Map can tell the same story. I have decided to put them side by side for my first report page just to see what makes more sense for people?

You might be able to vote on the one you like the best… (part 4?)

There is one more subject that is covered by the map visualization.

So I have started creating the new visual in a separate page, but then I have realized, PowerBI can tell me all this by simply clicking on “Insights”.

What do I have to do for that? To Publish it – Will explain in Part 3