During Digital, Data and Technology (DDaT) week, 25-29 April, the Data Infrastructure team ran a ‘Data Workspace Challenge’ for all Department for International Trade (DIT) staff. Colleagues were encouraged to put forward ideas about how DIT could use data in new and creative ways to solve or fix problems. We shortlisted the best ideas to be brought to life, with the help of an assigned Data Analyst.
Encouraging the use of data
We opened the challenge to everyone in DIT, with the aims of:
- using DIT’s data in new and innovative ways
- improving processes and decision-making
- using data responsibly
We sought ideas that would improve the lives of those working at DIT or using our public services. We wanted to progress projects we could make tangible progress on in a week or would provide the foundations for wider delivery of DIT’s priority outcomes.
The reception from DIT colleagues was fantastic. Over 22 project proposals were submitted from 18 different teams from around the globe across four directorates.
Selecting our shortlist
We shortlisted 5 proposals to be developed in the Data Workspace Challenge and partnered each project with a data analyst from our team. This provided an opportunity for colleagues to collaborate with others outside of their teams. Participants outside the DDaT function were able to deepen their data capability and learn new skills through tailored assistance and support.
Some of the shortlisted projects included:
- bridging the gap between export and investment data by creating a single view of all export projects to provide evidence-based forecasts
- streamlining reporting on financial policy compliance through the development of top-level and detailed view dashboards
- tracking operational and performance metrics through the creation of a reference dataset for the department's Outcome Delivery Plan (ODP) priorities
- developing insight for global trade alert policy through a building a user-friendly R-Shiny dashboard
- finding, using and maintaining use of data to deliver the Diversity and Inclusion vision throughout the Investment Transformation Programme (ITP) campaign.
Karl Gunner, Chief Digital Officer: North America Trade and Investment, shared:
‘We loved working with DDaT. It was such fun and incredibly motivating to collaborate with Shan Zhang (Head of Business Analysis and Reporting, China Strategy Team) and Matt McKenzie (Data Analyst) across Beijing, London, and New York. We were able to produce a prototype for something that our Trade professionals and leadership have been seeking for a long time. We’re excited to show the potential for any region to see their export pipeline integrated with their wins and targets. This provides evidence-based forecasting for the very first time and will, we believe, lead to an increase in UK trade.’
Presenting and judging the finalists
Our Showcase and Awards ceremony was a hybrid event. It took place in Old Admiralty Building and virtually, with some colleagues dialling in from abroad! Each project was given the chance to present what they had worked on over the course of the week. Both audience members and the judging panel were then given the opportunity to ask questions and probe deeper into each project. Our judging panel composed of Sian Thomas, Chief Data Officer, Jane Naylor, Chief Statistician, and Martin Cook, Deputy Director: Export Programmes, who deliberated and selected a final winner.
The winning project
The winning project was led by Ralph Steeden, Governance Lead, and Tom Mockford, Contract Manager, supported by Leah Levy, Data Analyst. Their idea was to create a dashboard that would allow the Financial Governance team to provide various sets of data to Directors and Director Generals (DGs). Previously, the team had no data where they could identify spend per DG group on expenses and Government Procurement Card transactions.
The new dashboard allows them to track data across various years, filter down to director level, and conduct trend analysis on policy violations over time. This will save them substantial amounts of time and make it easier to identify non-compliant claims.
Tom Mockford, who worked on the project, said:
‘We can now ‘cross-check’ claims against pre-defined values, meaning that we are conducting more in-depth analysis which was simply not possible without this dashboard. We can also now create and give reports to seniors on their spend, enabling them to identify savings where appropriate”.
The Data Workspace Challenge was a fantastic showcase of the data-driven innovation possible through cross-collaboration between DDaT and other directorates. It allowed colleagues outside of DDaT to discover and explore data available on Data Workspace, improve their skills and build relationships across the department.
Seeking creative opportunities to drive value from data sources aligns with our new data strategy, which lays out our commitment to develop DIT culture, capability, and skills. DIT’s mission to use data to inform decision making is dependent on initiatives that champion ongoing learning across all roles and areas. We hope to make the Challenge an annual event, to continue using DIT’s data in new and inventive ways.