LLMs are getting exceptionally good at interpreting vague asks.
Do I trust a non-developer to build a production software system? No.
Do I think they can control Excel spreadsheets, PPTs, and other productivity tools through MCP? Absolutely.
One of the biggest issues I've seen in this kind of environment is that there are 50 dashboards, created by different people, and the data presented on them hasn't been validated to ensure that the data is correct and pulling from the same location. It's not clear that the data can be trusted and it's not clear what the authoritative source of truth is.
IE. They know what they're looking for. They know when the data is right or wrong because they've seen it from other places here and there over time.
When they're not sure and the risk of getting it wrong is costly, they'll find the data analyst to verify.