I use Hex to support my analytics engineering workflows and for dashboarding. I find it really easy to create and collaborate on reports, and it offers a plethora of options for charting with a lot of flexibility, which I love. The flexibility in charting options and the ease of going from SQL to chart to sharing are huge positives for me. Templating inside of the SQL blocks is also great. The notebook style and app builder experience are well constructed and fit my workflow and thought process really well.

I love how hex allows for both complex data analysis leveraging tools like R and python to do linear regression and stuff like a traditional jupyter notebook or Rstudio, but also for the creation of dashboards for less technical stakeholders. I use it pretty much every day, especially the Threads agent, to just ask little questions that don't deserve a full analysis. Probably one of my favorite things is that I can go back and audit the code, unlike a traditional AI tool. I found it really easy to integrate with snowflake, and I've just loved all my interactions with the company.

Flexibility and customization are strong points, and the analytics are powerful. I also appreciate the AI features, MCP, and the available integrations.