NFL Fantasy Football Player Comparison Tool 01-05-2018 09:22 AM

[DavidLanagan]

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

[mikebf53]

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

[vlengure]

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

[DavidLanagan]

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

[Nikki3288]

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

[DavidLanagan]

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

[Nikki3288]

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!

[thomdargent]

Hi David,

That is a really nice report!

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

[DavidLanagan]

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.

[manjeetsingh094]

HI David,

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

Thank you,

Manjeet

[renzojrb]

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?

[DavidLanagan]

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

[manjeetsingh094]

Hi,

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

Thank you,

Manjeet

[DavidLanagan]

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?

[ericali197]

Hi David, 

I am also working on a comparison chart lately. Your work looks fantastic in comparing two products! However I am very new to PBI, it would be nice if you can share your pbix file with me too!

Best,

Erica

[DavidLanagan]

Hi Erica,

The pbix file has been added to the chat below.

Any questions just let me know.

David.

[ericali197]

Hi David, thank you so much for sharing your file! I've learned a lot from your great visuals 🙂

[Anonymous]

Hey, could you please share the file.

Thanks

[ericali197]

Hi David, 

I am also working on a comparison chart. Your PBI looks fantastic! It would be nice if you can share the pbix file with me too! 🙂

Best, 

Erica

[trindades]

Hi David!

Im Brazlian. Your report is amazing.

Can you send me .pbix file?

Thanks in advance

[DavidLanagan]

pbix file has been added in chat.

All the best,

David

[trindades]

Hi David!

im brazilian. I like a lot your report. It is awesome. Can you send me .pbix file?

Thanks in advance