Super Bowl 50 Preview | Carolina Panthers vs. Denver Broncos

Super Bowl 50 Preview (Carolina vs. Denver)

Before Super Bowl 50 i restore the NFL Preview Dashboard from december :)

The database was a csv File with every NFL Game Stats (Regular Season) from @darenw (NFLSavant)

Lets see the dashboard for the Super Bowl Game this week:

General Stats about Yards, Touchdowns, Rushes, Passes, Incomplete Passes, Sacks, Interceptions and Fumbles:

• Carolina got 77 Yards more over all Games this season than Denver
• Carolina has more Touchdowns (+23), more Rushes (+98), less Incomplete Passes (-22), less Sacks (-6) and less Interceptions (-11)
• Denver only got more Passing Attempts (+108)

Rushing Stats:

• Carolina takes more rushing attempts and is more efficient with +0,4 Yards per attempt
• Carolina's prefered Rush Direction is Center (136) or Right End (70) but they are dominating Denver in Left Guard (+14), Left End (+13) and Right Guard (+6) too
• Only Left tackle (+11) and Right Tackle (+24) Denver got more attempts than Carolina  

Passing Stats:

• Carolina is more efficient in passing attempts (+0,7 Yards) and has more Deep Left passes (+6)
• Denver dominates the other Pass Types
• Both prefer short left or short right passes
• Denver got nearly double as much passes than Carolina through short middle (+62)

Have a great Super Bowl 50 :)

Edit: Correction Yards/Rush and Yards/Pass (05.02.2016 - 09:16)
            

NFL Preview with Jedox | Data from NFLSavant.com | Rush Direction and Pass Type

NFL Preview Dashboard Team Comparison

About 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) had an idea for other stuff :)

 

So i have to do something in this direction - I take some csv based data for every NFL Game from @darenw (NFLSavant) and put it in a Jedox OLAP database with DataDriven Modelling respective integrated ETL Tool.  

Data Driven Modelling with csv File from NFLSavant.com

 
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. 

Dimensions and Cube in Jedox

Dimension: OffenseTeam

Dimension: Rush Direction

Dimension: Measures

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:

• Dallas got 116 Yards more over all Games this season than 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 than Washington.

Have a great Monday Night Game - for me it will be too late in the Night :)


            

Salary Comparison in American Sports and European Soccer (EN)

How much $ did the Teams invest for a Win in American Sports or European Soccer!

Based on the "Global Sports $alaries Surv€y" from sportingintelligence we did some analysis and a connection to the victories made in a season. “The Numbers for American Sports pertain to the 2013-14 seasons. [..] And for the Premier League, Bundesliga, La Liga and Serie A the salaries reflect summer 2013.” (Global Sports Salaries Survey 2014, S.06) 
Accordingly, the victories in Soccer leagues are from the 2012-13 season.  

For this analysis, we have created an all-in-one dashboard. You have the option to choose the sport, the league and the measure that you want to represent. Above you see the leagues in combination with the average of the selected measure. 

Clicking the League column, the dashboard is filtered and the teams in the league are visualized in a sorted table in which you can also see which teams are above average and which teams are below. 

Overall Teams Top 10 and Bottom 10

All Soccer Teams from all Leagues

And here are the results of each League in the group Soccer for Bundesliga, Premier League, La liga and the Seria A.

And the same for each League in the group American Sports for NBA (Basketball), NHL (Hockey), NFL (Football) and MLB (Baseball).

Have fun with your favorite sport / team and the $ sometimes well used but also wasted money.