We are heavy Hex users at OpenRouter. I was skeptical that it would replace "core" reporting tools like Looker, but the efficacy of the Hex agent has made it our go-to for just about all of our analytics, and allowed us to get incredibly far with a single (very good) person on the data team.

We can make completely reproducible reporting when we need it (for e.g. our weekly business reviews), while the agent can answer all of the ad-hoc stuff that would normally be done by a small army of analysts scurrying around.