Hex treats analysis as something the team owns
In Hex, the unit of work is a project that several people can open, edit, and rerun. Analysts mix SQL and Python cells against the warehouse, Hex Magic drafts queries and code or fixes a broken cell, and the finished project can run on a schedule or be published as an app with charts and inputs for stakeholders. Version history and project structure mean the logic behind last quarter's churn analysis is still there when someone asks for it again.
That persistence is the main reason a data team picks Hex over a chat tool. The cost is that someone has to write and maintain the code, so the people asking questions usually wait for the people who build notebooks.