NFL Preview with Jedox | Data from NFLSavant.com | Rush Direction and Pass Type (http://jxrd.blogspot.com/2015/12/NFLPreviewwithJedox.html)
7 December 2015, 8:24 pm
NFL Preview Dashboard Team ComparisonAbout one month ago i start a mini poll via Twitter to search for a new blog theme - question was Soccer Stats or Jedox 6.0 Feature. But someone (@Kingzulu84 (https://twitter.com/kingzulu84)) had an idea for other stuff :)
(http://4.bp.blogspot.com/-EukkqwFVW3w/VmXVESFL5tI/AAAAAAAABsM/7q3WyXRPLqI/s320/Twitter.png) (http://4.bp.blogspot.com/-EukkqwFVW3w/VmXVESFL5tI/AAAAAAAABsM/7q3WyXRPLqI/s1600/Twitter.png)
So i have to do something in this direction - I take some csv based data for every NFL Game from @darenw (https://twitter.com/darenw) (NFLSavant (http://nflsavant.com/)) and put it in a Jedox OLAP database with DataDriven Modelling (http://knowledgebase.jedox.com/knowledgebase/data-driven-olap/) respective integrated ETL Tool.
[tr][td](http://2.bp.blogspot.com/-vhRr74MtFvA/VmXVH3AzxsI/AAAAAAAABsY/pzIiJB50p_s/s640/DataDriven.png) (http://2.bp.blogspot.com/-vhRr74MtFvA/VmXVH3AzxsI/AAAAAAAABsY/pzIiJB50p_s/s1600/DataDriven.png)[/td][/tr][tr][td]Data Driven Modelling with csv File from NFLSavant.com[/td][/tr]
[/table]
The OLAP Cube with dimension like Play, Offense Team, Defense Team, Formation, Pass Type and Rush Direction with measures like Yards, IsRush, IsPass, IsIncomplete, IsSack, IsIntersecption, IsFumble and calculated measures Yards/Rush or Yards/Pass.
[tr][td](http://4.bp.blogspot.com/-Tr1m0lfwIy8/VmXVLK0wnMI/AAAAAAAABsk/kZ6s2Nwc37U/s320/Cube.png) (http://4.bp.blogspot.com/-Tr1m0lfwIy8/VmXVLK0wnMI/AAAAAAAABsk/kZ6s2Nwc37U/s1600/Cube.png)[/td][/tr][tr][td]Dimensions and Cube in Jedox[/td][/tr]
[/table]
[tr][td](http://2.bp.blogspot.com/-c8qGUai1Pc4/VmXVNuA8biI/AAAAAAAABsw/8sfowtLl464/s320/Team.png) (http://2.bp.blogspot.com/-c8qGUai1Pc4/VmXVNuA8biI/AAAAAAAABsw/8sfowtLl464/s1600/Team.png)[/td][/tr][tr][td]Dimension: OffenseTeam[/td][/tr]
[/table]
[tr][td](http://4.bp.blogspot.com/-SGau-hw-I-Y/VmXVPqF-ipI/AAAAAAAABs8/-E9MF2y4lgk/s320/Rush.png) (http://4.bp.blogspot.com/-SGau-hw-I-Y/VmXVPqF-ipI/AAAAAAAABs8/-E9MF2y4lgk/s1600/Rush.png)[/td][/tr][tr][td]Dimension: Rush Direction[/td][/tr]
[/table]
[tr][td](http://2.bp.blogspot.com/-yTDzLMVJ__Q/VmXVRQ7V4GI/AAAAAAAABtI/ArhFn2sCqyM/s320/Measure.png) (http://2.bp.blogspot.com/-yTDzLMVJ__Q/VmXVRQ7V4GI/AAAAAAAABtI/ArhFn2sCqyM/s1600/Measure.png)[/td][/tr][tr][td]Dimension: Measures[/td][/tr]
[/table]
And finally with some Adjustment we got something like a dashboard with NFL Preview character with the various Measures and the prefered Rush Direction and PassTypes for the compared Teams in a heatmap. Hopefully you can take some information from that - to be honest im not the big NFL Fan. My favorite QB by the way was Doug Flutie :) - so you can see, it is some time ago that i followed the NFL Scores :)
Lets see the dashboard for the Monday Night Game today between the Dallas Cowboys and the Washington Redskins:
(http://2.bp.blogspot.com/-_7U9fG34JUM/VmXVXupUOEI/AAAAAAAABtU/lYPh3qDdpas/s640/DALWAS.png) (http://2.bp.blogspot.com/-_7U9fG34JUM/VmXVXupUOEI/AAAAAAAABtU/lYPh3qDdpas/s1600/DALWAS.png)
- Dallas got 116 Yards more over all Games this season then the Redskins
- Dallas has more Touchdowns (+2), more Rushes (+39), less Incomplete Passes (-12) and less Fumbles (-6)
- Washington has more Passes (+42), less Sacks (-7) and Interceptions (-1)
- Dallas is dominating most of the Rush Direction but Washington got 1,6 Yards more per Rush
- The other way round for Passing - Dallas got only more Passes by Short Right Type, but in average they got 1,5 Yards more then Washington.
[tr][td][/td][/tr][tr][td][/td][/tr]
[/table]Have a great Monday Night Game - for me it will be too late in the Night :)
(http://2.bp.blogspot.com/-1LUiP6Ux6Hw/UoR7AIyV6hI/AAAAAAAAAgg/KGxbKTG2F8M/s1600/jx_mail_ico.png) (jens.orlik@jedox.com) (http://2.bp.blogspot.com/-kWBbbxPTZW8/UoR6JCSn4KI/AAAAAAAAAgI/K4YaqBL33us/s1600/Linkedin.png) (http://lnkd.in/brYxEjF) (http://4.bp.blogspot.com/-_vCSwrAcC_A/UoR6JPeTF_I/AAAAAAAAAgM/05iuI6dQAYo/s1600/Twitter.png) (https://twitter.com/jensjedox) (http://3.bp.blogspot.com/-l5bBxWg5DKo/UoR6IvUcXKI/AAAAAAAAAgA/Nf4jvEf3yw0/s1600/Xing.png) (https://www.xing.com/profiles/Jens_Orlik)
(http://2.bp.blogspot.com/-5FcOWeiJIwQ/UoR683aGy9I/AAAAAAAAAgY/aGOSaJJEGos/s1600/jx_jedox.png) (http://www.jedox.com/de/)
Source: Jedox reports and dashboards (http://jxrd.blogspot.com/)
Weitere Informationen findest Du bei Jedox reports and dashboards (http://jxrd.blogspot.de/).