Advice and professional development online feels like its geared towards one-time ad-hoc projects. Any resources on managing data on a recurring, organizational basis?

So many of the youtube videos, courses, advice, etc., online feels it's geared towards running singular projects. How to clean up data in a Excel spreadsheet for a onetime project, for example, but what about when its for an analysis you have to keep running over and over? Or when it's an analysis that is repeated across several teams in slightly different ways? I need advice about managing data for an organization. Advice about: how to communicate with stakeholders about data without getting overly detailed requirements gathering across teams with confusing/vague needs dealing with a system t