Tag Archives: Power BI Desktop

Getting started with R scripts and R visuals in Power BI Desktop

The Power BI team announced its support to create R visuals in its recent update and in this tip we’ll help you get started by walking through what R is, how you can configure Power BI Desktop to run R scripts and create R visuals in Power BI desktop.

R is an open source and powerful statistical programming language used by statisticians, data scientists and researchers for data mining and data analysis. R scripts can be written using an IDE (Integrated Development Environment) like RStudio, Revolution-R and Live-R. If you are new to R, you can draw the following analogy of R to SQL queries for its application in Power BI Desktop. Like how a BI Developer creates queries in SSMS and uses it in a reporting environment such as SSRS, with this update we can use R scripts created in RStudio and use Power BI Desktop to create R visuals which will generate the same R visuals if they were to be created in RStudio.

Follow the rest of article from MSSQLTips.com

Create Bell Curve and Histogram with Power BI Desktop using DAX

Companies often use a Bell Curve approach to measure performance of various aspects of the business, such as employee performance. A histogram is a statistical concept and according to Wikipedia it is defined as “a graphical distribution of the numerical data”. A histogram is made of several bins and a bin can be considered a range of values or a benchmark.

As part of this process, we have to divide the entire range into multiple bins and the range should be unique and continuous. Our grades in high school (i.e. A, B, C, D, E, F) can be considered an individual bin. If a teacher plots the student marks across the grades (bins) in a bar chart it sometimes follows a bell shaped pattern with a mix of high grade, medium grade and low grade students which could be used for assessing students. The same could be applied at company level by plotting an employee performance metric across bins to understand and assess employees.

Follow the rest of the article from here

Baltimore Ravens Performance Report

I have never been a Foot Ball fan in my life but I wanted to follow this NFL season and support my home team Baltimore Ravens. I wanted to know more about team Ravens over the years and their performance, other than the fact they won the Super Bowl in 2012 (When I moved to Baltimore:-)).

So, I need a Performance Report for team Ravens and I know for sure, Power BI will be the best choice for this analysis. Quickly opened a new project in my Power BI Desktop and connected to the Source  by Get Data –> From Web option and fetched the data I needed.Power BI Desktop was handy enough and was able to create the following dashboard within 30 minutes.

 Baltimore Ravens Dashboard

As the scope of this article is not related to creating this dashboard and it is only to analyze and understand team Ravens, let’s get started.

The top most chart shows the Regular season – Win and Loss by Baltimore Ravens from 1996 till last year.

Sort by Won and Loss Befor Sort

A team will play 16 regular games to qualify for the Play offs (next level). From initial analysis we can find Ravens has a good mix of Loss and Win from their start.When you hover the mouse over the top right corner and sort the report by Won.

It gets sorted like,

Sort by Won and Loss After Sort

From this we learn, Ravens won maximum games in 2006 with 13 wins and lost the most in 1996 by losing 12 games.

The Second Chart shows the Loss and Win by Coaches and Bellick is the most successful coach with 80 wins and click the mouse over Bellick in the chart.The dashboard returns data only for Bellick like below.

Belllick Successfull Coach

 We can infer, Bellick is the most successful coach for Ravens and served for 9 seasons from 1999 to 2007.

Let’s look at the third chart, it’s pretty clear Ravens won the Super Bowl title for 2 seasons by clicking the Won SB data field, we learn Ravens won in 2000 and 2012.

Won Two Super bowls

AV is the approximate value calculated for a player and Ray Lewis topped the team for 8 years.

Ray Lewis Topped

 

Let’s look at our final chart Offensive and Defensive trend rating.

Offensive and Defensive Trend

For a good team their offensive and Defensive rating should be positive. The historic trend shows Ravens was a better defensive team.

I filtered the report to show the trend only for the years they made to Playoffs.

Playoffs Offensive and Defensive Trend

Surprisingly, they had both their Offensive and Defensive ratings as positive for these years which made them in to playoffs

Note: Read the article again, all the bold sentences are our learning’s from the dashboard.

Hope you have learn’t about Ravens, feel free to post your thoughts in the comments section.

#BaltimoreRavens #GoRavens #NFL #GameDay #PowerBI #Junaith Haja