[CRConrad]

> ...we were familiar with a type of tool called "semantic layers." Think of them like an ORM for analytics. Basically, they sit between databases (or data warehouses) and data consumers (data viz tools like Tableau or APIs) and map real-world concepts (entities like "customers" and metrics like "sales") to database tables

Then, frankly, your data warehouse design sucks. (Like, bowling balls through a garden hose.) The whole point of data warehouses is that the fact and dimension semantics are mapped to real-world business concepts in the first place.

And yeah, don't you know anything about software development -- how the heck could you think the name "Delphi" wasn't in use already?