Lowest guaranteed price across the globe. Get upto 50% off ! Book Now

MN5F12FB Developing Global Management Competencies Level 4

INTRODUCTION

Business analytics tools play important role in the organization so that data can be analyzed and decisions can be taken in effective manner. Present report deals with Newcastle United Football Club is English football association and is member of Premier League as well. The club was formed in 1892 by merger of Newcastle East and West End. This club is one of seventeenth highest in terms of earning revenue in the year 2015. The club has won various big titles in recent period. The report highlights problem or opportunity which have negative effect on the performance of club. In relation to this, theoretical framework is linked to problem or issue by using dashboard prepared in excel. Furthermore, business intelligence tool such SAS is done by performing regression and cluster analysis. Thus, by accessing data obtained from the tools, problem can be resolved by taking enhanced decisions. Moreover, conclusion and recommendation is provided from results extracted through SAS software.

1. Introduction to opportunity or problem statement for Newcastle Football club

The game of football is quite famous in England which is a part of Europe. From the every part of Europe, visitors come across the grounds to see their favorite players perform well in the matches and as such, large number of people likes to watch football matches and cheer up their favorite players. In the football club, players are purchased and higher amount of fees are paid to them so that they perform well in the ground. Out of the players purchased by Newcastle United Football Club, some of them play well while other fail to perform well (Geppert, 2018). Thus, it is required to pay fees to players as per their individual performance and as such, club can maintain its costs in a better way. In relation to this, it is required to keep close watch and track performances so that adequate fees can be paid. It can be analyzed that as per the views of the management of club that high fees paid to players will have positive impact and they will give their best. While, this thinking may not be true in all circumstances.

In present analysis, data of football players of by Newcastle United Football Club will be carried out by preparation of tools such as SAS software which perform linear regression analysis. Moreover, dashboards are prepared as well so that problem can be assessed in effective manner. The problem statement in Newcastle United Football Club is to implement and assess appropriate fees structure in accordance to player’s performance as more quantum of amount is paid but they fail to perform well and lose matches without making goals. Thus, football club is required to select players so that in next season of Premier League, all may play nicely. Thus, problem will be resolved by implementing results extracted from SAS software and dashboards as well with much ease. The business analytical tools will be helpful to Newcastle United Football Club to effectively carry out the appropriate fee structure of the players in the best possible manner. Moreover, preparation of excel dashboard would help to analyze effectually what quantum of match fees should be given to players as per their performances in the ground. It will be beneficial for football association in implementing correct structure of fees which will be on the basis of performance of players. If they do not perform well, fees should be paid low and if they make adequate goals, then fees should be paid accordingly (Newcastle United. 2018).

On the other hand, SAS software is effective business intelligence and predictive analysis tool which provides clarity regarding the data and organization may be able to draw results by implementing such data analytics tool in the best possible manner. It is quite useful tool which will help football association to easily analyze data of players and their performances and as such, results may be drawn in the aspect of these analytics, adequate fees structure can be effectively implemented. Thus, players could be paid according to the performance in the seasons. Moreover, Newcastle United Football Club may be able to implement fee structure and as such, decision can be made which players will play in the next season and which can be drop out from the squad. Thus, above problem statement could be easily by implementing these tools in effective manner.

2. Applying theoretical framework to link statement with business intelligence / data analytics system

The theoretical framework is effective way to resolve problems in effective way. In relation to this, business intelligence provides desired results. It is useful tool for making business decisions in the best possible manner. It is quite essential to analyze data that assists management in taking enhanced decisions. Various business intelligence tools are available such as Tableau, Excel with the help of such tools, dashboards can be prepared in effective manner. Furthermore, these variables can be analyzed in a better way to assist in decision-making. Apart from this, SAS software is useful tool in which is imported and by implementing cluster and regression analysis, better information can be extracted. The dashboard can be used to assess performance of players and amount of fees paid to them. This help to identify which players are performing well and as such, appropriate fee structure can be carried out. This will help to easily determine on basis of these two variables which players need to be retained and which players need to be dropped from the squad on basis of inadequate performance. In other system of analytics such as SAS, regression analysis will be done by taking regression analysis between goals done with fees paid. Tables will show how one variable will change and its impact on another variable (Krishna, 2018). Cluster method will also reflect players’ performance to be judged on parameters and as such, effective decisions can be made by Newcastle United Football Club.

3. Providing evidence of knowledge of BI / DA

Regression analysis

Analysis of Variance

Source

DF

Sumof
Squares

Mean
Square

F Value

Pr>F

Model

1

51.64987

51.64987

12.57

0.0076

Error

8

32.87513

4.10939

   

Corrected Total

9

84.52500

     

Root MSE

2.02716

R-Square

0.6111

Dependent Mean

4.95000

Adj R-Sq

0.5624

Coeff Var

40.95280

   

Parameter Estimates

Variable

Label

DF

Parameter
Estimate

Standard
Error

tValue

Pr>|t|

Intercept

Intercept

1

1.08311

1.26516

0.86

0.4168

Brandvalue

Brandvalue

1

0.68465

0.19312

3.55

0.0076

Cluster analysis

Eigenvalues of the Covariance Matrix

 
 

Eigenvalue

Difference

Proportion

Cumulative

1

79.3415677

78.5485853

0.9870

0.9870

2

0.7929824

0.5377270

0.0099

0.9968

3

0.2552554

 

0.0032

1.0000

Cluster History

Number
of
Clusters

Clusters Joined

Freq

PseudoF
Statistic

Pseudo
t-Squared

Norm
Centroid
Distance

Tie

9

OB1

OB4

2

3179

.

0.0188

 

8

OB5

OB6

2

168

.

0.1222

 

7

CL9

OB3

3

94.9

90.1

0.1547

 

6

OB8

OB10

2

92.5

.

0.1731

 

5

CL8

OB7

3

65.8

6.1

0.2607

 

4

OB2

OB9

2

72.1

.

0.274

 

3

CL5

CL6

5

33.4

13.5

0.5041

 

2

CL7

CL4

5

30.3

28.7

0.6541

 

1

CL2

CL3

10

.

30.3

1.1933

 

4. Discussing critical analysis and justification of use of BI / DA

Excel Dashboard

Excel dashboard provides effective way of analyzing players information of Newcastle United Football Club. The information of player related to fees paid, brand value is categorized and dashboard is prepared. Moreover, number of goals, passes per match and key passes per match is taken out. It can be analyzed that highest total goals are made by Ayoze Perez and fees paid to him is 1 million which is the lowest as compared to other players. Furthermore, brand value of the player is 2. On the other hand, it can be interpreted that other players have lower performances and fees paid to them are high. Jacob Murphy has made only one goal in the recent season of premier league. While, fees paid to the player is high. This clearly shows that Newcastle United Football Club has paid high fees despite that good performance is not attained. The principle to pay higher fees and adequate performance is just wrongful thinking. Hence, it is required that performance should be taken as a priority to pay fees to players which will be justified on the players’ performance and fee structure can be implemented (Kollwitz, Dinter and Krawatzeck, 2018). Thus, it is cleared from the dashboard that football association is required to implement appropriate fee structure so that players can be paid in accordance to their performance in the best possible manner.

Regression analysis

H0: There is no difference between fees paid and brand value of football players

H1: There is difference between fees paid and brand value of football players

It can be analyzed from the value of R-Square is 0.61 which means that when change is observed in independent variable, 61 % change is observed in dependent variable. Moreover, coefficient value is 0.68 which signifies that change in brand value will cause 0.68 of change in fees. Thus, with increase in brand value, fees also maximize and hence, alternative hypothesis is accepted.

Cluster analysis

It is effective tool in which is used for grouping similar variables in effectual way. It helps to group variables which have similar pattern and distance prevails in centroid. In relation to this, it can be observed in that there is high degree of similarity between key passes, position, average passes of players. Thus, no difference is observed in aspect of passes made by players.

5. Conclusion and recommendation for implementation and use of BI and analytics solution

It can be concluded that players' performance is the key aspect which should be taken into account by Newcastle United Football Club. This is evident from the fact that football players are paid according to their individual brand value which is not good approach. The association should analyze performance and then accordingly payment shall be made. Higher amount is paid to them while, players have poor performance which is wrong approach. It is recommended that database should be prepared in which each and every match performance of players should be entered in SQL server. It will be helpful for the football association to analyze performance on daily match basis and fee structure can be justified as well. Moreover, it is recommended to change position of players so that overall performance can be enhanced. Thus, it will be beneficial for the team as problem can be resolved by such tools.

REFERENCES

  • Geppert, M., 2018.Neighborhood Perception Data and Needs Analysis: Tools for Small Business Site Selection and Retail Mix in the Discovery District in Downtown Columbus, Ohio, USA(Doctoral dissertation, The Ohio State University).
  • Kollwitz, C., Dinter, B. and Krawatzeck, R., 2018. Tools for Academic Business Intelligence and Analytics Teaching: Results of an Evaluation. InAnalytics and Data Science(pp. 227-250). Springer, Cham.
  • Krishna, G., 2018. Social Networking Data Analysis Tools and Services. InSocial Network Analytics for Contemporary Business Organizations(pp. 19-34). IGI Global.
Download Full Sample
Cite This Work To export references to this Sample, select the desired referencing style below:
Copy to Clipboard
Copy to Clipboard
Copy to Clipboard
Copy to Clipboard
Boost Grades & Leave Stress

Share Your Requirements Now for Customized Solutions.

Lowest Price

USD6.27

    FOR FIRST ORDER GET EXTRA 25% OFF

    Seasonal seasonal-mobile

    Our unique Features

    24/7 Customer Support

    100% Customer Satisfaction

    No Privacy Infringement

    Quick Services

    Subject Experts

    Innovative Documents

    100+ Qualified Writers

    For Best (Accounting) Assignment Help

    Loren Gillbert
    445 - Completed Orders
    Loren GillbertView Profile Hire Me
    Alice Webster
    240 - Completed Orders
    Alice WebsterView Profile Hire Me
    Grace Wilson
    160 - Completed Orders
    Grace WilsonView Profile Hire Me
    Mathew Jones
    344 - Completed Orders
    Mathew JonesView Profile Hire Me
    View All Writers
     
    IAH whatsapp

    Limited Time Offer

    Exclusive Library Membership + FREE Wallet Balance