Weather data is easy to buy. Making it usable takes a quarter. Your sales are weekly by store, the feed is hourly by station, the nearest station is eleven miles from the store, and the two tables share no key.
Every join is a decision. Which station represents this site. How hourly readings roll up to a fiscal week. Which region a national indicator belongs to. Made in a notebook, those decisions stay in that notebook, and the next team makes them again.
RootCause maintains these sources and resolves them against your ontology on entity, time and location. Station to site. Hourly to weekly. Country to region. Ticker to supplier.
Alignment happens once, centrally, and every later analysis inherits it.