Hex Reviews & Product Details

Recent AI capabilities are amazing, and I’ve been using them a lot. When I’m writing SQL queries, I especially like the autocomplete features—they make my work faster and help me write more accurately. I also like the data schema explorer when I need to find specific tables, and it’s helpful for quickly exploring their contents. Review collected by and hosted on G2.com.

Notebooks can quickly get messy once you start creating a lot of cells in the same notebook, and it’s easy to lose your place while scrolling to find the cell you’re looking for. I’m not fully convinced by this Notebook and App partitioning, because it feels clunky and confusing in practice. For example, when you’re working with tabs, it’s hard to tell in the Notebook which cells are associated with which tabs. I also found it strange that the order of cells shown in the App is different from the order in which they appear in the Notebook. Finally, I’d like you to offer a native way to push data to a Google Spreadsheet, since that currently isn’t possible. Review collected by and hosted on G2.com.

I really appreciate Hex for making data analysis and dashboard creation much easier. Normally, I'd have to hire a data scientist, and it would take them a long time to complete the work and make it presentable; now I can do it all on my own. I especially like its AI agent; it's incredibly capable. I can simply tell it what I want in plain language, and while I have to guide it, it manages to find the data, transform it, and make it presentable. It's also been easy to learn, even though I didn't set up the initial software. Review collected by and hosted on G2.com.

I would like the agent to have a few different modes - like "fast" or "thinking" etc. Review collected by and hosted on G2.com.

I use Hex for all my analytics, and it really speeds up my work. What used to take me two or three days can now be done in about half a day. I think the AI agent in Hex is really good for doing a lot of analytics and helps generate insights for stakeholders. I also like the guides part where you can set up the context and business logics of your company/data, making it really easy for the AI to understand the context. Setting up Hex didn't even need to create semantic models; you just provide a database and a little context, and it figures out what to do. Review collected by and hosted on G2.com.

I think the Hex apps could be a little more efficient, especially in how AI accesses data from apps. It would be helpful if cached data could be utilized instead of running the warehouse query again and again. This would save a lot of time, especially when using the thread feature. Review collected by and hosted on G2.com.

Chaining SQL and combining SQL and Python seamlessly Review collected by and hosted on G2.com.

Slow load times (largely due to inability to quickly run parallel queries against warehouse) and lacking sharing/app permission options. We get a lot of complaints about slow load times, which drives people to use Looker Studio instead. In terms of sharing, it's very difficult to share a dashboard with a wide audience because with link sharing turned on, everyone in the workspace is then able to find the project. We want password protected links and also the ability to turn on link sharing without the entire workspace being able to easily find a dashboard. Review collected by and hosted on G2.com.

I love how Hex lets me conduct my entire analytical workflow within one system. The HexMagic feature is super helpful for fixing code quickly, and its natural language processing capabilities make ad hoc querying a breeze. I appreciate the AI assistant which aids in exploratory data analysis by examining different subpopulations over time scales. I can easily iterate on strategies, generate charts, and automate dashboard updates, all of which save me from manually pulling and sifting through data. I find the integration with metadata really strong, which enhances searchability and allows me to work more efficiently. Additionally, I love the setup where threads can use the history of other threads, making it a neat system. It's incredibly intuitive, helpful, and constantly improving, which makes me rate it a 10 out of 10. Review collected by and hosted on G2.com.

I'd like some more opportunities for some sort of calculated fields within the charts or some additional ability to do weighted averages. It's a little bit difficult to do that with the inbuilt charts. We want to look at something like balanced weighted APR, which is quite difficult to do split across things in the current Hex charts. Also, some nontechnical users use HexMagic outputs as a source of truth. As good as HexMagic is, it does make some assumptions and sometimes errors. It would be helpful, as a Hex admin, to be able to designate certain user groups and edit the workspace rules for subgroups of users to ensure they challenge the AI outputs more and have a more restricted knowledge base. This would help in making sure the outputs are true. Review collected by and hosted on G2.com.

I like that Hex allows me to get results the same day without needing SQL knowledge. It's fantastic for importing complex equations like Erlang C with our existing data mart. The ability to create quick and easy charts for last-minute requests is also really useful. Hex saves me hours by pulling data, gathering it into relevant spaces, and running formulas. I was able to complete a very time-sensitive project request with this tool, and I don't think I could have done it without Hex. Review collected by and hosted on G2.com.

I'd like to be able to copy prompts from thread to thread. Another great feature would be if I could create my own personal glossary of terms unique to my user name. I find myself keeping a file of definitions to use in prompts. Having a user-generated dictionary that could be shared with other non-coding managers would help with barrier to entry and I believe greater usage in our operations department. It took a few weeks to figure it out. Review collected by and hosted on G2.com.

I use Hex for building intensive data applications and AI implementation. I like how easy it is to start building, as it's really just about connecting to the data and starting. Everything is web-based, which is convenient. Hex is better than any other BI tool at analysis, letting data driven people like me generate insights for the business. I appreciate that it allows me to choose the best way of computing, whether I need to use Python or SQL, making it an all-in-one platform. Threads and the AI capabilities are the best I've seen from any competitors, allowing business users to dive deep without disturbing the analytics team. Being able to ask any question and get a natural language response back that is typically accurate is super important. Review collected by and hosted on G2.com.

Hex could improve their visualizations to be more on par with their competitors. They are not as advanced. Python is an option but tough to justify for a small use case. Review collected by and hosted on G2.com.

I really like the HEX generative AI agent; it's the feature I enjoy most. It's incredibly helpful for getting research started, writing code accurately, and synthesizing findings without much hallucination. Additionally, the integration process was very easy and gradual, with HEX making it simple to use CSV files directly out of the box. The threads feature is particularly useful for speaking in natural language, and HEX performs a lot of the analysis automatically without needing much intervention. It has great self-healing properties, too, like fixing code issues easily through the AI agent. I find it valuable to chat with the HEX AI agent, which helps explain results and their ramifications in simple terms, aiding in synthesizing research questions and analyzing data effectively. Review collected by and hosted on G2.com.

I think Hex is still figuring out the enterprise use case in general. I tried to use Hex's semantic features, but even though it was supposed to be in my plan, I was not able to access it until very recently. So I think, in terms of the admin panel or the platform itself, there might be some issues here and there. However, I think the team is very responsive whenever you do have a problem. I've noticed that it's very difficult to export from Hex. I wish there was a cleaner way to export the data files from Hex. Review collected by and hosted on G2.com.

Hex is part of my daily workflow at Mentimeter. It gives me immediate access to the data I need without having to rely on others, which is critical in a fast-paced environment.

I use it to stay on top of dashboards and key metrics, and I’ve built multiple dashboards myself for different use cases—from QBR preparation to daily team meetings and stand-ups. The ability to quickly pull relevant data and turn it into something actionable has made a big difference in how we operate as a team.

What stands out is how easy it is to go from raw data to insights. It’s not just a reporting tool—it enables data exploration and storytelling in a way that’s accessible even outside of traditional data teams. Review collected by and hosted on G2.com.

Hex is very strong on data access and flexibility, but the visualisation layer is not as polished as dedicated BI tools. For more advanced or highly designed dashboards, you may still need to complement it with other tools. Review collected by and hosted on G2.com.

I find Hex super useful for a lot of data movement and Python clustering. It's also great for structuring conversational data and serves as an excellent data modeling platform, much like a live Jupyter Notebook. This setup works well for ad hoc analysis. The embedded LLM is quite useful too, as it allows live querying and chatting within the system to the database, which I find really beneficial. Having everything in one platform is quite useful, especially compared to using Cortex in Snowflake or switching back to a Jupyter notebook. Review collected by and hosted on G2.com.

The specific issue I have is the LLM is overprescriptive, and so it will provide changes to the actual data that I'm working on without explicit instructions not to. Additionally, when you work in it as, like, an extensive way to do analysis, it errors out all the time. I think it's significantly overcomplicated with some of the other work done. And it is actually it's significantly worse than I find at other platforms. Review collected by and hosted on G2.com.