A development map of water sports in Russia
An interactive analytics dashboard for the leadership of the Russian Water Sports Federation: from scattered Excel files to a single data-driven decision system.
Problem
Data on athletes, coaches, venues and results was stored across dozens of separate files and systems. Preparing a single analytics report took weeks of manual work. Leadership had no holistic view of the industry.
Solution
- Designed a relational DB (15+ tables, PostgreSQL) to unify all sources
- Geocoding — placed 3,600+ pools across Russia on an interactive map
- A composite index of regions from 124 absolute and 60 aggregated metrics
- Dashboard with regional rankings, heatmaps and filters
- Index system: infrastructure availability, staffing, participation
Result
Leadership got a decision-making tool: where infrastructure is overloaded, where it's underused, which regions are drivers. The ability to model the effect of investments.


