Using Data to Build Business

This report explores how businesses use data to develop strategies and make decisions. It compares data from two regions, South West and Yorkshire and Humber, to analyze the differences. The report also examines how businesses in each region are growing and facing challenges.

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
Total
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
Total
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
Total
1 2 3 5
2 1 1
4 101 77 178
4

(blank)
Grand Total 103 81 184
Interpretation- From table it can be interpreted that in south west region 2 said yes very
significant other concerns in business since established over 3 years and 101 said there were no
other concerns in it. but on other hand, in Yorkshire and humber region 3 said yes very
significant, 1 said fairly significant and 77 said no other concern. It means that in humber region
there are other concern as well for business since last 3 years as compared to SW region. Due to
that it has been resulted in decease in business as they are not able to sustain. Besides that, it is
difficult for business in humber region to solve concern. There are various concerns faced by
business in that region.
Q2-2H Can I check whether Sales and Marketing has been an issue in the past 12 months?
Count of
Q2_2H Column Labels
Row Labels 2 7 (blank)
Grand
Total
1 72 71 2 145
2 23 14 37
(blank)
Grand Total 95 85 2 182
Interpretation - It is analysed from table that in south west region 72 said yes sales and
marketing is issue since past 12 months and 23 said no. On contrary in Yorkshire and humber
region 71 said yes for this statement and 14 said no. thus, it can be evaluated that in both region
marketing and sales is issue for business. They are not able to generate sales and also do
effective marketing. In addition, businesses are not able to generate revenue as sales is declining.
Furthermore, marketing is not done in attractive way so people are not getting attracted. It has
become difficult for business to retain customers for long time. thus, this condition is same in
both regions and it has affected on growth and development of business (Radovilsky, and Uma,
2018).
Q4- 3A-1 What extent business has no need external info or advice or describe why you did not
seek advice or info
5

Count of
Q4_3A_1 Column Labels
Row Labels 2 7
Grand
Total
1 3 4 7
2 5 6 11
3 7 1 8
(blank)
Grand Total 15 11 26
Interpretation- It can be evaluated from above table that in south west region 3 said yes
definitely describe, 5 said yes describe to some extent that business has no need external info or
advice and 7 said no does not describe. However, in Yorkshire and humber region 4 said yes
definitely describe, 6 said describe to some extent and 1 said no does not describe. Thus, in both
regions busines does not need external info or advice. The stakeholders are not identified and
info is taken from them. Hence no advice is taken from them. The owner did not give any reason
regarding it that why they did not seek advice. This trend is slightly more in humber as compared
to SW region.
Q5_2B In what ways were you aiming to grow the business?: Profits
Count of
Q5_2B Column Labels
Row Labels 2 7
Grand
Total
1 42 36 78
(blank)
Grand Total 42 36 78
6

Interpretation- by interpreting table it can be evaluated that in south west region 42 said that
they were aiming to grow business through profits. In Yorkshire and humber region 36 said they
want to grow it with profits. So, it can be identified that in SW region there were many
businesses which were aiming to grow it with profits as compared to humber region. This is
because of in SW region there are more opportunity to grow and expand. Also, there are many
micro and small business that has grown by generating more profits.
Q5- C In what ways were you aiming to grow the business?: Market share
Count of
Q5_2C Column Labels
Row Labels 2 7
Grand
Total
1 20 13 33
(blank)
Grand Total 20 13 33
Interpretation – by interpreting table it can be evaluated that in south west region 20 said they
aim to grow business via market share. However, in humber region 13 said they aim to grow
with markets share. So, here as well in south west region there are more growth opportunities in
market by which business is able to expand. They can grab those and expand it easily in market
which will led to gain market share and grow. Besides that, in humber region business is not able
to grow as market opportunity are less (Santoro and Ciampi, 2019).
Q5.2. A In what ways were you aiming to grow the business?: Output/ sales turnover
Count of
Q5_2A Column Labels
Row Labels 2 7
Grand
Total
1 43 27 70
(blank)
Grand Total 43 27 70
7

Interpretation- It can be stated from table that in SW region 43 said they aim to grow busines
via sales or turnover. In humber region 27 said they want to grow with sales. Thus, in SW region
business can grow with sales. With this issues related to sales and marketing can be solved as
well. The micro and small business can increase sales and expand in market. It can generate
more revenue in that region.
Q5.2.E In what ways were you aiming to grow the business?: Merger/ Acquisition
Count of
Q5_2E Column Labels
Row Labels 2 7
Grand
Total
1 4 4 8
(blank)
Grand Total 4 4 8
Interpretation- by interpreting data it is stated that in SW region 4 said they aim to grow
business with merger or acquisition. Likewise, in humber region as well 4 people said same
thing. So, in both region merger is not effective option for business growth. It is because there
are not many businesses which are running successfully and each one want to grow
independently. Along with that, small and micro business are not capable of acquiring other
ones. Hence, in both regions this option to grow does not work.
Q5.9. How many people do you expect the business to employ in twelve months’ time, excluding owners
and partners?
Count of
Q5_10 Column Labels
Row Labels 2 7 (blank)
Grand
Total
1 59 43 365 467
2 53 37 357 447
3 16 21 110 147
4 12 13 117 142
Grand Total 140 114 949 1203
8

Interpretation- It can be stated from table that south west region 59 said they will employ more
than currently partners and owners in 12 months. 53 said number will be same 16 said fewer and
12 said don’t know. On other hand, in humber region 43 said more than current partner will be
employed in next 12 months. 37 said same 21 said few and 13 said don’t’ known. Hence, it is
said that in SW region there will be more people employed in 12 months in business as
compared to humber region. There is more employment in SW region than other one. Besides
that, with more small and micro business establishing in that region more employment will be
generated (Bagehorn and Qureshi, 2016).
Q6.5. Is more than 50 per cent of the business owned by women?
Count of
Q6_5 Column Labels
Row Labels 2 7 (blank)
Grand
Total
1 37 26 177 240
2 99 84 748 931
3 4 4 24 32
Grand Total 140 114 949 1203
Interpretation- it can be interpreted from data that in south west region 37 said yes 50%
business are owned by women, 99 said no and 4 were not aware about it. Similarly, in Yorkshire
and humber region 26 said yes, 84 said no and 4 were don’t know. It can be stated that in both
regions people do not know that more than 50% women own business. but in south west people
said yes that they know women are owner of business. They are more aware about it as women
are successfully running business. Thee is lack of awareness in them regarding women
ownership.
By analysing the data of both regions that is south west and humber it can be evaluated
that in South west region there are more micro and small business that employ 1-4, 20-40
employees as compared to Humber region (Sun, Strang, and Firmin, 2017). As there are many
9

businesses so this region is more developed. There is high potential of growth and expansion in
SW region. The micro and small are operating and running in this region. Also, owner of these
business is mostly women. Along with 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.
It is because there are less sales and marketing and this is issue since past 1 year. The businesses
are not able to do high sales and it has impacted on their growth and expansion. Due to this the
issue is being faced by them in SW region more than other one. In addition, in SW region there
were many businesses which were aiming to grow it with profits as well as market share as
compared to humber one. This region is more developed than humber one. However, SW is
ahead of Yorkshire in many ways. In addition, with sales business can easily grow and develop
in both regions. But merger option is not suitable in it as business are not capable of acquiring
others due to lack of resources and funds available. In terms of more number of small business
SW region is ahead of humber. In SW region there is more employment as business want to
employ more or same number of people. Also, as there are more micro and small business in SW
region as well. In both regions people does not know that women are owner of firms. Hence, SW
region is more developed than humber one (Wazurkar, Bhadoria, and Bajpai, 2017). Many
firms are operating there and generating revenue. Due to this reason more owner wants to
establish organization there. The existing company in both regions can grow by gaining market
share, sales, etc. this is because they provide varied products. In humber region owner does not
seek external advice. There is change in things as well. But in SW region owner seek advice but
not to that extent. The difference between both of them is not high.
CONCLUSION
It can be concluded from above report that there are 2 regions which is being compared from
data that is humber and SW. From that it is found that in SW more small and micro business
exists. The common issues faced by them in these regions is sales and marketing. this has highly
impacted on their growth and development. The firms are focusing on growth with aim of profit,
market share and sales. They do not want to grow through merger due to lack of funds and
resources and they are not capable as well. Organisation want to employ more or same number
of people in it. Moreover, people do not know that women are also owner of business in both
regions.
10

REFERENCES
Books and journals
Bagehorn, F. and Qureshi, A., 2016 International Business Machines Corp, 2017. User driven
business data aggregation and cross mapping framework. U.S. Patent 9,720,958.
Balachandran, B.M. and Prasad, S., 2017. Challenges and benefits of deploying big data
analytics in the cloud for business intelligence. Procedia Computer Science, 112,
pp.1112-1122.
García, D.L., Nebot, À. and Vellido, A., 2017. Intelligent data analysis approaches to churn as a
business problem: a survey. Knowledge and Information Systems, 51(3), pp.719-774.
Lokshina, I.V., Durkin, B.J. and Lanting, C.J., 2017. Data analysis services related to the IoT and
big data: strategic implications and business opportunities for third parties. International
Journal of Interdisciplinary Telecommunications and Networking (IJITN), 9(2), pp.37-
56.
Radovilsky, Z. and Uma, U., 2018. Skills requirements of business data analytics and data
science jobs: A comparative analysis. Journal of Supply Chain and Operations
Management, 16(1), p.82.
Santoro, G. and Ciampi, F., 2019. Big data for business management in the retail
industry. Management Decision.
Sun, Z., Strang, K. and Firmin, S., 2017. Business analytics-based enterprise information
systems. Journal of Computer Information Systems, 57(2), pp.169-178.
Wazurkar, P., Bhadoria, R.S. and Bajpai, D., 2017, November. Predictive analytics in data
science for business intelligence solutions. In 2017 7th International Conference on
Communication Systems and Network Technologies (CSNT) (pp. 367-370). IEEE.
11