Business Data Analysis - PDF

BUSINESS DATA ANALYSIS

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Overview of stationery market in Germany................................................................................1
TASK 2............................................................................................................................................2
TASK 3............................................................................................................................................2
a. Sales Assessment.....................................................................................................................2
b. Mixed pie chart of 2016 and 2017..........................................................................................3
c. Correlation coefficient of Total sales and year.......................................................................3
d. Forecasting sales of 2018 and 2019........................................................................................4
TASK 4............................................................................................................................................4
a. Business expansion in Belgium and Germany with its Pros and Cons...................................4
b. List of International standards must be complied by Duque...................................................5
TASK 5............................................................................................................................................6
a. Calculating monthly cost with 30 year repayment mortgages................................................6
b. Recalculation with assumption of monthly cost with interest rate application.......................6
TASK 6............................................................................................................................................6
a. Calculating mean value of order.............................................................................................6
TASK 7............................................................................................................................................7
a. Methods for increasing consumer survey rate.........................................................................7
b. Descriptive statistics...............................................................................................................8
CONCLUSION................................................................................................................................8
REFERENCES..............................................................................................................................10
APPENDICES...............................................................................................................................11
Appendix 1................................................................................................................................11

INTRODUCTION
Business data analysis considers activities which helps managers for undertaking
strategic decisions , attaining major objectives and to solve complex issues through gathering,
reporting and for analysing important information as per requirements of managers. The present
report will discuss about Duque Papertiers gross with stationery business and will reflect
overview on stationery market. This report will discuss about annual spending of writing and
drawing materials per capita with product category of total sales of year 2015, 2016 and 2017
along with methods for raising consumer survey responsive rate.
TASK 1
Overview of stationery market in Germany
In the present scenario, there is development of stationery industry with reference to
multiple products and services which helps in adjusting innovative consumer preferences and
habits with increment in market vitality and special issues arose in the present trend. This
industry is well positioned as it has turnover which is more than €14.8 billion per year as it is
equal to individual's yearly spending which is more than €182 on annual aspect. It has been
traced that Germany had spent €35.2 on drawing and writing materials as it is at second position
in European countries. The organization's positive attitude with context of stationery industry is
underpinned with more than 70% of German stationery brand have increment is sales with
context of year 2015. As per association of German Stationery brands its total turnover had
attained growth of 3.5% within year 2014 and 2015. In this aspect, its outcome with reference to
domestic demand has accomplished growth with 2.5% and international demand with 5%.
These stationery brands of Germany has the best reputation throughout world as with its
positive image they have significant market shares of writing and drawing materials against the
private labels. Consequently, industry comprises products with broad range along with different
development along with challenges. The paper and its products such as document folders have
continued for getting turnover in declining aspect as this category of product is suffering because
of increment in digitisation which has been undertaken in private and work life. Conversely, the
paper products, brands of categories of other product had attained positive rate of growth like
office and writing instruments has attained growth with 5% in year 2015 as this trend is expected
with continuation in year 2016 (MGCC perspectives, 2018).
1

TASK 2
Country Yearly spending €
Germany 35.2
France 28.3
Switzerland 35.5
Italy 18.6
Hungary 9.6
Poland 8.5
Austria 35
Interpretation: The above graph is showing annual spending of writing and drawing
materials of European countries where Switzerland is leading and Germany is at second position
with 35.2 followed by Austria and Poland is at last with 8.5. Further, it has been stated that
writing and drawing materials in Germany had gained significant market share among these
European Union countries.
TASK 3
a. Sales Assessment
(Table attached in appendix)
The sales of year 2015, 2016 and 2017 have been traced with its major categories such as
printer cartridges, general office supplies, low cost printers and many more. It has been observed
2

that printer cartridges are raising by 4% in 2016 but in 2017 decreased with 15.38% and this was
similarly articulated in general office supplies as 8% in 2016 and decreased with 14.81%.
Furthermore, with context of low cost printers it increased with 20% but then it was constant in
year 2017.
The most important category of product is office furniture and writing and drawing
material which raised in both 2016 and 2017. The shredders raised by huge proportion in year
2016 by 16% and even paper based supplies as well but they were constant in 2017. Overall,
total sales increased with huge proportion from 2015 to 2016 by 10.30% and from 2016 to 2017
it decreased with 2.20%.
b. Mixed pie chart of 2016 and 2017
3

c. Correlation coefficient of Total sales and year
Interpretation: The correlation coefficient is considered as appropriate statistical
measure which will be calculating strength of relationship among with relative movement among
two variables. It is measure of degree or relation about linear relationship as it is not capable for
capturing non-linear relationship. In the above table, the correlation coefficient is 0.73 which is
near to 1 as it indicates quite strong relationship in total sales and year.
d. Forecasting sales of 2018 and 2019
The equation is €6500 (x) + €162000 which has been articulated by scatter plot as x as 4
and 5 where it will be in year 2018 as €6500 (4) + €162000 with outcome of €188000. In the
similar aspect when x is 5 in year 2019 as €6500 (5) + €162000 with result of €194500.
TASK 4
a. Business expansion in Belgium and Germany with its Pros and Cons
Business Expansion in Belgium and Germany
Pros Score/10 Cons Score/10
Improvement in base
of customer 8
Huge turnover of
employees 6
4

Up gradation of
technology 9 Quality degradation 7
Resource availability 9 Diversification 5
Distribution 8 Controlling cost 6
Total Pros 34 Total Cons 24
Average Pros 8.5 Average Cons 6
Net Outcome= Sum of advantages – Sum of Disadvantages
= 34 – 24
= 10
Interpretation: In the above table, there is articulation about business must be expanded
in Germany will be beneficial or not. There is extraction about scoring of its both pros and cons
as pros are of 34 with average of 8.5 and its cons as 24 with average of 6 as its net outcome is
positive 10. It could be elaborated that business will be beneficial for expansion in Belgium and
Germany.
b. List of International standards must be complied by Duque
 ISO 9001 Quality management: It is recognised internationally in world with leading
quality management standard and implemented in more than 1 million business entities.
It helps in assisting business entities for accomplishing regulatory and statutory
requirements on basis of products for attaining excellence in delivery and customer
service.
 ISO 37001 Anti bribery management systems: It would be specifying a series of
measures for business entity to address, detect and prevent bribery. It considers adoption
of anti bribery policy as this will help business entity for implementing its system and to
enhance control. In the similar aspect, risk will be decreased with bribery occurrence for
demonstrating stakeholders (International Organization for standardization, 2018).
 ISO 31000 Risk management: It is guidelines which gives principles, framework along
with process for risk management. It could be used for raising likelihood for attaining
5

objectives and to improve determination of opportunities and threats for effective
allocation and application of treatment of risk.
 ISO 26000 Social responsibility: The societal and environmental relationship where it
operates is replicated as critical factor with ability for continuing to operate in effective
aspect. It gives guidance to companies and business for operating in socially responsible
method.
 ISO 27000 family- Information security management systems: It helps business
entities for keeping information about asset in secured aspect. It will help for managing
security about financial information, employee details, intellectual property and
information entrusted with third parties.
TASK 5
a. Calculating monthly cost with 30 year repayment mortgages
b. Recalculation with assumption of monthly cost with interest rate application
6

TASK 6
a. Calculating mean value of order
Interpretation: It is considered as number of standard deviations with mean of particular
data point. It helps in measuring that standard deviation which is below or above population with
context of mean of raw score. In simple words, it is also replicated as standard score which could
be placed on reference to normal distribution curve. In the above scenario, z score is negative
0.23 which shows that raw score is less than mean (He and Lu, 2018).
TASK 7
a. Methods for increasing consumer survey rate
The online survey must be conducted as it is very simple, powerful and cost effective
method for determining behaviour and attitude of its target audience, employees and customers.
On the contrary, to retrieve satisfactory amount of raising survey responsive as for analysing and
interpreting data is full potential. The methods for raising participation and responsive rate are
stated as follows:
The survey must be simple as long questions must be retrieved exactly as per answers. It
gives positive experience with context of respondents but it should be completed on thorough
completely. The potential participants must be acknowledged personally with inclusions of their
name in email invitation. With this small sample, there should be consideration about not of
individual importance on basis of business with appreciation of opinion. The value must be
acknowledged personally which might help in cause for purpose of delivering value proposition
of survey is very essential. The respondents must be aware about value of potential respondents
which will be provided to business.
The researchers, businesses and marketers have to select respondents with fewer
incentives with consideration of option for motivating who will not take survey as with concrete
7

benefit with exchange of thoughts and time. Furthermore, expectations must be established as it
should set aside with context of survey. Numerous questions with requirement of less time for
considering it as it might be selling point for driving participation. It must send appropriate heads
ups and follow up as in advance it must be communicated for letting audience know about
survey as after initial invitation, people might undertake survey in appropriate aspect but in
presence of all likelihood various people will not. As the response rates must be increased with
only 1 or 2 follow ups emails over particular duration with reminder to its potential respondents
and for keeping survey at top of mind (5 Tactics to Improve Survey Response Rates, 2018).
b. Descriptive statistics
Interpretation: The above table is articulating descriptive statistics of outcome of 20
questionnaires of four variables as customer service, Quality P&S, sales staff along with price
value. The 3.5 respondents are favouring the customer service with perspective of mean as
quality of P&S is about 3.15 with sales staff of 3.45 and least about price value is at 1.95. On
basis of standard error, each variable is about 0 and middle value customer service and sales staff
is excellent whereas quality of P&S good and price value is fair. There is identification of mode
where multiple respondents agree with excellence of customer service and sales staff, good for
quality of P&S and fair on basis of price and value. The standard deviation is about risk
movement with reference to mean as each variable is approx to 0 but it is mandatory to be
observed as it might go up and down as well. The highest risk is of sales staff as 0.83, followed
by customer service 0.76 then price value is 0.51 along with quality of P&S as 0.37 which is
minimum in these variable.
CONCLUSION
On basis of above report, it had been articulated that Germany stationery market is
referred as one vital sector which is contributing to economy of Germany in appropriate aspect
8

as it is in huge demand driven through strong propensity for consuming and to invest through
commercial and private customers respectively. It has shown that Germany, Switzerland and
Austria are having cut throat competition on basis of Annual spending on writing and drawing
materials per capita where Poland is at last among seven European Union countries. In the
similar aspect, while gaining better understanding of wholesale stationery market in Germany,
the total sales of year 2015 to 2016 was raising with huge proportion but on the contrary, it
decreased with 2.20% in 2017 as office furniture and writing drawing material was only
increasing in 2017 and rest all are same or decreasing.
It has shown that business expansion in Belgium and Germany is beneficial to Duque
because of positive outcome and it must comply with international standards such as quality and
risk management and many more. In the same series, it has shown that consumer survey
responsive rate must be raised by keeping survey simple, personalised invitations must be sent,
value must be communicated, expectations must be established and head up and follow ups must
be sent.
9

REFERENCES
Books and Journals
He, C. and Lu, K., 2018. RISK MANAGEMENT IN SMES WITH FINANCIAL AND NON-
FINANCIAL INDICATORS USING BUSINESS INTELLIGENCE
METHODS. Management, 16, p.18.
ONLINE
5 Tactics to Improve Survey Response Rates. 2018. [Online]. Available through
<https://tribalvision.com/improve-survey-response-rates/>.
International Organization for standardization. 2018. [Online]. Available through
<https://www.iso.org/home.html>.
MGCC perspectives. 2018. [Online]. Available through
<http://www.malaysia.ahk.de/fileadmin/ahk_malaysia/Perspectives/MGC047-
Mar.Apr16_iPAD.pdf>
10

APPENDICES
Appendix 1

12