worldcup VS worldfootballR

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

I found this the other day though, where there is an R package with what looks like a good amount of data. So, when I'm ready I might explore this as this might be the best approach to pull in a lot more players more easily.

https://jaseziv.github.io/worldfootballR/ works really well with publicly available data and does most of the data scraping for you, but if you wanted to access paid stuff then you’ll need something else.

Data is from FotMob and grabbed via worldfootballR. Highly recommend to anyone looking to play around with soccer data, it's super well documented (as is everything in SportsDataverse). It doesn't have player location and all the advanced stuff but has a lot of rich shot data + match stats/events. worldfootballR has a bunch of fb-ref, understat, and transfermarket data as well.

There’s an R package called worldfootballR that can be used to extract data from FBref, Transfermarkt, Understat and FotMob. Most of those sites don’t carry much data about Scottish football but FotMob have some really useful shot location data with xG and xGOT values. Here’s the link to the package: https://github.com/JaseZiv/worldfootballR

The worldfootballr R package can help you download from some of the big ones.

Source:WorldfootballR package

Data extracted using worldfootballR