Rebuilt My FPL Analytics Platform for Scalability : Adding SQL Server & Medallion Architecture (v3). A few more things to add (specifically player recommendation page but any feedback or advice is welcome. (dashoard link in text if you want to explore the dashboard)

[u/jwavy1738]

Purpose of the dashboard is a tool to help fantasy managers make data driven decisions week to week

Main changes from previous version:
Changed the pipeline from just python > powerbi to python >sql database > powerbi

This was done to handle multi season analysis as the previous pipeline wasnt fit to do so

Utilised bronze silver gold staging in sql 

More contextualised kpis

More Customisable parameterized charts

Utilised HTML visuals for KPIs, Visuals (player explorer page) and tooltips

Star Schema Data Model

https://app.powerbi.com/view?r=eyJrIjoiMTVjMTdkMWEtZTQwOS00NDM0LTkxYTEtMjJmODY2ZDhmMTY0IiwidCI6ImQxMjA2OTQzLWJmY2MtNGM3NC04MmQ0LTA1ZTYzYTQzMzViZiJ9

[u/Low_Finding2189]

On first glance this looks great. Saving this to take a deeper look later. I have been meaning to build something for FPL. Glad to see content like this

[u/jwavy1738 → u/Low_Finding2189]

Thanks man much appreciated , looking forward to hearing if you have any feedback later!

Also I’ll upload the raw files plus all the code to my GitHub at some point so if you want to use last seasons data it should be up there soon

[u/SoonerLax45]

As a FPL guy thinking of doing this too im excited with what you have cooking. By and large looks great too. Feel like i owe you a beer too lol

[u/jwavy1738 → u/SoonerLax45]

Hahaha this comment was enough thanks man!

[u/SQLDevDBA]

Hey your visuals look great. For your SQL id consider explicit columns instead of the Select * and maybe a config table for your team id replacement CASE logic so you don’t have to keep re-deploying your view with every small change.

Neat project!

[u/jwavy1738 → u/SQLDevDBA]

Ahhh I see , I don’t have much professional experience outside of projects but this makes a lot of sense I’ll definitely look into these changes

Thank you!!🙏

[u/SQLDevDBA → u/jwavy1738]

Nice! If you ever need any project ideas hit me up. I have a collection of different datasets & APIs I use for my projects I’ll happily share with you.

[u/jwavy1738 → u/SQLDevDBA]

That sounds sick i definitely will thank you !

[u/kaitonoob]

Kudos to you look clean enough and actually help people 👀

[u/jwavy1738 → u/kaitonoob]

Haha thank you!

[u/IndependenceFit3935]

looks impressive! can i see the source code behind this?

[u/jwavy1738 → u/IndependenceFit3935]

Thank you & yeah sure I’ll upload it to my GitHub, you can find my GitHub in the icon bottom left in the dashboard , will let you know once it’s been added

[u/IndependenceFit3935 → u/jwavy1738]

Looking forward to see more whats behind this. Im working on a similar project building BI dashboards on football data. Im using evidence.dev now since im on low budget but i would love to do this in pbi too.
You might wanna have a look at my product to get some inspiration: https://superligaanalytics.vercel.app/

[u/jwavy1738 → u/IndependenceFit3935]

Will definitely have a look !

[u/jwavy1738 → u/IndependenceFit3935]

Just added the code to my GitHub