covid-poops VS worldcup

Last I checked the wastewater tracker in the Twin Cities, it was around the same amount (~54 million copies) as on April 7, 2022. By comparison, the lowest registered was on June 24, 2021 (~6.9 million copies).

source: https://metrotransitmn.shinyapps.io/metc-wastewater-covid-monitor/

It's weird that the article gives a raw source for case data, but nothing for sewage data. Not saying it's wrong, but here's another data source from Minneapolis/St. Paul area that contradicts the article: https://metrotransitmn.shinyapps.io/metc-wastewater-covid-monitor/

Wastewater viral load data is from https://metrotransitmn.shinyapps.io/metc-wastewater-covid-monitor/, measured at a plant serving the 7-county metro area. They say: "New cases tend to lag wastewater detection trends by about 6-8 days."

Graph taken from here, selecting for "COVID-19 Load by Variant." https://metrotransitmn.shinyapps.io/metc-wastewater-covid-monitor/

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