using data to build business practice

USING DATA TO BUILD
BUSINESS PRACTICE

TABLE OF CONTENTS
Pivot table formulation and analysis for the South East Region.................................................3
Question 4..................................................................................................................................12
Question5..................................................................................................................................13
Question 6..................................................................................................................................15
REFERENCES..............................................................................................................................17

Pivot table formulation and analysis for the South East Region
Question 4
Q4_3A_2
Row Labels
Count of
Q4_3A_2
Percentage
Yes, definitely describes 11 55%
Yes, describes to some
extent 5 25%
No, does not describe 4 20%
(blank)
Grand Total 20
Interpretation: The question basically addresses the efficiency and reliability of the internal
resources that were available in the company and the manner in which they can be utilised
sufficiently to complete the different organisational functions. The chart above clearly depicts
that the majority of the respondent in the South East region stated that they had adequately
availability of the internal resources and this was the basic reason why they did not took
assistance from the external business resources (Ransbotham and et.al., 2017). It was
additionally concluded that there were 25% of respondents who agreed that this was true but
only to an extent i.e. the availability internal resources was only a part of reason why the
businesses are not taking external support. There were 20% who said that this is not the exact
3

reason and none of them said that they were not aware of the reason why they did not seek help
from external sources.
Q4_3A_7
Row Labels
Count of
Q4_3A_7
Percentage
Yes, definitely describes 6 30%
Yes, describes to some
extent 6 30%
No, does not describe 8 40%
(blank)
Grand Total 20
Interpretation: The chart above depicts that the total number of respondent in the south east
region who agreed that the reason that they did not seek external advice was not due to the
unavailability of adequate time constitute the major ratio of 40%. However, almost equivalent
percentage of respondents i.e. 30% and 30% agreed that the lack of time was the major resins for
them to not seek the external services and another 30% agreed that the lack of time was a reason
but only to an extent i.e. they did not completely assume that this was the sole reason (Grover
and et.al., 2018).
Q4_3A_12
4

Row Labels
Count of
Q4_3A_12
Percentage
No other reasons 20 100%
(blank)
Grand Total 20
1; No other
reasons; 20
No other reasons
No other reasons
Interpretation: The chart above clearly depicts that the complete population i.e. all 20 of the
respondents who were selected for the purpose of research agreed that the reasons that have been
accumulated and analysed in the research above. There were no remaining reasons for
incorporating any more factors. The respondents form the south east region found that the
reasons that have been included are adequate and multi faceted addressing all the potential
aspects that can occur in a research (Ghauri, Grønhaug and Strange, 2020). Therefore this chart
shows that the research undertaken was extremely comprehensive and ensured that all the
possible factors are taken under purview of analysis while conducting the research.
Question 5
Q5_2B
Row Labels Count of Q5_2B Percentage
Profits 66 100%
(blank)
Grand Total 66
5

1; Profits; 66; 100%
Profits
1
Interpretation: The entire population of south east region represented by their respondents
agrees that the decision of growing their business and further expanding on it is related to the
profits that their business is earning. 100% of the respondents i.e. all 66 of them agreed that
profits was the major objective that they had behind the development and overall growth of the
business (Kowalkowski, Gebauer and Oliva, 2017). It was further stated that this is a justifiable
graph as it shows that the profit is the very reasons with which every business operates and hence
it is necessary to incorporate this factors as a major factor behind growth of business.
Q5_2C
Row Labels
Count of
Q5_2C
Percentage
Market Share 23 100%
(blank)
Grand Total 23
6

1; Market Share;
23
Market Share
Market Share
Interpretation: The chart above again depicts the 100% agreeableness that exists amongst the
respondents of the south east region where all of them collectively stated that the market share is
the major reason or measures on the basis of which they think about expansions and growth of
the business collectively (Akcigit and Kerr, 2018). This helps in ascertaining that the majority of
the respondents of the south east region find that the best way to decide the growth and
expansion of the business and take decisions accordingly is by evaluating the market share that
the company has been able to capture in their company.
Q5_2G
Row Labels
Count of
Q5_2G
Percentage
Diversify / new
products / range /
services 1
100%
(blank)
Grand Total 1
7

Interpretation: In the pie chart above, it can be ascertained that all the respondents of the south
east region have responded that the sole basis which they consider before taking the growth
decisions of the business is based on the diversifications that the company have entered into, the
new products that have been launched by the company, the wider or limited range of products
that they are selling and the services that are provided by them (Löfsten, 2016). The
organisations analyse the further potential for growth using these indicators and then collectively
takes the decision related to it. This helps in formulating growth strategies on reasonable and
practical ground.
Q5_2I
Row Labels Count of Q5_2I Percentage
(blank) 0%
Grand Total
Interpretation: Since there was no data available regarding the respondents who were include in
the research, no significant interpretation can be made regarding the viability of growth as a
factor. Therefore, there was nil number i.e. not a single respondents who thought that the growth
of the business is a relevant feature that can be used for the purpose of taking decisions related to
the growth and expansion of the business (Lee and Shin, 2018).
Question 6
Q6_3
8

Row Labels
Count of
Q6_3
Percentage
1 70 32%
2 102 46%
3 26 12%
4 10 5%
5 4 2%
6 2 1%
15 1 0%
997 7 3%
Grand Total 222
Interpretation: The south east region respondents were asked that what the maximum number of
partners that they think is should be kept in an organisation in order to develop better
organisation and management (Tejedo-Romero, Rodrigues and Craig, 2017). Most of the
respondents said that the maximum limit of directors should be 2 followed by people voting for 1
director and the least chosen number was 15 as number of directors where almost 0% of
respondents i.e. just 2 out of 222 stated that this should be the selected number.
Q6_4
Row Labels Count of Q6_4 Percentage
0 103 46%
9

1 102 46%
2 8 4%
3 3 1%
997 6 3%
Grand Total 222
1; Series1; 1032; Series1; 102
3; Series1; 84; Series1; 35; Series1; 6
Series1
Interpretation: When the respondents selected for the south east region were questioned that
what according to them is the maximum number of women partners that they would employ in
their organisation, majority of them i.e. 103 out of total 222 respondents said that they would
select only 1womn partner (Byron. and Post, 2016). This was however closely followed by the
102 respondents who said they would prefer 2 women partners in their business and lastly, there
were only 3 out of 222 respondents who said that 4 number of women partner is the optimum
number.
Q6_5
Row Labels
Count of
Q6_5
Percentage
Yes 50 23%
No 166 75%
Don’t Know 6 3%
Grand Total 222
10

Yes; Series1;
50; 23%
No; Series1; 166;
75%
Don’t Know; Series1; 6; 3%
Yes
No
Don’t Know
Interpretation: The chart above clearly shows that the south east region respondents on being
asked that whether it would be justifiable if 50% of their business is owned and managed by the
women partners, the 75% of them declined saying no they don’t agree to this. This was following
by 22% of them saying yes and 3% of them saying no. Therefore it can be said that the voting in
favour of women is comparatively lower and this shows that the south east region people are not
very supportive regarding women leading in business (Mukarram Ajmal and Saeed, 2018).
11

Pivot table
Question 4
North west region
Row Labels
Count of
Q4_3A_2
2 2
Grand Total 2
Interpretation- it is analysed from table that in north west region only 2 respondents said yes
business is having sufficient resources and expertise to run it. It means business is having basic
resources such as HR, labor, finance, etc which is utilised. Thus, all other business are not having
sufficient resources to be used. So, they need to identify those and also have to be expertise in it.
This will enable in smooth running of business and its growth. Moreover, business must have
enough resources which are necessary in order to successfully run it otherwise it leads to failure
of it. The operations are also impacted due to it in negative way. (Löfsten, 2016)
Row Labels
Count of
Q4_3A_7
2 1
3 1
Grand Total 2
Interpretation- by table it is stated that in north west region 1 person said yes for business it is
harsh to take external assistance in order to use of resources. Furthermore, only 1 said yes
describe to some extent. Therefore, it is harsh for business to take support from other people who
are external. So, decision made are not effective and no proper goals and objective are set. Along
with it, there might be possibility that due to lack of communication or relationship business is
not able to get assistance. Thus, growth is highly been affected of business in north west region.
Also, daily operations are not properly managed. Only limited external support is provided to
business.
12

Row Labels
Count of
Q4_3A_12
3 2
Grand Total 2
Interpretation- from above table it is evaluated that in business people did not took advise or
gather info. Only 2 participants said there is no reason of it as they are not able to seek info about
business from other. The people are expertise enough in north west region to run business
successfully. However, due to no reason it is identified that there are many business whose
growth is high. It has enabled in taking own decision which are effective. With that there is rise
in business growth in quick time. (Byron. and Post, 2016).
Question5
Row Labels
Count of
Q5_2B
1 47
(blank)
Grand Total 47
Interpretation- By interpreting above table it is stated that 47 respondents have selected profit
as option of growing of business in north west region. With help of profit they will be able to
attract more customers. Alongside, more profit means more reserved capital and investment.
This allows in competing in market and expanding in other market as well. Also, rise in profit
allows in increasing customer base and products sold in market are more. It is found that with
profit increasing market share and value increases. Therefore, new areas of growth is opened
which allows business to expand and grow. When revenue rises it increases capacity of company
to produce more and sell in the market. In this way profit helps in business growth.
13

Row Labels
Count of
Q5_2C
1 28
(blank)
Grand Total 28
Interpretation- from analysing data is it found there is option of market share of business
growth. So, for that 28 person said they will use it for growth of business in north west region.
With rise in market share business will be able to enter in new market. The market value will
increase and resulting generating of more revenue and sales. Furthermore, business find it easy to
expand as market share percentage rise. It shows effective performance of business in industry.
To increase market share advertising and marketing is done that results in generating awareness
within people. It directly impact on business growth and revenue in positive way. The financial
assets of business increase and this leads to its growth. The market share represent products share
of company in industry and market. (Lee and Shin, 2018).
Row Labels
Count of
Q5_2G
1 2
(blank)
Grand Total 2
Interpretation- As per the pivot table it is analysed that few people want to grow business
through diversification or new product. By offering new products in new market it will be easy
for business to attract more people and grow. This will enable in entering in new market and
gaining market share. Along with it, news product enable in gaining competitive advantage in
14

market as it consists if new features. This helps in changing trend in market where it is offered.
Thus, there is rise in sales and profits. It allows in expansion into various market and offer new
product to people so that their needs are fulfilled. Not only this diversifying product range will
also help customers to identify new products and distinguish them with other products and their
features. This will also help the business to expand and enter into new market.
Question 6
Row Labels
Count of
Q6_3
1 46
2 66
3 19
4 6
5 5
7 1
15 1
997 5
Grand Total 149
Interpretation- as per table it is stated that 46 people said there is 1 partner in business to
engage in day to day operations. Whereas 66 said there are 2 partner working in it. Moreover, it
is found that 19 person said 3 partner work together in business operations and 6 said more than
3. Also, 5 opted for option of 4 partners and 1 said 5 partner. So, participants selected option as
per view. Hence, it can be found that limited partner are working in business . So with limited
partner business is able to run and grow. Also, daily activities are done in proper way. The
decision taken are quick and it lead to achieving of goals. (Akcigit and Kerr, 2018).
Row Labels
Count of
Q6_4
15

0 70
1 62
2 7
3 3
4 2
997 4
998 1
Grand Total 149
Interpretation- as per pivot table it is identified 70 person said there are 0 women partner in
business. 62 said there is 1 women director and 7 agree in favor of more than 1. Other than this,
3 selected option of 3 women partner within business. However, it is evaluated that 2 people said
4 women director work and along with it 4 said 5. So, it is stated that there is low ratio of women
partner in business. It is because in North West region women are not able to take effective
decision. There is change in things as well. Usually, in business men deal with its running and
managing. They take more effective decision as compared to women. Due to it, women are not
partner of it. (Grover, and et.al., 2018)
Row Labels
Count of
Q6_5
1 35
2 108
3 6
Grand Total 149
Interpretation – the data state that 35 said they know there are 50% women director that is
owner of business in North West region. Besides that, 108 said no for it and only 6 said that
know it. Hence, it is concluded that there is need to increase women owner in business.
Moreover, most people are not aware about this. It might due to lack of expertise of other
business or interaction with their owners. Alongside it difficult in taking external assistant can be
reason of it. If there are more women owner then it will create awareness among more people
regarding it. The women director take effective decision in run of business.
16

REFERENCES
Books and Journals
Ransbotham, S., and et.al., 2017. Reshaping business with artificial intelligence: Closing the gap
between ambition and action. MIT Sloan Management Review. 59(1).
Grover, V., and et.al., 2018. Creating strategic business value from big data analytics: A research
framework. Journal of Management Information Systems. 35(2). pp.388-423.
Ghauri, P., Grønhaug, K. and Strange, R., 2020. Research methods in business studies.
Cambridge University Press.
Kowalkowski, C., Gebauer, H. and Oliva, R., 2017. Service growth in product firms: Past,
present, and future. Industrial marketing management. 60. pp.82-88.
Akcigit, U. and Kerr, W.R., 2018. Growth through heterogeneous innovations. Journal of
Political Economy. 126(4). pp.1374-1443.
Löfsten, H., 2016. Business and innovation resources. Management Decision.
Lee, I. and Shin, Y.J., 2018. Fintech: Ecosystem, business models, investment decisions, and
challenges. Business Horizons. 61(1). pp.35-46.
Tejedo-Romero, F., Rodrigues, L.L. and Craig, R., 2017. Women directors and disclosure of
intellectual capital information. European Research on Management and Business
Economics. 23(3). pp.123-131.
Byron, K. and Post, C., 2016. Women on boards of directors and corporate social performance:
A meta‐analysis. Corporate Governance: An International Review. 24(4). pp.428-442.
Mukarram, S.S., Ajmal, T. and Saeed, A., 2018. Women directors’ propensity towards risk in
technology firms. Corporate Governance: The International Journal of Business in
Society.
17

18