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

In my previous blog, we configured Map visualization, Let us add few more visualizations in the same report.

If we want to show winning percentage of the all teams based on the total matches played, we can use Donut visual. Donut visual is very similar to pie chart, only difference is the center of the chart is blank which helps for better labeling of the data values. One important feature is it always shows the comparison with whole instead of comparing individual parts.

As usual, let us drag and drop it on the report canvas.

Donut chart1

We want to see the winning percentage of the teams, which can be achieved by adding match_winner in the details and match-id in the values property. It automatically shows the count of match_id.

Donut chart2

Here we want to show percentage, hence let us select the percent of  grand total in show values as shown in below snippet.

Donut chart4

On similar lines we can have the Pie chart as well. We can see how both visuals would look like in below snippet.

Donut chart3

Let us add one more visual to see how many matches were played in each season. Let us use the Area chart to show his data. Drag and drop this visual on the report canvas as shown in below snippet.

AreaChart1

We have to set the x axis as season_year and values as match_id as shown in below snippet.

AreaChart2

Configured Area visual would be shown as shown in below snippet.

AreaChart3

Let us add one more visualization in this report. We want to show winning analysis based on the toss decision to do the batting / bowling. Let us use the Bar chart  for the same as shown in below snippets

Barchart1

Let us map match_winner to Axis parameter and Toss_name to show the Legend. Count of match_winner would be the value to be displayed as shown in below snippet.

Barchart2

Here is finally how our chart would look like.

Barchart3

We have learned configuring basic Donut, Pie, Area and Bar visual in Power BI.

To logically end the design of this report and start with another report in my next blog, let us extend this blog a little bit and see how tabular visual works in Power BI. Again very similar process to drop a visual on the report canvas.

Table visual1

Referring to my earlier posts of data modelling, we have created few custom columns in this Match table to see if the match was won by how may wickets or how many runs. Let us add those fields in the Values of the visualizations and those would be displayed in the table as shown in the below snippet.

Table visual2

Our configured visual would look like as shown in below snippet.Table visual3

In next blog let us see the design of second report in which we would learn more about Card type of visuals and how to add custom visual in the 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 5”

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

In my previous blog, we configured Slicer visualization, Let us add few more visualizations in the same report.

If we want to show the match locations on a World map along with the density of number of matches played in a visual way, we can use the Map Visual as shown in below snippet. As usual, let us drag and drop it on the report canvas.

New Report-Second chart1

Once its dropped at the center, we can resize it as required and place it at the required place in report canvas. If you see in the below snippet, we can see the location as one property of the visual where we mapped the City-Name. On the similar lines we can use any other location field. If you remember in my earlier data modelling post, we have changed the type of this field to City so that we can use this field in Map visuals.

There are multiple other properties of the Map visual which can be used as mentioned below-

Size: this would determine the size of the bubble at that location. Here we have Count of match_id which decided the size of the bubble.

Color Saturation: this would determine the darkness of the color based on the field associated with it. Here we have Count of match_id which decides the color saturation of the bubble.

My recommendation would be to try out various settings of the visual so that you are comfortable using the same.
New Report-Second chart2

We can see the various sizes and color shades at match locations in below map visual
New Report-Second chart3

If without dropping the Map visual, we directly select any location type field and drag and drop on the report canvas, it will automatically add the Map visual and set its location property to selected Location type field.

We have completed configuring basic Map visual in Power BI.

Let us continue to develop this report by adding more visualizations in my next blog. I am sure you would love to do this 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 4”