Team 2:FBI(Fresh Business Intelligence)

1. Premier League Analysis use Microstrategy BI Team 2:FBI(Fresh Business Intelligence)

2. Agenda • Brief Introduction on project • Working Process • Dashboard Show • Team Work

3. Agenda • Brief Introduction on project • Working Process • Dashboard Show • Team Work

4. About Premier League • the world's most watched league, followed worldwide by over half a billion people in 202 countries • One of the most richest football league: with total club revenues of €2.326 billion in 2008

5. Whatwe will do • We will analyze the league data from 2000-2011 • We will show you: • History Overview • average goal per match • team won the titles for most times • team overall performance • Factors that affect the performance • home result & away result • Attack & defense • Preview • Team character analysis • Prediction：Who’ll win the Champion?

6. Our Target Customer • Premier League Fan • Sports Magazine and website • Coach of club • Rich men who want to buy a club

7. Our Tools • Microstrategy 9.0 • Microsoft Office Access 2007

8. Agenda • Brief Introduction on project • Working Process • Dashboard Show • Team Work

9. Working Process

10. Collecting Data • League, Team, Match, Player Data • Collecting Data from Premier League official website, ESPN,OPTA…. • Mainly manual

11. Build the data warehouse • Use Access 2007 • ETL process • regular expression • VBA • SQL

12. Warehouse Design Team Hierarchy

13. Warehouse Design Time Hierarchy

14. Warehouse Design Fact Table(Too many to display here) ………………………

15. Logical Data Model • Logical Data Model Season Manager Team Match Player Away Team Home Team Team A Team B

16. Build Project • Configure Project Metadata • Tool: Configuration wizard • Configure Project Connectivity • Tool: System Data Source(ODBC) • Creating Project • Creating Schema Object • Table, Fact, Attribute, Hierarchy

17. Build Reports & Dashboard • Reports for overview, analysis and preview • Nearly 90 metrics • Single Layout Multiple Panel

18. Agenda • Brief Introduction on project • Working Process • Dashboard Show • Team Work

19. “Overview” Panel • Team Profile Case • Manchester United • Match Reports Case • 2009/2010 Manchester City vs. Chelsea • League Statistics Case • Average Goal of season 2009/2010 : 3 • Glory: 10 tile, MU 5,Chelsea 3, Arsenal 2 • Seasonal Team Performance: Chelsea scored 103 in 2009/2010

20. Factors Analysis • Which Factors will affect the winning of the champion? • - Home vs. Away • - First Half vs. Second Half • - Attack and Defense • - Foul, Yellow Card and Red Card • - Player Skills (Not mentioned in this part for missing of data)

21. Factors Analysis-Home vs. Away • Case: • Top Team:09/10 Chelsea and Manchester United • Home: Chelsea 52 MU 49 • Away: Chelsea 34 MU 36 • See Graph Below: • 09/10 Sunderland with low away rank but not so bad season rank • Another example: 05/06 Fulham • Conclusion • Compare to 04-09 Top Team have both worse Away Performance ,so the excellent Home performance is more important

22. Factors -First Half vs. Second Half • Case: • 09/10 First Half Time Goal: • Top Team top rank • 09/10 Second Half time Goal Percent: • No much difference • 05/06 Second Half time Goal Against Percent • Sunderland • Conclusion • Top team seems more likely to score in the first half and kill the game • Weak team is more likely to lose in second half

23. Factors- Attack and Defense • Case: • 09/10,08/09…. • Conclusion • You should strong in both ways

24. Factors - Foul, Yellow Card and Red Card • Case: • 01….10 • Top Team in a cluster • Conclusion • Top One always neither the cleanest one nor the dirtiest one; It seems foul sometimes helps you.

25. Preview • General • Attack & Defense • Staff

26. Preview -General • Case: • Chelsea have both top rank of GF and GA • Much First Half Time Goal and Little Goal Against. • Arsenal with Top Possession Percent and only rank 4 and goal16

27. Preview -Attack & Defense • Case: • Still Chelsea • Arsenal with Most Chances Created and corner • Manchester United with Most cross • winger

28. Preview -Staff • Case: Chelsea and Manchester United • Manager • Manchester United Sir Alex Ferguson with excellent history result • Player： • Goal Keeper：both excellent • Assist：Key player such as Nani and Drogba • Best Shooter：BerbatovDrogba • Guard：Alex and Vidic

29. Conclusions & Suggestions • Prediction of Champion • Chelsea • Suggestions to Teams • As rival of Chelsea: Manchester United should improve their defense • Arsenal should be more efficient, With Top Possession Percent and only rank 4 and goal16

30. Agenda • Brief Introduction on project • Working Process • Dashboard Show • Team Work

31. Way of team work • Divide Project into three clear parts • Overview • Factors Analysis • Preview • Single intelligence Server Multiple Client(Desktop/Web)

32. Member Contribution • Yan, Pengyi(Robert): Team Leader • Contribution • Collecting the Match data • Design the scenario and report • Design the factor panel and preview panel of dashboard • Remark from team mate: “Problem Killer”

33. Member Contribution • Tian, Baoming(Bob) • Contribution • Collecting the team, player data • Build and maintain the data warehouse • Build project and schema object and overview report • Design the overview panel of dashboard • Remark from team mate: “Top Analyst”

34. End • Thank you!