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

In my previous blog, we have seen few steps to design Power BI report. Let us continue to develop this report by adding different visualizations of this data for the IPL Analytics in this blog.

Now let us create our first Power BI Chart in first Power BI report which is at the center top of the report- “Select Season year”. Let us use the  Treemap chart to create this visualization. Power BI gives you the flexibility to drag and drop the charts on the report page and configure the same.

Let us follow the steps as shown in the below snippets and configure the chart.

Drag and drop the Treemap visualization on the page at top and center position of the page.

New Report-first chart

New Report-first chart1

Once the visualization is dropped on the page and it is selected, we can see its properties in the right section below the chart icons.

Adding Data fields for X and Y axis: We want to show the year and count of matches played during that year. Select the match_id from the Match table. Drag and drop this field in the value box as shown in below snippet. It would be count of matches

New Report-first chart2As we need to group the match count by season year, select the Season year field and drop under group section.New Report-first chart3

Resize the chart as shown in below snippet.

New Report-first chart4

 If we want to display all the blocks in same color, we can go in the report formatting section and apply same color to all the data boxes as shown in side snippets. If you really want to go ahead and explore the  Power BI capabilities, try to play with various properties of the charts/visualizations and understand more.

We have completed configuring our first chart in Power BI report.

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 2”

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

In my previous blog we have seen data modeling and data transformation techniques. Now let us see how to represent this data in different visualizations and Power BI reports.

Let us design our first Power BI report ” Indian Premier League Matches : 2008 -2017″.

By Default one blank page would have been added to the report, in case we are not able to see the same, we can click on chart icon shown on the left navigation bar or click on New page on the ribbon as shown in below snippet.

New Report

Once we are on this blank page, let us try and design the report which is shown in top image.  We can change the background color of the report and add the image of IPL to it’s background. Let us follow below steps to do so. Power BI desktop has a right wide window showing the Fields and Visualizations as collapsible sections.

Fields Window shows the tables and corresponding fields which are available in Power BI desktop and Visualizations section shows the different chart options which are available in Power BI desktop.

In Visualizations- we can see lot of chart icons shown which can be dragged in Power BI reports and below we can see two icons which are used for chart fields and formatting.

When we are on the blank page,  select the formatting and let us try to change the background color as shown in below snippets

New Report-AddIMage

New Report-colour

Now let us add background image to the report . Click on the Add Image button and browse the image file and select the image.New Report-AddIMage1

Once the image is selected, it will be set as background image of the report as shown belowNew Report-AddIMage2

Now let us add the report heading at the right corner of the report. Add the Textbox as shown in below snippet and add the heading.

We have seen few steps to design Power BI report. Let us continue to develop this report further by adding different visualizations of this data for the IPL Analytics 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 1”