TABLE OF CONTENTS INTRODUCTION...........................................................................................................................1 1.Assessingproblem/opportunity statement regarding Newcastle United FC...........................1 2. Developing dashboard and doing regression using excel.......................................................5 3. Interpretation of dashboard.....................................................................................................7 4. Drawing conclusion and giving recommendation...................................................................9 REFERENCES..............................................................................................................................11
INTRODUCTION The football game is quite famous in the UK. NewcastleUnited Football Club is known for English Professional club of football which was founded in 1982.The period from 1904 to 1910 was one of the successful year for the football club as they have won FA (Football Association) Cup in the said period. However, it has also found struggles for winning cups in early 2000 but it returned strong after winning the Premier League of 2017-18 in effectual manner. This shows that football club is able to win matches in the best way possible by making higher goals. Present report will deal about the deeper insights about the issues being currently observed in the club. The problem statement in Newcastle United Football Club is that players are appropriate fees structure is not present. Players are not paid in accordance to their individual performance but are paid according to their big names. For resolving issues in effectual manner, usage of Business intelligence and Data Analytics will be carried out in presenting solutions to club’s management. Moreover, excel dashboard will be presented which in turn would be helpful in providing key aspects in effective way(Farokhi & Roghanian, 2018).Excel dashboard will be presented in which up to 70 players data will be analysed. Hence, management will be able to implement appropriate fees criteria. Recommendation will be made for usage of Business Intelligence / Data Analytics. 1.Assessingproblem/opportunity statement regarding Newcastle United FC The game of football is one of the popular one in overall Europe. Players also play well and receive good amount of income in the best way possible. This is evident from the fact that fees paid to players are more in comparison to other sports(Dixon, 2018).It can be analysed that in the football sector, players are paid in accordance to their performance and as a result, fees are paid to them quite effectually. The management of Newcastle United Football Club has main issue as it is not able to form appropriate fees structure in the best way possible. This issue need to be resolved so that players could be paid in accordance to their performance i.e. more number of goals made and should be paid higher and not as per the big name of players. For overcoming issue, dashboard in excel will be prepared in accordance to performance of players. 1
The football club is required to prepare appropriate structure in effectual manner. It can be analysed that graphical representation of players’ performance will be made with the help of which presentation will provide performances and related parameters of performance quite effectually(Nikghadam Hojjati & et.al., 2018).Business Intelligence is crucial technique which provides way for concerning problems and aids in decision-making quite effectually. In accordance to problem being identified, business intelligence software is quite useful for analysing solutions in the best manner possible(Haryadi, 2018). Dashboard is one of the important means that by which firm may be able to analyse significance in effectual manner. Dashboard is a data visualisation tool which is helpful in displaying present status of metrics and KPI (Key Performance Indicators) to firm quite effectually (Zambom-Ferraresi, Iráizoz & Lera- López, 2019). Regression is termed as a set of definite process for estimating relationships between two variables such as dependent variable and independent variables in a better manner SWOT [Translateintotasksforthe Project Plan] Strengths ●Able to attain project on time. ●Good interpersonal skills Weaknesses ●Low problem-solving skills ●Low patience Opportunities ●Accountabilitytolearn from problems ●Focusing on new challenges I can use these strengths to takeadvantageof opportunitiesbyassessing root cause of problems. Icanovercome weaknessesby favouring more on time management. 2
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Threats ●Not able to achieve work- life balance ●Unabletoaccomplish priorities Icanusestrengthsby schedulingactivitiesfor getting work accomplished on time. Iwillaccomplishthreatsif activitiesarenotprioritised. Moreover,itwillhamper work. SSM SSM (Single Supervisory Mechanism) is useful data analytics tool for prioritising strategic investment in the best manner possible. It enhances supervision quality and produces desired results(Alexander, 2015).It is useful for Newcastle United Football Club as it helps to resolve structured queries which are found in fees paid and performance of football players which are not appropriate. RICH PICTURE 3
Illustration1: Rich Picture of Newcastle United Football Club ROOT ROOT is called data container tree with its structures of leaves and branches. In simple words, it is used to assess data analytics in order to ascertain productivity about data and provide results to management for taking decisions(Dudin & Frolova, 2015). With the help of ROOT, Newcastle United Football Club's management will be able to form structured fees criteria for players as per their individual performances(Awadallah & Allam, 2015). CATWOE It stands for CATWOE (Customers Actors Transformation process, Worldview, Owners andEnvironmentalconstraints).Itisusefulbusinessanalyticstoolforidentifyingwhat Newcastle United Football Club wishes to achieve, what are problem areas such as fees structure and how perspective of stakeholder affects owners of it(Gminder, 2018). CONCEPTUAL 4
The data analytics is based on conceptual framework which involves sorting large data sets for assessing trends, patterns and predictive analytics for evaluating artificial intelligence regarding future or real-world events(Baxter & et.al., 2018).This helps management of Football Club to effectively ascertain individual performances of players and analyse high-performing and low-performing people. Balance Scorecard Four perspectives are included in this system which includes financial, customers, internal business process, and learning and growth perspective of organisation(Akkermans & Van Oorschot, 2018). Thus, internal performance of players can be accomplished with the help of balanced scorecard and thus, problem can be resolved. KPI (Key Performance Indicators) It is useful measure signifying how effectively organisation is accomplish goals. KPI's is used for evaluating success at reaching targets and hence, overall business performance is judged (Thorstad & Wolff, 2018).Thus, Newcastle United Football Club management will be able to form appropriate fees criteria with regards to high-performing and low-performing players and reward accordingly. ROUD DEFINATIATION The advanced analytics is used by using modern BI tools for discovering deeper insights, making predictions on the basis of data and producing recommendations quite effectively. Hence, reason behind low performances can be assessed and deeper insights can be gathered by management of Newcastle United Football Club and fees criteria can be set(Alyass, Turcotte & Meyre, 2015). 2. Developing dashboard and doing regression using excel Excel Dashboard (Refer to Excel sheet) Regression Analysis SUMMARY OUTPUT Regression Statistics Multiple R0.19 R Square0.04 Adjusted R Square0.03 5
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Standard Error35.59 Observations100 ANOVA dfSSMSFSignificance F Regression14679.814679.813.700.06 Residual98124112.9 5 1266.46 Total99128792.7 6 Coefficien ts Stand ard Error t StatP- value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept95.214.9519.240.0085.39105.0385.39105.03 total Goals per season 2.741.431.920.06-0.095.57-0.095.57 6
3. Interpretation of dashboard Excel Dashboard Excel dashboard has been prepared with the help of which players’ performance can be evaluated with ease. There are various players of Newcastle United Football Club such as Wilcox, Robert, Ware, David, Dyer, Carrie, Hoover, Evangeline and many other players which provides win to team in effective manner and as a result, players are paid as well. However, it can be seen that players are not paid in accordance to the fees paid. This is evident from the fact that Wilcox, Robert have made 9 goals per season with passes of 8. Moreover, key passes per game is 1 and they are paid 140 million of fees. While, another player like Hoover, Evangeline which has made similar 9 goals per season with passes 12 in every match have fewer fees. Total fees paid to these players is only 80 millions. This clearly shows that players are not offered fees in accordance to their individual performance. The above figures as represented in dashboard clearly shows that fees are not paid according to performance of players of football club. The fees paid to Hoover, Evangeline is 7
only 80 millions while Wilcox, Robert are paid total fees of 140 million. The salary or fees should be in accordance to individual performance and not related to name of players (Seddon & et.al., 2017).Providing higher fees to players having good amount of goals will boost their performance quite easily and they will be able to perform better leading to more wins to Newcastle United Football Club. MS Excel dashboard is helpful as it provides clarity regarding players' performance in Newcastle United Football Club. The highest scoring player and lowest scorers are effectively highlighted. It is beneficial for management to analyse dashboard and consecutively revise fees structure in effective manner. Thus, it can be critically analysed that excel dashboard is quite helpful for resolving problems. Regression Analysis H0: There is no significant difference between mean of fees paid and goals made by players of Newcastle United Football Club H1: There is significant difference between mean of fees paid and goals made by players of Newcastle United Football Club Interpretation- It can be interpreted from above regression analysis that p value of the figure is higher than that of standard value of significant level which is 0.05. This clearly shows that alternative hypothesis is accepted and null hypothesis is rejected.It can be analysed from overall results of regression that as such there is no statistical significant difference between value ofmean obtained between fees paid to football players of by Newcastle United Football Club and goals made by them during match. This implies that fees paid have no significant difference or impact on performance of football players.With P value that is 0.06 is will be measured that alternative hypothesis of result get accepted and null hypothesis get rejected. It also analysed with the result that null hypothesis is rejected as value is more than set level of significance. On the other hand, ANOVA is another useful technique which helps to ascertain association regarding estimations in the best manner possible (Bell, Bryman & Harley, 2018). This provides clarity that significant difference exists between the variables or not. The above output shows that F value comes to 0.06 which is more than 0.05 significance level. 4. Drawing conclusion and giving recommendation Conclusion 8
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Hereby it can be concluded from above report based on performance of by Newcastle United Football Club that management requires taking effective action for providing salaries to soccer players in the best manner possible. It can be analysed from the report that by Newcastle United Football Club is not imparting salaries to players particularly on the basis of their performance. Most of the players are getting more salaries despite of low goals made by them whichmakesthefeesstructureinappropriateuptoamajorextent.Withsuccessful implementation of BI, management will be able to revise fees structure and players would be paid in accordance to individual performances in matches. Recommendations By referring to the outcome received by applying statistical measures, recommendations can be provided to by Newcastle United Football Club which are listed below- It is hereby recommended to by Newcastle United Football Club management that it should revise the fees criteria in accordance to goals made by soccer players. The big name of players should not be taken into account as it will lead to wastage of money and efficient players will be disheartened. It is recommended that salaries offered on the basis of performance will provide team with higher performance and more productivity will be provided and efforts will be made by players. If fewer fees are paid to them when their performance is good, they will not stay with the team and it could lead to inefficiency in the team. Successful implementation of BI can be done and appropriate fees structure may be applied. Moreover, it will provide clarity regarding players' performance at regular intervals. 9
REFERENCES Books and Journals Akkermans, H. A., & Van Oorschot, K. E. (2018). Relevance assumed: a case study of balanced scorecarddevelopmentusingsystemdynamics.InSystemDynamics(pp.107-132). Palgrave Macmillan, London. Alexander, K. (2015). European banking union: a legal and institutional analysis of the single supervisory mechanism and the single resolution mechanism.European Law Review.(2). 154-187. Alyass, A., Turcotte, M., & Meyre, D. (2015). From big data analysis to personalized medicine for all: challenges and opportunities.BMC medical genomics.8(1). 33. Awadallah, E. A., & Allam, A. (2015). A critique of the balanced scorecard as a performance measurement tool.International Journal of Business and Social Science.6(7). 91-99. Baxter, J & et.al., (2018). Accounting and passionate interests: The case of a Swedish football club.Accounting, Organizations and Society. Bell, E., Bryman, A., & Harley, B. (2018).Business research methods. Oxford university press. Dixon, K. (2018). Demand and the reduction of consumer power in English football: a historical case-study of newcastle United fanzine, the Mag 1988–1999.Soccer & Society.1-19. Dudin, M., & Frolova, E. (2015). The balanced scorecard as a basis for strategic company management in the context of the world economy transformation. Farokhi, S., & Roghanian, E. (2018). Determining quantitative targets for performance measures in the balanced scorecard method using response surface methodology.Management Decision. Gminder,C.U.(2018).balancedscorecard.TheBusinessofWaterandSustainable Development, 4. Haryadi, S. (2018). of Network Performance and Quality of Service: Determination of Key Performance Indicator (KPI). 10
NikghadamHojjati,S&et.al.,(2018).RepresentationandStructuringofOrganizational Creativity applying Soft System Methodology.Organizational Resources Management Researchs.7(4). 181-203. Seddon,P.B&et.al.,(2017).Howdoesbusinessanalyticscontributetobusiness value?.Information Systems Journal.27(3). 237-269. Thorstad, R., & Wolff, P. (2018). A big data analysis of the relationship between future thinking and decision-making.Proceedings of the National Academy of Sciences.115(8). E1740- E1748. Zambom-Ferraresi, F., Iráizoz, B., & Lera-López, F. (2019). Are football managers as efficient as coaches? Performance analysis with ex ante and ex post inputs in the Premier league.Applied Economics.51(3). 303-314. 11