How mmrnayan/fpl-hub-v3 works
FPL-Hub is a Fantasy Premier League analytics pipeline whose main workflow collects API data, organizes season-tagged files, loads SQL staging tables, transforms them through silver and gold views, and presents a Power BI star-schema dashboard. The repository also includes player scoring and classification logic, plus DAX measures for dashboard KPIs and views. The README documents the broad pipeline and model; unsampled SQL, DAX, and orchestration details limit claims about their internal wiring.
Main entry points: data Season CSVs · test2.pbix FPL dashboard · gold views Gold star schema · files to runn API extraction
Components 17
Data collection
- API extraction
python/automation script/files to runn - Season CSVs
python/data
Player analytics
- Player scoring
python/automation script/files to runn/player_scores.py - Player classification
python/automation script/files to runn/assigning_classes.py
SQL warehouse
- SQL loading
python/automation script/files to runn/sql_table_upload_script.py - Bronze staging
sql - Silver views
sql/silver views - Gold star schema
sql/gold views - Player-gameweek fact
sql/gold views/fact table.sql - Model dimensions
sql/gold views - Fixture bridge
sql/gold views/fixture bridge.sql
Power BI reporting
- FPL dashboard
powerbi/test2.pbix - Overview KPIs
dax snippets/overview page measures - Player explorer
dax snippets/explore player measures/html.dax - Season comparisons
dax snippets/pre season prep measures
Other components
- FPL API
- Dashboard user
Connections 18
- FPL API → API extraction: provides API data
README.md - API extraction → Season CSVs: writes season files
README.md - Season CSVs → SQL loading: loads CSVs
README.md - SQL loading → Bronze staging: loads raw tables
README.md - Bronze staging → Silver views: feeds views
README.md - Silver views → Gold star schema: feeds views
README.md - Gold star schema → FPL dashboard: supplies model
README.md - Season CSVs → Player scoring: reads gameweek data
- Player scoring → Season CSVs: writes player scores
- Season CSVs → Player classification: reads gameweek data
- Player classification → Season CSVs: writes classifications
- Player-gameweek fact → Gold star schema: forms fact model
README.md - Model dimensions → Gold star schema: forms dimensional model
README.md - Fixture bridge → Model dimensions: links teams and fixtures
README.md - FPL dashboard → Overview KPIs: uses measures
- FPL dashboard → Player explorer: uses measures
- FPL dashboard → Season comparisons: uses measures
- Dashboard user → FPL dashboard: views reports
README.md