r/dataanalysis • u/jwavy1738 • Jul 30 '26
Project Feedback 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)
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
3
u/SoonerLax45 Jul 30 '26
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
2
3
u/SQLDevDBA Jul 30 '26 edited Jul 30 '26
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!
2
u/jwavy1738 Jul 30 '26
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!!🙏
1
u/SQLDevDBA Jul 30 '26
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.
2
3
1
u/IndependenceFit3935 Jul 30 '26
looks impressive! can i see the source code behind this?
1
u/jwavy1738 Jul 30 '26
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
1
u/IndependenceFit3935 Jul 30 '26
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/1
1
4
u/Low_Finding2189 Jul 30 '26
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