Business Intelligence Report

Added on - 21 Jul 2020

  • 20

    pages

  • 2345

    words

  • 5

    views

  • 0

    downloads

Showing pages 1 to 4 of 20 pages
BUSINESS INTELLIGENCE
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1Problem or opportunity statement for football club........................................................................1Theoritical framework to link problem statement with business intelligence and analyticssystems.............................................................................................................................................1Evidence of knowledge of key business intelligence and analytics................................................3Excel dashboard...........................................................................................................................3Data import code..........................................................................................................................4SAS output...................................................................................................................................4Coorelation................................................................................................................................12Critical analysis and justification of effective and efficient use of BI and DA Systemsimplemented..................................................................................................................................13Conclusion and recommendation for successful implementation and use of BI and analyticssolution..........................................................................................................................................14REFERENCES..............................................................................................................................15
INTRODUCTIONBuisness analytics is one of the growing field and in current time period it is widely usedby sports academy and associations to make decisions. In the current report dashboard isprepared and regression as well as coorelation analysis is done in SAS. On basis of analysis ofresults useful decisions are taken in the current report. At end of research study, conclusionsection is prepared in the report.Problem or opportunity statement for football clubSoccer is the one of the most popular game in the UK and every year number oftournaments happened in the mentioned nation. It can be observed that football clubsconsistently add members in their group and due to this reason it become very important toidentify number of factors so as to ensure that suitable candidate is included in the football clubso that it become to compete with rival clubs (Alamar, 2013). Usually, it is observed that footballclubs pay million of amount to football players but sometimes they does not receive that supportor performance from the players which they expect from them. Thus, one of the major problem isto replace those players time to time which do not perform well even million of amount was paidto them. Major problem associated with football club is that many of its players failed to make agoal in most of matches. Thus, in order to solve this problem analytics will be used and underthis dashboard is prepared in Excel which will reflect entire performance of the players on singlesheet (Newcastle limited, 2017). Apart from this, in respect to problem statement analytical toolswill be applied on analytics platform or software like SAS.Theoritical framework to link problem statement with business intelligenceand analytics systemsBuisness intelligence is the one of the field that is gaining wide popularity now a days.This is because in business intelligence huge chunk of dataset is analyzed by preparing charts onvariables and by aligning them in proffesional manner (Travassos and et.al., 2013). In advancedsoftwares like Tableau attractive charts are prepared on dashboard and trend lines are preparedon them to make prediciton. Apart from this, descriptive analysis results can also be depicted onthem. Business intelligence is nothing but a tool to analyze large data set thart encompassmultiple variables and is related to the previous years time period. On other hand, analytics1|P a g e
systems are another option that are also available to the firms. This is because in analyticssoftware or systems data can be analyzed by using multiple tools like regression analysis, clusteranalysis, decision tree analysis and RFM analysis etc. All these methods have differentproperties and can be used to find out answers of different questions. For example regressionanalysis method is the one of the tool which reflect the relationship between two variables interms of significent difference that exist between them (Mondello and Kamke, 2014). On otherhand, cluster analysis tool reflect grouping of variables on basis of similarity that is identified byusing proximity and pattern matrix. Apart from this, decision tree is another tool which reflectthat if certain condition occur then what may be outcome.In order to solve problem that is faced by football association dashboard is prepared.Major problem faced by football association is that its few players are performing well and someare struggling to make even a single goal in match. Higher amount of contract is signed withsuch kind of players and when they does not perform it prove costly football association. In orderto solve this problem dashboard is prepared which reflect that how many goals are made bysingle player in last two years. On viewing chart it can be clearly identified that which are theplayers that perform worst in most of matches they played for football club. Apart from this, insecond chart that is on left side is indicating million of fee that is paid to each player. Bycomparing both charts it can be identified that which are those players to whom higher amount ispaid but they failed to perform well for football club. By doing so answer of problem statementcan be easily identified by using dashboard. Further, brand value chart is also prepared which ifcompared with goals that is made by players will reflect that which are those players that havegood brand value but failed to deliever performance in line to expectation (Miller, 2015). In thechart position of the players of football club is also reflected. Hence, it can be said that throughcharts deep analysis of players performance is done and in terms of fee, brand value as well asgoals they made it is identified that which players need to be retained and which one must beexcluded from squad.Statistical tools like regression analysis will be applied on data set specifically onvariables like fee paid and brand value. By doing so it will be identified whether due to change inbrand value fee also changed or brand value factor play significent role in determination of feepaid to the players of the team. Apart from this, coorelation tool will be applied to identify2|P a g e
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document