Month: October 2018

Power BI: IPL Analytics- Visualizations and Design Reports -Part 7

In my previous blog, we have seen how to add card visuals and little bit of  QNA feature of Power BI. Let us see how to add custom visual.

If we refer above image of second report, we can see a fish tank /aquarium visual with heading of Top 10 Extra runs by Bowler where fishes are of different sizes. This visual is not available in the default listed visuals in Power BI. However we can search for the visuals available in the market place. There are different ways to search such visuals.

  1. Either search in Google  as office store Power BI visuals as shown in below snippetCUstom visual1CUstom visual3
  2. Go in AppSource and search with the name if you already know. You can search in the top right search box or the main search box as shown in below snippetscustom visual4
  3. From Power BI desktop itself, just click on the extended menu and select “Import from marketplace”

cusom visual5

Select the Power BI certified visuals. Select the Enlighten Aquarium visual and click on Add button. The selected visual would be added in the in visuals list.

CUstom visual6
CUstom visual7

Let us select this new visual and drag and drop on the Report canvas. As mentioned earlier we want the fishes based on the Top 10 Extra runs by Bowler and size of the fish depends on the number of extra runs. Let us see how to configure this.

Drag the Bowler field from Ball by Ball table to Fish property, so that fish represents the bowler. Drag Extra runs field to Fish size, so that fish size represents the sum of extra runs as shown in below snippet.

cusom visual8

However this configuration would show all the bowlers and we want to show only top 10. To achieve this we need use filters. Under Visual level filters, for bowler field, select filter type as Top N.  Mention the number of records, here we enter 10. Filter criteria is Extra runs as shown in below snippet.

There are different filters available in the Power BI such as Visual level filters, Page level filters and Report level filter as shown in below snippet. Those can be used as required.

filters1

We have seen how to add custom visuals in Power BI reports in this blog. Here we have created two Power BI desktop reports. Let us move to Power BI service. In next blog let us see how to develop Power BI dashboards. I hope you are enjoying developing these reports along with me.

Thank you for reading my blog, if you have any questions please mention in the comments and hit the like button if you like my write up.

Keep Learning !! Happy analyzing and be Powerful 🙂

Continue reading “Power BI: IPL Analytics- Visualizations and Design Reports -Part 7” →

Power BI: IPL Analytics- Visualizations and Design Reports -Part 6

In my previous blog, we have completed the deign of first report, let us see what is different in second report. Here we will discuss about the Card visual and how to add Custom visuals. If we refer the above image of second report, we can see many Single numbers which highlight the specific values such as Runs Scored. Overs bowled, Total matches played and so on. These visuals are called as Card type visuals.

We can configure such visuals either by adding the card visual to the report, as we did for rest of visuals till now, or we can even directly add these visuals from QNA feature.

Let us first see how do we add it from the report designer. We need to drop this visual on the report canvas and follow the steps as shown in below snippets.Card1

If we want to highlight the total runs scored in all matches, let us select the Runs_scored field and select aggregate function sum in the  properties as shown in  below snippets. You can see the properties by clicking on the triangle on added field.

card2card6

It will display the card as shown in below snippet.

card3

On similar lines we can add multiple card visuals by selecting various fields we had created during the data modeling and different aggregate functions as shown in below snippets. For example, Average of Economy, Sum of  Overs by Bowler etc.

We can even format the card visual using the Format option like changing the font color, background color, font style etc.

As I mentioned above, we can create these cards by using the (Question and Answer) QNA feature as well. This feature was earlier available only in Power BI service and was later added in the Power BI desktop as well.  Let us try and create similar cards using the QNA  feature of the Power BI. It will be really quick to question the data and get answer in terms of visualization. For example, “how many total matches played?”, “what is the average economy in all matches?” etc. Kindly refer below snippets to see the steps to get this.

Either double click on the report canvas and it will allow to ask question or click on “Ask A Question” from the ribbon as shown in below snippet.QnA1

Referring to below snippet, as we start typing “total runs_s”, it would give us options based on available tables and fields in our dataset.

Qna2

It would automatically give you the response in Card visual as the answer is single number as shown in below snippet. It is similar to the card we have designed manually by selecting the visual and adding the field to it. We might need to do the formatting based on our requirements.Qna3

In case the answer is more than one number, it would respond as different visuals accordingly. We can ask different questions and get answers as shown in below snippets.

Qna6Qna5

QNA is a vast topic in itself. Let us discuss it separately in depth in some other post.

We have seen how to add card visuals in Power BI reports in this blog. In next blog let us see how to embed the custom visual in our report. I hope you are enjoying creating these visuals along with me.

Thank you for reading my blog, if you have any questions please mention in the comments and hit the like button if you like my write up.

Keep Learning !! Happy analyzing and be Powerful 🙂

Continue reading “Power BI: IPL Analytics- Visualizations and Design Reports -Part 6” →