How jnyambok/my-strava-running-stats works
This project turns a periodic Strava export into a public running-stats dashboard: Python reads activity and GPS data into BigQuery, dbt models it into analytics, Python exports dashboard data, and the static site presents it. The graph preserves the documented metric branches. Source excerpts show the Python extraction, loading, and export calls; dbt model contents and dashboard wiring were not sampled, so those relationships are shown only where the README documents them or are left unlinked.
Main entry points: export_data.py Mart exporter · fct_runs.sql Run facts · tracks.py GPS track reader · activities.py Activity reader
Components 17
Extract and load
- Activity reader
extract/activities.py - GPS track reader
extract/tracks.py - Raw table loader
extract/load.py - BigQuery raw tables
dbt analytics
- Activity staging
strava_dbt/models/staging/stg_strava__activities.sql - Track-point staging
strava_dbt/models/staging/stg_strava__track_points.sql - Track distances
strava_dbt/models/intermediate/int_track_point_distances.sql - Run facts
strava_dbt/models/marts/fct_runs.sql - Weekly runs
strava_dbt/models/marts/fct_weekly_runs.sql - Running totals
strava_dbt/models/marts/fct_running_totals.sql - Best efforts
strava_dbt/models/marts/fct_best_efforts.sql - Daily fitness
strava_dbt/models/marts/fct_daily_fitness.sql - Monthly pace
strava_dbt/models/marts/fct_monthly_pace.sql
Dashboard publishing
- Mart exporter
export/export_data.py - Dashboard JSON
docs/data.json - Public dashboard
docs/index.html
External data
- Strava export
Connections 23
- Strava export → Activity reader: provides archive
README.md - Strava export → GPS track reader: provides archive
README.md - Activity reader → Raw table loader: returns activities
extract/load.py - GPS track reader → Raw table loader: returns track points
extract/load.py - GPS track reader → Activity reader: reads activity map
extract/tracks.py - Raw table loader → BigQuery raw tables: replaces raw tables
extract/load.py - BigQuery raw tables → Activity staging: stages activity rows
README.md - BigQuery raw tables → Track-point staging: stages track points
README.md - Track-point staging → Track distances: derives distances
- Activity staging → Run facts: models run facts
README.md - Track distances → Best efforts: supports efforts
README.md - Run facts → Weekly runs: aggregates weekly
- Run facts → Running totals: aggregates totals
- Run facts → Daily fitness: models training load
README.md - Run facts → Monthly pace: aggregates monthly pace
- Mart exporter → Running totals: queries totals
export/export_data.py - Mart exporter → Run facts: queries runs
export/export_data.py - Mart exporter → Weekly runs: queries weekly data
export/export_data.py - Mart exporter → Daily fitness: queries fitness
export/export_data.py - Mart exporter → Monthly pace: queries pace
export/export_data.py - Mart exporter → Best efforts: queries best efforts
export/export_data.py - Mart exporter → Dashboard JSON: writes JSON
export/export_data.py - Dashboard JSON → Public dashboard: feeds dashboard
README.md