Data Insight: Beta testing of the Northern Ireland Annual Business Inquiry and Broad Economy Sales and Exports Statistics datasets, with a focus on spatial and sectoral analysis of Northern Ireland trade from 2014 to 2020
Categories: Research using linked data, Datasets, Research findings, Data Insights, ADR Northern Ireland, World of work
13 September 2023
Background
This project responds to an ESRC funding call to expand the use of the Business Data for Research (Northern Ireland) database by researchers, with particular focus on informing the Department for the Economy’s “10X Economy” vision. We present an exploration and review of newly available micro-business data, paying attention to its useability in evaluating Northern Irish trade.
We use the de-identified Northern Ireland Annual Business Inquiry, which is one of three datasets in the Business Data for Research (NI) database available as part of this funding call.
Until now, this data has been available on a restricted basis, but the intention is to expand its use to ADR UK researchers in approved safe settings.
Summary
This project was orientated around four research questions:
- Is the data provided by the Northern Ireland Statistics and Research Agency (NISRA) – namely, the Northern Ireland Annual Business Inquiry (NI ABI) and Broad Economy Sales and Exports Statistics (BESES) - useable for researching the performance and trading behaviour of Northern Ireland (NI) businesses?
- How has the relative performance and trading behaviour of business sectors in Northern Ireland changed over the period 2014–2020, with particular emphasis on the 10X priority clusters (see Background)?
- Are there sub-regional differences in the relative performance and trajectory of business sectors in Northern Ireland over the period 2014–2020, with particular emphasis on the 10X priority clusters?
- Is it possible to design a model for Northern Ireland trade distinct from the United Kingdom?
What we did
This project contributes to the beta testing of the Business Data for Research (NI) database by critically reviewing the quality and useability of the NI ABI and BESES datasets and providing feedback to inform future data collection and provision.
As a preliminary research exercise, we provide insights into the trading behaviour and economic performance of businesses identified as belonging to the 10X priority sectors relative to other businesses. We also examine whether geography, Brexit and Covid-19 impacted business trading behaviour and economic performance over the period 2014–2020.
What we found
Our review of the data and supporting materials highlighted several issues/limitations:
1. Coverage: Not all businesses are surveyed annually, with notable gaps in 10X coverage.
2. Reporting: It is not fully clear when data has been imputed or how weighting is applied; there are issues with zeroes and anomalies/errors that could be more effectively dealt with pre-publication; geographic consideration of the data is limited by reporting and confidentiality constraints; there are areas where the availability of supplementary data would be useful (e.g. trade by country destination, R&D); there is no delineation of 10X businesses.
3. Supporting materials: The available resources are not organised in a user-friendly manner. There is also a lack of clarity in the full data derivation process and how researchers should use the data.
Our preliminary analysis of the data, focusing especially on business performance and trade, showed:
1. The feasibility of a developing a 10X classification system – we were able to develop our own.
2. The ability to delineate and summarise indicators of trade and performance by sub-NI region, year and sector (including separate 10X sectors). See the figures that follow for a selection of examples.
3. The ability to econometrically analyse the determinants of business performance and trading behaviour and incorporating a Brexit comparison.
Our consideration of the possibility of developing a trade model for Northern Ireland highlighted:
1. The policy need given Northern Ireland’s unique trading position and the importance of external/export markets.
2. The prominence of gravity modelling in considering international trade and existing studies where it has been applied in local contexts (e.g. Gudgin et al., 2017; InterTradeIreland, 2018; Lawless et al. 2019; Keogh, 2019).
3. The plausibility of applying a gravity-type model to Northern Ireland.
4. Preliminary considerations for researchers such as the need for supplementary variables beyond BESES, the choice of estimation method, and the choice of firm, sector or country-level analysis.
Why it matters
Data-driven insights can be used by researchers to provide evidence and recommendations for policymaking. However, to effectively use such datasets, researchers require reliable, understandable and timely data provision. In this respect, our project has shown that there are a range of enhancements that could be made to the provision of the NI ABI and BESES datasets to improve their useability by the research community.
Our project also underscores the potential for better use of data to measure and assess the 10X economic vision. This can be achieved by including 10X identifiers in the datasets and by utilising a wide range of descriptive, inferential, and visual statistics. Our project provides some pointers to such outcomes.