worldcup VS football_analytics

Hi guys, I have a school project for building a Data warehouse using an open-source dataset. I currently dive into one dataset which is The Fjelstul World Cup Database (Github: https://github.com/jfjelstul/worldcup). This dataset has multiple tables which combine a variety of properties. It's hard to figure out the whole following process to build a Dataware house from scratch. I just get some ideas and make out a sample of this. Can you guys help me examine that? What are the best ways to build Fact and Dimension tables from this generous dataset? What properties and table I should put in that case?

Source: Fjelstul World Cup Database

let Source = Web.BrowserContents("https://github.com/jfjelstul/worldcup/tree/master/data-csv"), #"Extracted Table From Html" = Html.Table( Source, {{"FileName", ".js-navigation-open.Link\-\-primary"}}, [RowSelector = ".Box-row + *"] ), fxCSVs = (FileName as text) as table => let Source = Csv.Document( Web.Contents( "https://raw.githubusercontent.com/jfjelstul/worldcup/master/data-csv/" & FileName ), [Delimiter = ",", Encoding = 65001, QuoteStyle = QuoteStyle.None] ), #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars = true]) in #"Promoted Headers", #"Invoked Custom Function" = Table.AddColumn( #"Extracted Table From Html", "CSV_Data", each fxCSVs([FileName]) ) in #"Invoked Custom Function"

= Csv.Document(Web.Contents("https://github.com/jfjelstul/worldcup/blob/master/data-csv/award_winners.csv"),[Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.None])

Just wondering, because I found this recently and thought about starting getting into football analytics

You can check statsbomb open data but you will to preprocess it from json to sql. They have great course and articles about analyzing the data. Another good reading is awasome-football . They provide list of resources to get data. But the most comprehensive and recommended resources eddwebster's guide. He worked for city football group and his repository updated frequently.

Segue o link do repositório: https://github.com/eddwebster/football_analytics

I found a great collection for anyone who's interested in football analytics