Developing Global Management Competencies Level 3 GSM london Unit 5

Presenting theoretical framework to link problem/opportunity statement with business intelligence/data analytics system

In Europe, football is considered as the most popular game which in turn viewed by several people. According to every sector, in football clubs, players are paid on the basis of their performance level. Football clubs offer high fees to the players who play efficiently and won trophies for the club. Moreover, winning position improves the image of Football club to a great extent. Thus, it can be presented that as per performance and skills variation take place in the fees paid by the club to high and low performing players. Hence, for developing suitable fees structure, it is highly required for club to maintain the record of player’s performance. From the perspective of tracking player’s performance and drafting suitable fees, structure record is highly needed.

Rationale behind this is that when high monetary benefits are offered to the efficient players then they are encouraged to make their best efforts. Hence, the main issue which is being faced by football association team is related to the development of appropriate fees structure. Thus, for evaluating such issue, dashboard will be created using excel which in turn provides assistance in understanding various aspects graphically. As compared to the theoretical framework, graphical presentation is considered as highly attractive and helps in understanding data set more effectually. Moreover, business intelligence system includes a wide range of tools, applications and methodologies which in turn enable business units to gather data from both internal as well as external sources and then analyze the same. BI and analytical system helps in creating reports as well as dashboards and thereby, presents the suitable view of concerned situation.

Presenting theoretical framework to link problem / opportunity statement with business intelligence/data analytics system

Business intelligence or data analytics systems are highly effectual which in turn provides assistance in evaluating issue prominently and thereby aid in suitable decision making. In recent times companies and other institutions lay high level of emphasis on undertaking business intelligence or data analytics system which helps in understanding as well as evaluating problem in the best possible way. Now, several business analytic systems or tools are available which can be used for preparing attractive dashboards such as Tableau, excel etc. Dashboard implies for the data visualization tool which in turn assists in displaying current status of metrics and KPI’s related to the enterprise. This is considered as highly effectual system which assists in arranging, as well as displaying numbers, metrics and performance scorecards on a single screen. In addition to this, SAS business intelligence and data analytics system assists in converting data set into better decision. Moreover, it includes several techniques such as regression and cluster analysis etc which helps in deriving suitable values from data set.

In the context of Newcastle Football club, using business intelligence and analytic system such as dashboard is highly significant which clearly exhibits the player who performs well. Further, dashboard also presents fess which is paid by Newcastle football club to the players. Graphical presentation develops high understanding regarding data set and thereby aid in effectual decision making. Thus, referring dashboard football club association can develop suitable fees structure after the completion of contract. Further, regression analysis tool, in SAS, presents the level to which one factor or variable depends on another. Hence, in this, SAS software or studio has been used to evaluate the impact of fees paid on goals performance of players. Further, cluster analysis, a multivariate method helps in classifying a sample or group of abstract objects into the classes of similar one. Hence, such statistical tool provides high level of assistance in assessing that objects pertaining to one group are highly similar to each other rather than from different objects.

Giving evidence in relation to the knowledge of key business intelligence/data analytics systems

Dashboard

Mentioned in appendix.

Regression results using SAS

Mentioned in appendix.

Critical analyzing as well as justifying effective and efficient use of the BI / DA system implemented

Dashboard

Referring dashboard it can be stated that total goals made by Ayoze Perez accounts for 6 respectively. Whereas, fouls and passes implies for 0.9 & 19.4 significantly. In comparison to the performance level, annual salary paid to the workers imply for £2340. On the other side, annual salary paid by Newcastle Football club to Islam Slimani & Jonjo Shelvey too high. Salary of such two players account for £4160 & £3640 significantly. In contrast to this, total goals of both the players namely Islam Slimani & Jonjo Shelvey are only 1. However, graphical presentation clearly shows that fouls done by Jonjo were 0.8. On the other side, number of fouls pertaining to the player Islam Slimani was zero. Further, dashboard presents that after Ayoze, high goals were done by Dwight Gayle, Joselu, Matt Ritchie and Jacob Murphy. However, salary paid by Newcastle to such personnel falls within the range of £1300 & £2340. Thus, considering graphs included in dashboard, it can be mentioned that football players of Newcastle club, who plays well, are receiving less money in comparison to others. Thus, referring overall assessment, it can be mentioned that Newcastle football club is not offering suitable returns or salary to the workers on the basis of their performance.

Regression analysis

H0: There is no statistical significant difference takes place in the mean value of fee paid and goals made by the football players.

H1: There is a statistical significant difference takes place in the mean value of fee paid and goals made by the football players.

Interpretation: By doing assessment, it has found that p value is higher in comparison to the standard value such as 0.05 which in turn shows that alternative hypothesis is true. Hence, referring overall evaluation, it can be mentioned no significant difference takes place in the mean value of fees paid and goals made by the players. In other words, it can be mentioned that fees paid do not have significant impact on the performance of football players statistically.

Drawing conclusion and giving recommendations for the successful implementation and use of a BI / DA solution in Newcastle United FC

More Resources: 

• Sample of Enterprize Risk Management
• Element 010 International Intercultural Management
• Developing Manager | Achieve Goal And Objectives
• Conference and Banqueting Management of An Organization

Conclusion

From the above report, it can be concluded that Newcastle football club is not offering salaries to the workers on the basis of their performance. Some players are paid higher by the club irrespective of the aspect that they made less goals over others. In addition to this, it has assessed from evaluation that no statistical significant difference takes place in the mean value of fees paid and goals made. However, to retain talented players Newcastle club needs to make modifications in the existing salary structure or criteria’s.

Recommendations

Referring the outcome of statistical evaluation, following recommendations are given to Newcastle football club:

• It is recommended to management team of Newcastle club to lay focus on offering salary to the personnel on the basis of their performance. This in turn helps in retaining highly talented personnel. Moreover, after specific point of time, monetary benefits or factors have high level of impact on employee’s retention. Thus, for developing the team of talented personnel Football club needs to make some changes in the existing structure.
• In addition to this, at the time of determining salary structure management team of Newcastle football should consider several factors such as fouls, passes and goals. Hence, referring such aspects football club would become able to set suitable salary structure and thereby retain talented personnel. Further, through offering suitable payments to the skilled players football club can enhance employee motivation to a great extent.

APPENDIX

Regression results

/** Import an XLSX file. **/

PROC IMPORT DATAFILE="/folders/myfolders/sasuser.v94/A51030.xlsx"

OUT=WORK.A51030

DBMS=XLSX

REPLACE;

RUN;

/** Print the results. **/

PROC PRINT DATA=WORK.A51030; RUN;

SAS output

Regression analysis

PROCREG;

MODEL Feepaid= Goals performance

RUN;

Data Set	WORK.A61357
Dependent Variable	TOTAL_GOALS
Selection Method	None

 

Number of Observations Read	10
Number of Observations Used	10

 

Class Level Information
Class	Levels	Values
Fees_paid	6	1300 1820 2080 2340 3640 4160

 

Dimensions
Number of Effects	2
Number of Parameters	7

Least Squares Summary
Step	Effect Entered	Number EffectsIn	Number ParmsIn	SBC
0	Intercept	1	1	12.1980*
1	Fees_paid	2	6	14.4609
*OptimalValueofCriterion

 

Analysis of Variance
Source	DF	Sumof Squares	Mean Square	F Value	Pr>F
Model	5	16.23333	3.24667	1.22	0.4366
Error	4	10.66667	2.66667	Â	Â
Corrected Total	9	26.90000	Â	Â	Â

 

Root MSE	1.63299
Dependent Mean	2.90000
R-Square	0.6035
Adj R-Sq	0.1078
AIC	24.64539
AICC	80.64539
SBC	14.46090

 

Parameter Estimates
Parameter	DF	Estimate	Standard Error	tValue	Pr>|t|
Intercept	1	1.000000	1.632993	0.61	0.5734
Fees_paid 1300	1	2.000000	2.309401	0.87	0.4353
Fees_paid 1820	1	0	2.309401	0.00	1.0000
Fees_paid 2080	1	3.000000	1.885618	1.59	0.1868
Fees_paid 2340	1	2.666667	1.885618	1.41	0.2302
Fees_paid 3640	1	0	2.309401	0.00	1.0000
Fees_paid 4160	0	0	.	.	.