BIS Data Analysis: Identifying Barriers to Business Support

BIS Data analysis

Contents
INTRODUCTION...........................................................................................................................1
MAIN BODY..................................................................................................................................1
Analysis of BIS data for identifying particular pattern of barriers that prohibited people to use
business support...........................................................................................................................1
Highlights of some interesting findings.....................................................................................13
Recommendations as per highlighted areas that require more support.....................................14
CONCLUSION..............................................................................................................................14

INTRODUCTION
Data analysis in business refers to most important internal function of an organisation,
which is mainly performed to record, analyse and interpret information to make better decisions.
Through this process, a firm can take decisions as per consumer trends, behaviour predictions
and demand of innovation in business, to increase profitability. Along with this, it provides
opportunity to firms, for better targeting, check the product performance, match them with
customer preferences and more. A report is prepared by exploring the BIS data from business
innovation department, which is a ministerial authority and mainly work for promoting the trade
and business expansion, via providing a number of solutions to small firms. In this sense, data
after procurement from this division will properly analysed in order to identify barrier patterns,
that restrict individuals for usage of business report. For this purpose, whole process is made on a
particular region i.e. South East by comparing it with South west. After analysing, it will
communicate with Chief Research Analyst and provide some suggestions to them for being used
the data in further study. The data has been analysed by gaining an understanding regarding the
patterns of barriers which restricts people from using business support.
MAIN BODY
Analysis of BIS data for identifying particular pattern of barriers that prohibited people to use
business support
The data which is collected by the Department for Business Innovation and Skills (BIS)
has been collected by using primary sources, where number of questions have been asked to
various small organisations, for understanding the barriers that restrict them for further
innovation or expansion. To arrange and properly store the data, Microsoft Excel software has
been used as specific business intelligence tool. But as this data is collected on a large basis from
numerous employers of small company, therefore, it will create difficulties to analyse whole
information at same time. Therefore, some specific variables or questions have been taken to
identify the barriers behind not getting proper business support, with primary aim to compare
data of two main regions, that are South East and North West. A number of steps have been used
for analysing complete process as given below –
1

Filtration: It is first step which is mainly used for pre-processing of data analysis. For this
purpose, FILTER command of Excel, is used to collect desired data of both regions that lie from
3 to 6. After filtration of big data which is given in spreadsheet of “Q4 to 6” is then copied and
pasted into new spreadsheet for further analysis purposes.
Data transformation and reduction: It is another main step where for transforming data
which is collected by filtration process, Pivot table is utilised. This would help in selecting only
those variables which enables analyst to interpret specific information only.
Variables: The variables which are chosen from Variable and Value spreadsheets of big
data for determining the barriers include URBANRURAL_2 and REGION. Undertaking this
data, pivot table helps in representing the information in graphical form appropriately.
Thus, applying all above steps, help in gathering specific information and present them
statistically, in following way –
South East North West
0
20
40
60
80
100
120
140
160
180 166
121
56
28
Urban Rural
2