The Data Infrastructure team hosted a Data Challenge during the Digital, Data and Technology (DDaT) week for all Department for Business and Trade (DBT) staff. Colleagues had the opportunity to propose project ideas about how DBT could use data in new and creative ways to solve problems.
The Data Infrastructure team manage DBT’s data catalogue and asset register. They are also responsible for Data Workspace which is DBT’s central reporting and analysis platform. It allows the department to effectively track and measure its activity related to the businesses it helps.
DDaT Week was a packed schedule of online, in-person and hybrid events and networking opportunities during the last week of April. It highlighted new ways for DDaT and DBT to collaborate across offices, regions and overseas. Sessions included exhibitions of DDaT's products and services, interactive workshops and the all-staff DBT Data Challenge which all teams were encouraged to take part in.
The DBT Data Challenge aimed to:
- use DBT’s data in new and innovative ways
- make DBT a better place to work
- improve processes and decision-making
- use data responsibly
The DBT Data Challenge attracted over 30 project proposals from across the department including from international colleagues. We had 7 project ideas shortlisted with participants engaging from Belfast and Cardiff.
Some of our shortlisted projects included:
- Producing sentiment analysis and topic modelling using social media data
- Understanding DBT estate locations using a comprehensive heatmap considering Machinery of Government (MOG) changes
- Building a Financial Vulnerability Dashboard in R Shiny using Experian Data
- Developing a comprehensive understanding on analysis into trade barriers
Participants from outside DDaT could develop their project ideas over the course of the week supported by a colleague from the DDaT Data team. They had the opportunity to produce meaningful analysis using data available on Data Workspace or sourced from elsewhere. At the end of the week, participants presented their analysis at our Showcase and Awards ceremony.
Presenting and judging the finalists
The ceremony was a hybrid event which took place in the Old Admiralty Building and virtually. Reception to the event was fantastic. We had over 140 colleagues from across the department dialling in or attending in person.
Each team presented the projects that they had been working on during the week. Audience members and our judging panel were then able to follow up with questions about each project. We had an oversubscribed judging panel which included: Sian Thomas (Chief Data Officer), Jane Naylor (Chief Statistician), Anthony Morris (Deputy Director - Analysis and Wages) and Martin Cook (Deputy Director - Export Design).
The winning project
After much deliberation, our judging panel announced Nick Avis, Jack O’Callaghan and Agnes Coaker were the chosen winners. Their project built a comprehensive and interactive Financial Vulnerability dashboard using data available from the credit reporting company, Experian. The dashboard was developed in a package called R Shiny that can build web-based applications. This meant it could be visualised using maps and tables which users could view and download.
Nick and Jack said “The Experian dashboard project has great potential to allow us to share high-level insights more rapidly across the department. It also eases the number of resources required for simpler and more regular analytical requests”.
The DBT Data Challenge was a fantastic opportunity to showcase data-driven innovation and cross-collaboration across DBT. It was particularly exciting, especially considering the MOG changes happening. We’re already looking forward to hosting the DBT Data Challenge next year.
Ready to join the team? Check out our latest DDaT jobs on Jobvite.