The greatest challenge on the Sport England project was the scale of the data Sport England have available to them, while enabling the user to create their own custom queries. Each Active Lives Adults survey dataset (e.g. November 15/16, November 16/17 etc.) contains around 180,000-200,000 individual responses. Each response included questions related to 193 different activities the person may have selected on the survey.
In Active Lives Online this data is able to be viewed as an aggregate grouped by:
- Year
- Activity (e.g. badminton, walking, water polo)
- Location (e.g. country, region, active partnership, local authority)
- Demographic (e.g. social status, gender, age)
- Measure (e.g. participation in the selected activities, volunteering, club membership)
Website Performance Enhancements
Website performance is key to a good user experience. In order to make the website fast, OCC implemented 2 key features.
- The website will store, in-memory on the server side, any query that has been run before. This means that if the same query is run twice, either by the same user or different users, the website will provide the results without requiring the query to be run again on the database.
- The production database has all the possible website results calculated in advance, because calculating results at run-time was too slow. Early on we calculated that there would be billions of possible results returned. Working with Sport England, we identified which results were required on the tool, and we were able to reduce this to only 65 million results per time period. We now have 7 time periods, and 455 million possible results.
Query Engine Implementation
This query engine was implemented in the precursor to Active Lives Online (Active People Interactive). Whilst the data set has changed multiple times and the website completely replaced, the engine was made in a way that it could be reused for each new data set, enabling OCC to react to Sport England’s changing requirements over the last decade, including expanding the scope of the Active People Interactive to include data from Public Health England in 2016.
Transition to Microsoft Azure
A key change for us over the last decade has been the emergence of Microsoft Azure as OCC’s preferred hosting platform. When we deployed Active Lives Online, we migrated our Sport England websites to Microsoft Azure. This has enabled OCC to continue monitoring the performance of the website and we can now increase its processing power to meet demand with no interruption to service.
The Benefits of Microsoft Azure Deployment
Moving to Azure has also allowed our development teams to deploy website updates automatically from Microsoft Azure DevOps. Furthermore, Azure provides us with “slots”, whereby OCC can deploy the next version to a test slot, have it reviewed for accuracy by Sport England, and then “swap” the slot with the public website. Both changes have increased our ability to test and release the website rapidly.
Through our iterative approach, UX design team, innovative developers, and dedicated testers, OCC have produced a series of websites for Sport England for more than a decade, allowing the public and organisations to explore Sport England’s survey data.
Next Steps
View our latest version for the Active Lives Adults Survey. You can try the tool our for yourself.
If you'd like to view more our our success stories, view our large collection of case studies. However, if you have any questions or enquires please contact us right away. We are here to support you.
