Using Data to Build Business

Using Data to Build Business
Practice
1

Table of Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
CONCLUSION..............................................................................................................................10
REFERENCES..............................................................................................................................12
2

INTRODUCTION
In present times, businesses are using various tools and techniques to analyse data. So, data
and info is needed to develop strategies and take relevant decision. The use of tools and
techniques depends on type of data. However, pivot tables are one in which data is segregated
and then evaluated (Balachandran, and Prasad, 2017). The analysis of data gives insight on
future predictions. Similarly, this report will compare data of two regions that is South west and
Yorkshire and Humber. For that different questions will be taken to compare data on both of
them. Furthermore, comparison will be done to in find out how both regions differ from each
other and in what way.
MAIN BODY
Here, data of many people has been taken who are owner of business that operate in various
regions. But in these two regions is to be compared with help of question which is of high
interest and related to it (García, Nebot, and Vellido, 2017). The analysis of data enables in
giving insight about what current trend is so on decision are taken accordingly. Along with it, the
use of technique makes it easy to interpret data by obtaining outcomes. Thus, question to be
analysed in it are defined as
Q-1-2B How many employees does your business currently employ across all sites in the UK, excluding
owners and partners?
Count of
Q1_2B Column Labels
Row Labels 2 7
Grand To-
tal
2 65 49 114
3 25 20 45
4 21 16 37
5 12 16 28
6 17 13 30
Grand Total 140 114 254
Interpretation- It can be analysed from above table that in South west region 65 were micro
business, 25 has 5-9 employees, 21 has 10-19 and 12 has 20-49 employees. Only 17 were
having more than 50 staff. However, in humber region 59 were 1-4 staff, 20 were 5-9 staff and
16 were small business and 13 were having more than 50 employees. Therefore, it can be stated
3

that in South west region there are more micro and small business that employ 1-4, 20-40
employees as compared to Humber region. Hence, SW region is more developed and there are
many businesses in it. This has enabled in generating more employment. Also, having more
business means more revenue and development.
Q2-2A Can I check whether surviving has been an issue in the past 12 months?
Count of
Q2_2A Column Labels
Row Labels 2 7
Grand To-
tal
1 71 56 127
2 32 25 57
(blank)
Grand Total 103 81 184
Interpretation- By analysing table it can be stated that in south west region 71 said yes
surviving has been issue in past 12 months whereas 32 said no. But on contrary in Yorkshire and
humber region 56 said yes for this and 25 said no. It means that in SW region business are facing
more issues in order to remain sustain in market since past 1 year as compared to Yorkshire and
humber region. Due to that there is decrease in new micro and small business. In humber area
business are facing issue but to that extent. The business in this area is able to survive for long
term as compared to SW region. They are able to solve issue with help of effective strategies
(Lokshina, Durkin and Lanting, 2017).
Q-2-1L
Q2_1L Have there been any other concerns for your business since established over the last 3 years?
Count of
Q2_1L Column Labels
Row Labels 2 7
Grand To-
tal
1 2 3 5
2 1 1
4 101 77 178
4