Data Team is overwhelmed with ad-hoc queries from business users.
Every slight change to the report format, Business Users cannot change themselves and have to ask Data Team for help.
Business users perform adhoc data exploration without writing SQL or bothering Data Team. Data Team just needs to maintain central business logic layer.
With reduced adhoc data requests for Data Team, they can focus on more complex data analyses.
Multiple different SQL definitions of the same business logic across entire system.
When some field changes, you need to go through all the reports and manually change them one by one.
When some business logic changes, Data Team only needs to update once, and the change will be reflected across all related reports AUTOMATICALLY.
Different reports might give different values for the same metric.
Business Users confused and stop trusting the data, keep coming back to Data Team to verify.
Since metric is defined once, all reports should give the same value for the same metric.