sofifa-web-scraper VS worldcup

It has over 18k detailed players info and stats from FIFA23. I thought folks would find some interesting use for it. Here's the link to the GitHub Repo.

I thought this would interest some folks. https://github.com/prashantghimire/sofifa-web-scraper

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