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 :)


            

Die wichtigsten Finanzkennzahlen von Borussia Dortmund im Vergleich

Dashboard zum Konzernzwischenlagebericht vom 31.12.2014 des BVB

In diesem Dashboard sind die wichtigsten Finanzkennzahlen der Borussia Dortmund GmbH & Co. Kommanditgesellschaft auf Aktien gegenübergestellt. 

Verglichen werden die am 20.02.2015 publizierten Zahlen vom ersten Halbjahr 2013/14 (Schwarz) mit dem Vorjahr (Gelb) und dem ersten Konzernzwischenlagebericht von vor 7 Jahren (Grau).

Dashboard zum Konzernzwischenlagebericht von Borussia Dortmund

Beispiel: Umsatzerlöse

Die Umsatzerlöse lagen in der ersten Jahreshälfte bis zum 31.12.2014 bei 136,60 Mio. €. Im Vergleich zum Vorjahr bedeutet dies eine Steigerung von 8,5% (Vorjahr 125,94 Mio. €). In grau wird der Vergleichswert aus der grauen Vorzeit 2008 gegenübergestellt, am 31.12.2008 wurden Umsatzerlöse in Höhe von ca. 50 Mio. € erreicht - damit wurden in den letzten 7 Jahren eine Steigerung der Umsatzerlöse um 172,9% erwirtschaftet.


Die Finanzkennzahlen im mittleren Bereich verwenden die gleiche Achsen-Skalierung und sind somit untereinander vergleichbar:

Finanzkennzahlen als Wasserfalldiagramme untereinander vergleichbar

Auch die Entwicklung des Eigenkapitals, der Schulden und des Finanzmittelbestandes sind an einer Skala ausgerichtet. Hier werden auch wieder die Farb-Notationen von oben verwendet (Schwarz=Ist, Gelb=Vorjahr und Grau=t-2).

Bilanzkennzahlen ebenfalls vergleichbar

Anbei nochmal eine kleine Legende, um das Dashboard besser lesen zu können:

Legende

Please find attached an english Version of the Dashboard which shows the Interim group management Report of Borussia Dortmund GmbH & Co. parternship limited by shares.

Dashboard in Englisch (multilingual)

  

Legend: Actual = Black | Prev Year = Yellow | 7 Years ago = Grey | positive Deviation = Green | negative Deviation = red/orange

Viel Spaß beim Analysieren der Kennzahlen von Borussia Dortmund - Feedback willkommen!

            

WC 2014 - 8 Bit Preview Knock Out Stage

Preview Dashboard for Knock Out Stage

Overview Dashboard for the Round of Last 16 with nice 8Bit Pictures from 8bit-football.com.

Stats for Goals, Shots on Goal, Passes, Completion Rate, Ball Possession, Tacklings Won and Average Grade from kicker.de.

8-Bit Finals

8-Bit Semi Finals

Other World Cup Reports:
Games Preview (DE)
Group Preview (DE)
Games Review (EN)
Group Stage Recap (EN) clickable Link

PDF-Download: 8Bit Last 16 Dashboard

Please Support this Project: Pixel Soccer

Have Fun with the World Cup 2014.

            

WC 2014 - World Cup Group Stage Recap - Dynamic Dashboard (EN)

Recap of Group Stage at the World Cup 2014

Now we have a new Way to present our Dashboards. Please find attached a Link to the Jedox report in which you analyze the Group Stage Statistics for each Team.

Direct Link to the JXRD Dashboard 

Different Filter for the Countries - only Groups, Special Federation or the eliminated/Advanced to Last 16 Teams
You can create a list with the Checkbox "Tactical Formation" to unhide the Pictures

Previous Reports:
Games Preview (DE)
Group Preview (DE)
Games Review (EN)
Have Fun with the World Cup 2014.

            

WC 2014 - World Cup Games Recap (EN)

Recap of the played Games at the World Cup 2014

Group Stage is over, but which Team performed well and which Teams are the Flops for now. In this Dashboard every single Game is visualized with Statistics for Goals, Shots on Target, passes completed, ball possession and tackling percentage. Additionaly the average Grade from "kicker.de" and the FIFA Player of the Match.

Kckr-Start-Ratio is the Ratio from the predicted line-up (kicker.de) and the real line-up of the Teams.

Tops in Yellow stands for the best Team compared to all Teams for this Stage. Same for Flops in Red.

Shots - Top: 18 (BRA) vs. Flop: 7 (NED)
Passes - 683 (NED) vs. 445 (BRA)
Completion Rate - 86% (NED | BRA) vs. 83% (ARG)
Ball Possession - 56% (NED) vs. 44% (ARG)
Tacklings Won - 52% (GER | ARG) vs. 44% (BRA | NED)
Kckr-Grade - 1,6 (GER) vs. 5,5 (BRA)
JXRD Player of Quarter Finals - Toni Kroos (GER)

Shots - Top: 20 (NED) vs. Flop: 6 (CRC)
Passes - 684 (NED) vs. 338 (CRC)
Completion Rate - 86% (NED) vs. 72% (CRC)
Ball Possession - 67% (NED) vs. 33% (CRC)
Tacklings Won - 56% (FRA | BEL) vs. 44% (GER | ARG)
Kckr-Grade - 3,0 (GER) vs. 3,8 (BEL)
JXRD Player of Quarter Finals - Mats Hummels (GER)

Shots - Top: 39 (BEL) vs. Flop: 7 (CRC)
Passes - 793 (GER) vs. 331 (NGA)
Completion Rate - 87% (NED) vs. 68% (ALG)
Ball Possession - 67% (GER) vs. 33% (ALG)
Tacklings Won - 64% (GRE) vs. 36% (CRC)
Kckr-Grade - 2,5 (COL) vs. 3,9 (ALG)
JXRD Player Round of Last 16 - James Rodriguez (COL)

Shots - Top: 24 (JPN) vs. Flop: 4 (AUS, CRC, USA)
Passes - 748 (GER) vs. 228 (NED)
Completion Rate - 92% (GER) vs. 67% (NED)
Ball Possession - 68% (FRA, CHI) vs. 32% (ECU, NED)
Tacklings Won - 63% (ESP) vs. 37% (AUS)
Kckr-Grade - 2,7 (MEX) vs. 4,7 (AUS)
JXRD Player of Stage 3 - Xherdan Shaqiri (SUI)

Shots - Top: 22 (FRA) vs. Flop: 8 (CHI, URU, IRN, KOR)
Passes - 615 (GER) vs. 130 (IRN)
Completion Rate - 90% (ARG, JPN) vs. 65% (URU, GRE)
Ball Possession - 77% (ARG) vs. 23% (IRN)
Tacklings Won - 59% (ESP) vs. 41% (AUS)
Kckr-Grade - 2,5 (FRA) vs. 4,6 (SUI)
JXRD Player of Stage 2 - Luis Suarez (URU)

Shots - Top: 21 (CIV, GHA) vs. Flop: 3 (ALG)
Passes - 656 (FRA) vs. 211 (IRN)
Completion Rate - 93% (ENG) vs. 70% (IRN)
Ball Possession - 71% (FRA) vs. 29% (HON)
Tacklings Won - 60% (BRA) vs. 40% (CRO)
Kckr-Grade - 2,3 (GER) vs. 4,8 (HON)
JXRD Player of Stage 1 - Thomas Müller (GER)

Kicker-Start-Ratio:

 

Have Fun with the World Cup 2014.