Developing Global Management Competencies: Data Analysis in Football

This report examines the application of data analytics and business intelligence within Newcastle United Football Club. The analysis begins by identifying the problem of optimizing player fees based on performance and the opportunity to leverage data analytics for improved decision-making. The report justifies the use of data analytics and business intelligence, highlighting tools like dashboards, regression analysis, and cluster analysis to evaluate player performance metrics such as goals scored, fees paid, brand value, and key passes. Through the use of dashboards, the report visualizes the relationship between player performance and compensation, and identifies areas for improvement in the fee structure. The analysis includes regression analysis to assess the impact of fees on goals scored and cluster analysis to group players based on similar characteristics. The report critically analyzes the findings, emphasizing the need to align player fees with performance and to penalize fouls to enhance productivity. The conclusion recommends the implementation of business intelligence and data analysis to optimize player performance and financial management within the club.

Developing global
Management Competencies I

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................3
1. Statement of problem or opportunity along with system of Data Analytics and Business
Intelligence..................................................................................................................................3
2. Justifying an theoretical framework for relating statement of opportunity and problem along
with system of data analytics and business intelligence.............................................................4
3. Enumerating knowledge evidence with the help of Business Intelligence/ Data Analysis....5
4. Critical analysing and justifying usage of Business Intelligence/ Data Analysis...................9
5. Conclusion and recommendation regarding implementation of Business Intelligence/ Data
Analysis in Newcastle United Football club.............................................................................10
REFERENCES..............................................................................................................................11

INTRODUCTION
Newcastle United Football club is considered as an English professional club which was
originated from merger in year 1982 (Newcastle United F.C, 2018). The duration of 1904 to
1910 is replicated as very successful as it had achieved victory of FA cup. In early 2000 had
gained its premiership by identifying its struggling period after gaining championship in season
of year 2017 -18. The present report would be providing huge insight with context of various
problems and performance which give impact of high level on football club's performance. It
would be also providing aspects of data analytics and business intelligence which helps in
assisting huge aspect in prominent manner. There is presence of various exhibits which provides
efficient and effective utilisation of Data analytics and business intelligence with reference to
Newcastle Football club.
1. Statement of problem or opportunity along with system of Data Analytics and Business
Intelligence
Football is known as very popular game in Europe as it viewed by numerous population.
As per each sector especially for football clubs all players are remunerated by considering level
of performance. By rule, if players have very good performance then they are paid by evaluating
this concept. But in present scenario, all players are playing in efficient aspect so there will
presence of new rule such as deduction on basis of foul of their own team. Hence, it could be
stated by considering skills and performance and differences in structure of payment of fees
through specific club to different low and high performers. So in the same series, fee structure
had to be developed by considering requirement of club for maintaining proper record of
performance along with foul in each game of particular players. The performance of each player
must be tracked and it should prepare appropriate structure of fees which is required in essential
format (Mendenhall and et. al., 2017).
The main objective of this study is to track that if huge monetary advantages had been
offered to superior players and to charge penalty because of foul so in this context they are
encouraged for limiting foul and to put the best efforts. Thus, the main problem which had been
observed by team of football association which is directly linked towards proper development of

structure of fees. So in the same series, for evaluating problem, there will be creation of
dashboard with the help of excel as it would be providing an appropriate assistance for its
understanding through different aspects in graphical format. While comparing this theoretical
framework, format of graph had been considered as very attractive which leads for proper
understanding of specific data set in more effective aspect. So in the same series, business
intelligence also consist of wide tool range along with there methodology and application which
would be enabling particular business unit for collecting the data set from external and internal
sources as well and it is also analysed in specific format. The analytical system and business
intelligence is considered as very useful tool for forming reports along with dashboards and it is
also articulated in appropriate aspect of the situation which had been concerned.
SWOT Analysis
2. Justifying an theoretical framework for relating statement of opportunity and problem along
with system of data analytics and business intelligence
The system of data analytics and business intelligence is referred as very effective as it
would be giving an appropriate assistance for the purpose of evaluating problem and to provide
specific aid in process of decision making. In the present era, various institutions and
organisations gives special focus on undertaking any system of data analytics as it creates
efficiency in prospective of understanding and for evaluating issue in efficient aspect. There is
presence of different system of business analytic and its tools whose availability could be
implicated for preparation of dashboard is attractive manner like Excel, Tableau etc. The tool of

data visualisation could be implied through dashboard as it would be assisting for display present
status for key performance indicators and metrics in context of any particular business entity. It
is known as very effective system which would be creating help in arranging and displaying
various metrics, balance scorecard of performance and numbers on single screen. In the same
series, system of data analytics and SAS business intelligence helps in transforming specific data
set in better aspect of decision (Paley and et. al., 2017). It also consists of various techniques like
cluster analysis, regression etc. as these would be deriving appropriate value with reference to
specific data set.
So by considering Newcastle Football club, system of data analytic and business
intelligence like dashboard is replicated as very significant and along with this it clearly views
the exhibit about player's performance along with its penalty of foul. In the same series,
dashboard is also justifying structure of fees which had been paid along with deduction to
players by Newcastle football club. There has been appropriate presentation of graphs which are
providing deep understandings with context of specific data set along with particular aid for
making effective decisions. Hence, dashboard had been referred by association of football club
for developing an appropriate structure of fees with the following duration of contract. So in this
context, tool of regression analysis with reference to SAS justify the proper level in which one
factor or any variable is highly dependent on another one. So, in this specific software of SAS or
studio had been implied for evaluating impact of fees which had been paid on performance of
goal of specific player. With reference of cluster analysis, method of multivariate is helping for
the purpose of classifying a group or sample for abstract objects in particular classes of similar
aspect. Further, these specific statistical tool helps in providing a specific level of assistance
which is directly assessing that objects belongs to particular group which is similar in high
context instead of objects which are varied from other.
3. Enumerating knowledge evidence with the help of Business Intelligence/ Data Analysis
Dashboard

Regression Analysis
Football players Total
goals
Position Fees (in
million)
Brand
value (in
million)
Position Pass per
match
Key pass
per match
Joselu 4 FW 4.1 3.16 1 19 1.6
Matt Richie 3 MF 11 13.8 3 33.93 1.8
Dwight Gayle 6 FW 1.2 1 1 10.69 1.6
Jacob Murphy 1 MF 9 6.51 3 11.26 0.9
Kenedy 2 MF 4.6 7 3 23.32 1.8

Ciaran Clark 2 DF 4.3 6.1 2 32.79 0.6
Mohamed Diame 2 MF 5.6 4.8 3 26.58 0.6
Christian Atsu 2 MF 5.1 7.7 3 15.61 1.3
Jamal Lascelles 3 DF 3 5.2 2 32.92 0.4
Ayoze Perez 8 FW 1.1 2 1 17.45 1.6

Number of Observations Read 10
Number of Observations Used 10
Analysis of Variance
Source DF
Sum of
Squares
Mean
Square F Value Pr > F
Model 1 17.4961
1
17.4961
1
5.69 0.0442
Error 8 24.6038
9
3.07549
Corrected Total 9 42.1000
0
Root MSE 1.75371R-Square 0.4156
Dependent Mean 3.30000Adj R-Sq 0.3425
Coeff Var 53.1426
2

Parameter Estimates
Variable Label DF
Parameter
Estimate
Standard
Error t Value Pr > |t|
Intercept Intercep
t
1 5.49261 1.07360 5.12 0.0009
Fees Fees 1 -0.44747 0.18761 -2.39 0.0442

Fit Diagnostics for Total_goals
0.3425Adj R-Square
0.4156R-Square
3.0755M SE
8Error DF
2Parameters
10Observations
Proportion Less
0.2 0.8
Residual
0.2 0.8
Fit–Mean
-3
-2
-1
0
1
2
3
-4.5 -3 -1.5 0 1.5 3 4.5
Residual
0
10
20
30
40
50
Percent
2 4 6 8 10
Observation
0.0
0.5
1.0
1.5
2.0
Cook's D
0 2 4 6 8
Predicted Value
0
2
4
6
8
Total goals
-1 0 1
Quantile
-2
-1
0
1
2
3
Residual
0.1 0.2 0.3 0.4 0.5
Leverage
-2
-1
0
1
2
RStudent
1 2 3 4 5
Predicted Value
-2
-1
0
1
2
RStudent
1 2 3 4 5
Predicted Value
-1
0
1
2
3
Residual

2.5 5.0 7.5 10.0 12.5
Brandvalue
-2
0
2
4
Residual
Residuals for Fee

2.5 5.0 7.5 10.0 12.5
Brandvalue
-2
0
2
4
Residual
Residuals for Fee
Regression Analysis
H0: There is no difference between goals made and fees paid to players
H1: There is difference between goals made and fees paid to players
It can be interpreted that value of P-value is 0.004 and of R Square is 0.41 which
highlights that there is significant difference between goals made and fees paid. These means
that when fees are increased, goals are also maximized leading to acceptance of null hypothesis.
Cluster Analysis

Eigenvalues of the Covariance Matrix
Eigenvalue Difference Proportion Cumulative
1 79.2856038 79.025846
4
0.9967 0.9967
2 0.2597573 0.0033 1.0000
Root-Mean-Square Total-Sample Standard Deviation 6.306559
Root-Mean-Square Distance Between Observations 12.61312
Cluster History
Number
of
Clusters
Clusters
Joined Freq
Pseudo F
Statistic
Pseudo
t-Squared
Norm
Centroid
Distance Tie
9 OB6 OB9 2 3145 . 0.0189
8 OB3 OB4 2 469 . 0.0716
7 OB1 OB10 2 218 . 0.1229
6 OB2 CL9 3 161 66.7 0.1337
5 CL7 OB8 3 109 3.8 0.2087
4 OB5 OB7 2 98.9 . 0.2754
3 CL5 CL8 5 36.2 23.6 0.5061
2 CL6 CL4 5 31.5 30.9 0.6555
1 CL3 CL2 10 . 31.5 1.2

2.5 5.0 7.5 10.0 12.5
Brandvalue
-2
0
2
4
Residual
Residuals for Fee

2.5 5.0 7.5 10.0 12.5
Brandvalue
-2
0
2
4
Residual
Residuals for Fee

The analysis is utilised for making group of variables in effective manner. Distance from
centroid is prevailed and moreover, variables possessing similarity are combined. It can be
interpreted that similarity is observed in pass per match, position held by players. Hence, above
cluster analysis shows that fees paid should be in accordance to goals made by organisation.
4. Critical analysing and justifying usage of Business Intelligence/ Data Analysis
Dashboard prepared in excel
The dashboard provides an effective way of information presented in the Newcastle
United Football Club. The information about various players can be summarized from the
dashboard in the best possible manner. It can be identified that performances of players are
carried out with ease in present dashboard. On several aspects such as brand value, fees paid to
football players, key pass per match and pass on per match basis along with total goals made by
all players in season have been analyzed in a better way. From the dashboard, it can be
interpreted that most number of goals made by player is 8 which is done Ayoze Perez. In relation
to this, fees paid to player amounts to 1.1 million. On the other hand, brand value of him is 2 (in
millions). He is a forward player and has adequate key pass average amounting to 1.6. Other
players have more fees despite of the fact that goals made by them is less in comparison to

Ayoze Perez which has highest number of goals. Matt Richie has made only 3 goals yet fees paid
to him 11 and brand value is 13.8. These figures clarify that fees structure should be changed and
on each foul made by players, income or fees in the match should be deducted so as to arrive at
favorable fees structure.
It can be critically analyzed that goals of players and fouls made by them should be
focused so that Newcastle United Football Club management may be able to formulate budget
accordingly and structure of fees payable to individual players could be established in a better
way. In this manner, more of fees should be paid to players on their individual performance and
for every foul, fees must be deducted. This will effectively enhance performance and
productivity would be enhanced. On the other hand, it would be feasible on the behalf of
management as appropriate fees can be paid to them leading to better decision-making.
5. Conclusion and recommendation regarding implementation of Business Intelligence/ Data
Analysis in Newcastle United Football club
Hereby it can be concluded that Newcastle United Football Club requires implementing
appropriate fees structure so that players may be paid in accordance to their performance and not
on the basis of brand value. It is recommended that management should take into account
players' performance and fouls made by them which will be helpful in deciding upon fees needs
to be paid. Poor performance should not be neglected and club should pay purely on individual
performance. For this, SQL server is recommended in which data of players would be inserted.
By this, daily performance will be analysed leading to make proper fees payable to players.
Positioning of players are need to be changed for enhancing productivity and higher goals would
be achieved by resolving problems.