Developing data intelligence has been a core priority for the Data Science function at City & Guilds. While our ‘Coffee & Code’ sessions and technical workshops raise awareness of coding tools, we found that one‑off talks don’t always translate into sustained practice. To bridge this gap, we experimented with giving staff direct, hands‑on access to real data and structured challenges in a safe learning environment.

We built a lightweight internal learning platform in R Shiny connected to a dedicated PostgreSQL training database. Using the {shinyace} package, learners can write and run SQL queries directly in the browser and immediately view the results. Exercises progress from introductory topics (basic SELECT and filtering) through joins, aggregation, CTEs, and window functions. Answers are validated through result‑set comparison rather than text matching, supporting multiple correct solutions.

The platform also includes an integrated Markdown‑based learning guide, allowing users to switch seamlessly between reading and doing. This combination of structured explanation and interactive practice supports a full learning pathway—from complete beginner to confident SQL user.

To encourage regular engagement, users can create accounts, track their progress, and appear on a simple (optionally anonymous) leaderboard. This has resulted in consistent, self‑directed use across parts of the organisation, with learners returning daily to build their skills.

The outcome has been greater confidence in querying data directly, reduced reliance on intermediaries, and more informed conversations about reporting and analysis. By lowering the barrier to entry and making practice accessible, the platform has helped foster a broader culture of data intelligence across the business.