Tag Archives: Power BI

Becoming a Speaker

One of my goals for 2016 is to speak at a local SQL Server User Group and a SQL Saturday event. Am very glad both of my goals did come to fruition before end of Q2.

I wanted to pick a unique topic for my presentation and Power BI Desktop Fundamentals was an apt choice for it. It was a new tool and very less people know about it and hasn’t been presented in my local user group. I focussed on developing a 101 course on Power BI covering the basics from top features, creating dashboards and story telling with it.

I got an opportunity to present it on April 19,2016 at Charles I. Ecker Business Training Center of Howard Community College for Baltimore SQL Server User Group.

This was how I looked while presenting:)

Junaith at BSSUG

Had to rush to the meeting after my work hour and while setting up the projector it didn’t work, I got very tensed and found a work around..phew!! FInally when I started presenting everything got settled!

Out of humility, I should say it was  huge success and no one slept in the room:) Lot of good questions from the audience and I was surprised to see many companies have started to use it.

I was deeply moved by the comments.

Mark

 

Vakul

 

 

 

 

 

 

 

Thank you Jeremy Kadlec and the Sponsors for giving me the opportunity.

Speaking at SQLSaturday Baltimore;

On April 30, 2016 I got a chance to speak at SQL Saturday Baltimore BI Edition it was a dream come true moment to share the stage with MVP’s and other expert.

We had a nice Speakers Dinner at a Turkish restaurant and hundreds of people attended the conference next day, the whole event was organised by huge efforts of Slava Murgyin and Ravi Kumar, kudos to their hardwork.

My Badge!!

My Badge!!

 

 

 

 

 

 

With Ravi

With Ravi

 

 

 

 

 

 

 

 

 

 

 

 

 

I was really motivated by these opportunities and want to keep this going and during Q3 I want to take it to next level and present a Power BI Advanced topic.

Hope I do it!!

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