oliver scheer, technical evangelist at microsoft, "sql azure, power bi (embedded) and powerapps...
TRANSCRIPT
![Page 1: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/1.jpg)
10 Fun Facts about Soccerpowered by SQL Azure, Power BI, Power Apps, and some other tools for data and coding
Oliver ScheerSenior Technical EvangelistMicrosoft [email protected]@microsoft.com
![Page 2: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/2.jpg)
Why this talk?I‘m interested in soccer, but not an expert.I‘m a data enthusiast, a developer, and a creative.I‘m a fan of useless, but funny informations.
I want to have some cool insights for talks with soccer fanatics.
![Page 3: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/3.jpg)
DisclaimerNo guarantee of correctness.Data source is „Fussballdaten.de“ and myself.Everything is always under construction.Last update: January 2017
Test it live @ www.traumliga.com
![Page 4: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/4.jpg)
How many seasons does the „Bundesliga“ exist?
Fact #1
![Page 5: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/5.jpg)
How many seasons does the „Bundesliga“ exist?1963/1964…………..2016/2017 5
4
![Page 6: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/6.jpg)
How many teams have played the Bundesliga?
Fact #2
![Page 7: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/7.jpg)
How many teams have played the Bundesliga?
57
![Page 8: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/8.jpg)
Number of players
Fact #3
![Page 9: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/9.jpg)
![Page 10: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/10.jpg)
How colorful is theBundesliga?
Fact #4
![Page 11: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/11.jpg)
![Page 12: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/12.jpg)
Soccer and Fish? WTF?
![Page 13: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/13.jpg)
Weight!
Fact #5
![Page 14: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/14.jpg)
![Page 15: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/15.jpg)
The heaviest playerMichael Esser – SV Darmstadt – 2016/2017 103 kg
![Page 16: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/16.jpg)
The „lightest“ playerSascha Bigalke – Hertha BSC – 56 kg
![Page 17: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/17.jpg)
Champion of 2017 by lightest average Weight
![Page 18: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/18.jpg)
Size of Player
Fact #6
![Page 19: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/19.jpg)
![Page 20: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/20.jpg)
The smallest playerDieter Kurrat1,62 m
Borussia Dortmund 1963-1972
![Page 21: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/21.jpg)
The largest player2,02 m
Dirk Bastian FC 08 Homburg (1986/1987)Issa Ndoye SpVgg Greuther Fürth (2012/2013)Jan Koller 1. FC Nürnberg (2007/2008)Stefan Brasas SV Werder Bremen (2000/2001)Stefan Maierhofer FC Bayern München (2006/2007)
![Page 22: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/22.jpg)
Body Mass IndexBMI = Weight / (Size in m)²
Fact #7
![Page 23: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/23.jpg)
![Page 24: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/24.jpg)
Away vs. Home Winners
Fact #8
![Page 25: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/25.jpg)
![Page 26: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/26.jpg)
![Page 27: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/27.jpg)
Goals by minute
Fact #9
![Page 28: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/28.jpg)
![Page 29: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/29.jpg)
Goals by nationality
Live DemoSQL Azure + Power BI
Fact #10
![Page 30: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/30.jpg)
What is Power BI?
![Page 31: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/31.jpg)
Create Power BI ContentConnect to data and build reports for Power BI
What is Power BI Desktop?
![Page 32: Oliver Scheer, Technical Evangelist at Microsoft, "SQL Azure, Power BI (embedded) and PowerApps with sport data"](https://reader036.vdocuments.us/reader036/viewer/2022062903/58ed24061a28abc31e8b4683/html5/thumbnails/32.jpg)
Used toolsVisual Studio Code / C# / Azure Functions Webcrawler
SQL Azure Data Storage
Power BI Editing & Visualization
Azure Web App Hosting
Power BI embedded Hosting Power BI in the cloud