Data Handling and Decision Making: Assignment

DATA HANDLING AND
DECISION MAKING

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
QUESTION .....................................................................................................................................1
Statement of specific decision Barclays required to make..........................................................1
Descripting of relevant information used for analysis.................................................................4
a. Discussion of information related to business with representation of dataset.........................4
b. Obtaining of dataset with appropriate explanation..................................................................5
c. Importance of this statement in decision making process of business entity...........................5
Analysing the data mining procedures from data set...................................................................6
Data preparation, cleaning and filtering.......................................................................................6
Implicating the descriptive data analysis effective for immediate observation for business
performance.................................................................................................................................6
Developing organisational forecasting report............................................................................25
Visualisation and interpretation of outcomes............................................................................26
Decision making recommendations...........................................................................................26
CONCLUSION..............................................................................................................................26
REFERENCES..............................................................................................................................27

INTRODUCTION
Data handling is the techniques of collecting the data and managing it in the books of accounts which will be adequate and
effective with respect to make appropriate analysis over firm’s performance. To implicate the reformative changes in the operations of
Barclays which reflect in potential growth of this banking industry. The company have been operating in UK with facilitating the
internal banking services which is comprised of various activities such as Corporate banking, personal banking, investment
management and wealth management. In the present assessment there will be determination of the facts which are affecting the growth
of industry. The analysis will be based on analysing impacts of profitability on the amount of funds derived through shareholders.
Thus, the profitability of this banking industry will affect the number of investors in each period. It will be consisting influences of
statistical tools to analyse the relationship between variables.
QUESTION
Statement of specific decision Barclays required to make
The operational performance of Barclays Plc analysed through measuring the consequences which affects the number of
shareholders to the organisation. To analyse such variations there will be collection of reliable information which have been gathered
from past 5 year’s performance of the organisation. The data is gathered through annual reports of the company. Income statement and
balance sheets are some major sources for gathering information regarding firm's financial performance of the company. It is
consisting of profits as well as revenue derived from operations. Along with this, there will be collection of details relevant with the
number of shareholder’s to be collected to analyse the information. The net income of organization contributes significant aspect for
identifying shareholder's equity. The net income is calculated by considering its revenues for specified duration and excluded the cost
of goods sold. The COGS consider all expenses which are used for operating business like payroll, advertising, rent, taxes and
equipment. In the similar aspect, shareholder's equity is liabilities which are excluded from its business assets as it is listed on
organization's balance sheet. It contributes to assets of company and impact the book value or shareholder's equity. If profit is
generated and with retention of portion of margin after excluding each cost where equity of owner generally increases. On the contrary
1

aspect, if profit is generated but its cost of performing business has been exceeded with profit and then shareholder's equity has
decreased on usual aspect (Cole and Sokolyk, 2018). However, net income is referred as one individual factor which impact
shareholder's equity in business entity. Furthermore, net income is referred as one factor which impact shareholder's equity as it could
also raise with business owner investing more money within business. Simultaneously, it could decrease if owner took money out
from business.
2

In the similar aspect, there is evaluation of this issue with context of Barclay's bank where shareholder's equity is increasing
from huge proportion but in 2017 it has slight decrements. Conversely, its net profit is having various ups and down so profitability
negative impact in 2017 is also reducing its stakeholder’s equity. In short, it had been derived that stockholder’s equity will also move
in similar position to its net income and paid dividend also contributes in this movement. This company not always make money as it
has created negative income which is replicated as net loss which is impacting stakeholder which is opposing direction (The
Relationship Between Net Income & Owner's Equity, 2018).
From year 2015 it had not involved in merger, acquisition or restructuring till year 2017. Simultaneously, from year 2016 to
2017, its expenses were increasing along with provision for taxes and extraordinary items had increased with huge proportion. Thus,
owner's equity had raises when business entity will produce margin and retain part after payment of dividends. Losses will lead to
3