topic Re: NFL Fantasy Football Player Comparison Tool in Data Stories Gallery

NFL Fantasy Football Player Comparison Tool

DavidLanagan — Wed, 30 Aug 2017 01:04:07 GMT

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

eyJrIjoiMmEzOGFiNmYtZTRlMC00NWEyLTk2M2YtM2VlZmVmODhiZjI2IiwidCI6ImZkMGFhMzU2LWE0NTMtNDYzNS05NGI3LTdhOTRjMjcyNWNiOCIsImMiOjh9

Re: NFL Fantasy Football Player Comparison Tool

alexhambam — Wed, 30 Aug 2017 01:28:31 GMT

Wow, this is awesome! I used to subscribe to a website that calculated PPR weekly projections and imagined they made a lot of revenue as they charged a monthly access token.

Re: NFL Fantasy Football Player Comparison Tool

DavidLanagan — Wed, 30 Aug 2017 19:39:08 GMT

Hi Alex, thanks for the comment! Glad you liked the report!

Re: NFL Fantasy Football Player Comparison Tool

AlexGriffin — Sun, 03 Sep 2017 14:41:08 GMT

Good report - Nice design layout and good use of the player images etc and it's interesting being able to filter your own projection, not seen that before. Nice Job.

Re: NFL Fantasy Football Player Comparison Tool

DavidLanagan — Sun, 03 Sep 2017 20:17:59 GMT

Thanks Alex. Glad you liked the report!

Re: NFL Fantasy Football Player Comparison Tool

manjeetsingh094 — Tue, 05 Dec 2017 06:00:11 GMT

Hi,

I am working on a comparison tool but don't know where to start. Can you please guide me?

Thank you,

Manjeet

Re: NFL Fantasy Football Player Comparison Tool

DavidLanagan — Thu, 07 Dec 2017 11:07:17 GMT

Hi Manjeet, I will message you the steps I used to create the report. I can send you the .pbix file also if that helps?

Re: NFL Fantasy Football Player Comparison Tool

manjeetsingh094 — Fri, 08 Dec 2017 04:53:54 GMT

HI David.

Greetings. Thank you so much. It will be a great help. Please tell me the steps and send me PBIX file if that's okay with you.

Thank you,

Manjeet

Re: NFL Fantasy Football Player Comparison Tool

renzojrb — Mon, 18 Dec 2017 22:15:33 GMT

Hi David, it´s a good report. I would like to know how you made it.

Specially that filter with player´s photos. Can you help me please?

Re: NFL Fantasy Football Player Comparison Tool

thomdargent — Tue, 19 Dec 2017 08:41:52 GMT

Hi David,

That is a really nice report!

Would you have such a report for the Football Premier League in the UK?

Re: NFL Fantasy Football Player Comparison Tool

Nikki3288 — Fri, 05 Jan 2018 16:35:13 GMT

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

Re: NFL Fantasy Football Player Comparison Tool

DavidLanagan — Fri, 05 Jan 2018 17:22:19 GMT

Thanks for the comment! No I haven't got a football Premier League version currently but could look to do this in the future using a similar layout.

Re: NFL Fantasy Football Player Comparison Tool

DavidLanagan — Fri, 05 Jan 2018 17:27:17 GMT

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

Re: NFL Fantasy Football Player Comparison Tool

DavidLanagan — Fri, 05 Jan 2018 17:31:41 GMT

Hi renzojrb

Apologies for the late reply! I have been away recently. Let me know if you was still wanting any information and I will be happy to message you with what you need.

Kind regards,

David

Re: NFL Fantasy Football Player Comparison Tool

Nikki3288 — Fri, 05 Jan 2018 18:53:39 GMT

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!

Re: NFL Fantasy Football Player Comparison Tool

vlengure — Fri, 02 Feb 2018 18:21:06 GMT

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

Re: NFL Fantasy Football Player Comparison Tool

DavidLanagan — Tue, 13 Feb 2018 12:31:57 GMT

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

Re: NFL Fantasy Football Player Comparison Tool

mikebf53 — Thu, 22 Mar 2018 18:52:05 GMT

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

Re: NFL Fantasy Football Player Comparison Tool

manjeetsingh094 — Fri, 23 Mar 2018 05:02:34 GMT

HI David,

I am still waiting for the steps you told me you gonna send. Can you please send.

Thank you,

Manjeet

Re: NFL Fantasy Football Player Comparison Tool

manjeetsingh094 — Fri, 23 Mar 2018 05:04:05 GMT

Hi David,

I am still waiting for the steps. And please send me the .pbix file as well.

Thank you,

Manjeet