cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

NFL Fantasy Football Player Comparison Tool

08-29-2017 18:04 PM

DavidLanagan
Advocate IV
24591 Views
DavidLanagan
Advocate IV
Advocate IV

NFL Fantasy Football Player Comparison Tool

โ€Ž08-29-2017 06:04 PM

Fantasy Football Player Comparison Tool

With the new NFL season just around the corner its time to prepare for your fantasy draft!

Use the fantasy football player comparison tool by selecting player 1 & player 2 from this lists provided. The report allows you to compare players by viewing key stats including total fantasy points for the previous season, projected receptions, yards and touchdowns for the upcoming season as well as this seasons NFL.com 2017/18 predicted points total.

What IFs have been included to allow the user to create their own player projections under the sections 'Calculate Your Own Projection'. Simply adjust the selected player/s yards and touchdown amounts to see how it will affect their overall fantasy points. The scoring is based on the standard NFL.com fantasy scoring system.

An option has also been included for PPR (points per reception) leagues, if your league is a PPR league then select 'Yes' in the top left corner and the overall points calculation will then also take into account the added points for each of the players receptions.

The data used is courtesy of - http://fantasy.nfl.com/research/projections, http://www.nfl.com/stats/player

Preview file
363 KB
Labels:
Message 1 of 45
24,591 Views
adumbrell
New Member

โ€Ž01-14-2021 10:19 AM

David,

 

Sweet tool, Might to be able to acutally win a few games with this ๐Ÿ™‚  

Would you mind sending the pbix file to me at drew.d@outlook.com 

 

Thanks in advance

Message 45 of 45
328 Views
0
theia
Frequent Visitor

โ€Ž07-28-2020 06:58 PM

hello, david

that is awesome!

i am really spent many times look like that report

please tell me send me the pbix file  if you that`s okay

Message 44 of 45
643 Views
0
Alice_Drummond
Advocate II
Advocate II

โ€Ž01-20-2019 05:57 PM

This is really cool - awesome use of PowerBI. I'm looking to create a similar one for the Australian Rules Football - are you able to send me a link to the .pbix file? It would provide an excellent template! 

 

Thanks for sharing!  

Message 43 of 45
974 Views
0
preetparmar
Frequent Visitor

โ€Ž09-13-2018 11:29 AM

I really love the report. Amazing work. Would you be wiling to share the file so that I can try to understand the steps and the logic behind things.

Thank you

Message 40 of 45
1,482 Views
DavidLanagan
Advocate IV
Advocate IV
In response to preetparmar

โ€Ž09-14-2018 07:15 AM

Hi,

 

The PBIX file is already uploaded, it is up earlier in the chat.

Message 41 of 45
1,033 Views
0
preetparmar
Frequent Visitor
In response to DavidLanagan

โ€Ž09-14-2018 09:27 AM

Thanks!
Do you have some kind of document or steps which I can go through in order to understand how exactly you made sucha wonderful report?

 

Message 42 of 45
1,032 Views
0
AdamIzzo
Regular Visitor

โ€Ž08-17-2018 03:54 AM

This is really cool David!

 

I was wondering if you could possibly share your .pbix file as I would really like to know how this is done.

 

Thanks in advance.

 

Message 38 of 45
1,535 Views
DavidLanagan
Advocate IV
Advocate IV
In response to AdamIzzo

โ€Ž08-21-2018 04:44 AM

Hi - Thanks for the comment, the PBIX is further up in the chat.

 

All the best,

David

Message 39 of 45
1,524 Views
0
DavidLanagan
Advocate IV
Advocate IV

โ€Ž04-03-2018 02:18 PM

Hi Guys,

 

Attached is the PBIX file as I have had a few requests to upload.

 

Any questions feel free to reach out.

 

All the best,

David 

NFL FF David Lanagan (WHAT IF COMP).pbix
Message 32 of 45
1,602 Views
0
Drew248
Frequent Visitor
In response to DavidLanagan

โ€Ž08-02-2018 06:12 AM

Hello David, Would you be able to share how you had the slicer for the players name bring up the corresponding picture for that player? 

 

Thank you 

Message 34 of 45
1,591 Views
DavidLanagan
Advocate IV
Advocate IV
In response to Drew248

โ€Ž08-03-2018 03:38 AM

Hi Drew248

 

In order to get the player pictures to work in that way I downloaded the pictures and saved locally. I then used a website to create an image url for each picture, the image url can then be added into a column within the table/dataset for each player.

 

In Power BI I think I used the table visual which lets you drag in the image url field as a value, I then added the chiclet slicer and filtered on the player name field from my dataset. I set the chiclet slicer properties to force the need for there always to be a player name selected and also only allow one option/player could be selected at a time.

 

I have attached an image that may be of use.

 

All the best,

David

Preview file
21 KB
Message 35 of 45
1,585 Views
Drew248
Frequent Visitor
In response to DavidLanagan

โ€Ž08-17-2018 12:46 PM

are you going to build one for the upcoming fantasy season ?

Message 36 of 45
1,530 Views
DavidLanagan
Advocate IV
Advocate IV
In response to Drew248

โ€Ž08-21-2018 04:50 AM

Hi Drew,

 

I haven't planned on making another comparison tool exactly like this, but I have been developing a new report based around NFL QBs past and present but I just havent had enough time to finish it off. Once I do finish it I will try to upload it.

 

Did my explanation help from the other week btw? Your question about the player images and filters...

 

David

Message 37 of 45
1,521 Views
0
kayamahmut
Regular Visitor
In response to DavidLanagan

โ€Ž05-17-2018 12:06 AM

Hi David,

 

Can you add a relevant description file as to how the report is prepared?

 

Thank you.

Message 33 of 45
1,666 Views
0
mikebf53
New Member

โ€Ž03-22-2018 11:52 AM

This is awesome and easy to follow.

Can you explain how you incorporated the data and the pictures into a report?

I'd like to learn how you did this.

Thanks

Message 31 of 45
1,618 Views
0
vlengure
Frequent Visitor

โ€Ž02-02-2018 10:21 AM

Hi David,

This is fantastic!  I am also starting to dig deeper into Power BI and wanna be able to reach a point where I can build something like this. Could you please help me with the steps. I would really appreciate it.

Thanks.

Best Regards,
Vivek L

Message 29 of 45
1,726 Views
DavidLanagan
Advocate IV
Advocate IV
In response to vlengure

โ€Ž02-13-2018 04:31 AM

Hi Vivek,

 

I put together a quick document with a guide on how I created some of the key parts of the report.

 

I will message you and get it sent over.

 

All the best,

David

Message 30 of 45
1,693 Views
0
Nikki3288
Frequent Visitor

โ€Ž01-05-2018 08:35 AM

Hi David,

 

This is a great visual! I work for a very large school district in California and am looking to do something like this for a tournament of technology that we hold every year. Would you mind sending me information on the tools you used? It would be much appreciated.

 

-Nicole

Message 26 of 45
1,808 Views
DavidLanagan
Advocate IV
Advocate IV
In response to Nikki3288

โ€Ž01-05-2018 09:27 AM

Hi Nicole, 

 

Yes I'd be happy to help out! I will message you with some information on how I put the report together. Was there anything you wanted to know specifically?

 

Kind regards,

David

Message 27 of 45
1,798 Views
Nikki3288
Frequent Visitor
In response to DavidLanagan

โ€Ž01-05-2018 10:53 AM

Well, just curious as to what specific visualizations you used. I know you mentioned that you got your data from NFL directly...did you just pull it in as an Excel source? Also, how were you able to get the player's pictures to link to their name? Thank you!

Message 28 of 45
1,791 Views
0