Skip to main content

https://digitaltrade.blog.gov.uk/2023/07/13/finding-innovative-solutions-through-the-dbt-data-challenge/

Finding innovative solutions through the DBT Data Challenge

 

3 people stood in front of a transparent wall covered with data graphs

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 

Shortlisting projects

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”.

Next steps

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. 

Sharing and comments

Share this page

1 comment

  1. Comment by Liz Catherall posted on

    What a fantastic way to demonstrate what we can collectively develop with data in DBT. Great showcasing! Digital Data and Technology teams also host a quarterly fire break week. For more on this you can check out the blog https://digitaltrade.blog.gov.uk/2021/05/26/small-projects-delivered-quickly-how-the-ddat-team-worked-to-deliver-dits-priorities-in-a-week/ or go to https://dbis.sharepoint.com/sites/DDaTPlaybook/SitePages/Firebreak.aspx