Hex Reviews & Product Details

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 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.

Incredibly useful and intuitive AI data science agent. It makes data science feel like magic - am i am someone that is very data-inclined. Makes unlocking business / data insights so fast / easy and FUN! Review collected by and hosted on G2.com.

Honestly, not much. Some of the features feel a bit redundant to me. For example, what’s really the difference or intended use case between “Explore” and a “Project”? I feel like I always end up using a project, but maybe I’m just not aware of the benefits of Explore. Similarly, “Chat with App” versus “Chat with agent in project” seems like the same thing—at least from my perspective. I’m also not sure what “Threads” are, or what “Collections” are supposed to be used for. Maybe I’m just not trained enough yet, but overall these options come across as overlapping with what I’d expect from a generic notebook, which is the workhorse for me. Review collected by and hosted on G2.com.

What I like most about Hex is how seamlessly it combines SQL, Python, and visualization in a single collaborative environment. It’s very intuitive to use, and collaboration features (shared projects, comments, and version history) make it easy to work cross-functionally. Review collected by and hosted on G2.com.

One downside is that performance can occasionally lag with very large datasets or complex notebooks, especially when multiple queries are chained together. Review collected by and hosted on G2.com.

I think the easy onboarding is really great. Hex is very straightforward with a very clean UI. The best part is that it has the AI assistant by itself, so you can just use natural language to talk to it and figure out how to use it. I was able to figure out the features by myself without much searching around or asking around to understand the features. The initial setup is super easy and very seamless. There's nothing to configure; you can just start using it and get the benefits and keep the momentum. I really enjoy the onboarding and the learning curve, which is not super deep. Without any configuration or setup, I'm already able to talk with it and have meaningful interactions and insights. This is great. Review collected by and hosted on G2.com.

Sometimes, the tool does not understand the tables, probably because we don't have the domain context or the semantic layer built in our database. This often requires modification and rerunning of queries, which feels like it's wasting time. Also, when talking to the AI assistant, it doesn't constantly check with me, which might save time, but sometimes leads to invalid results if certain queries or filters are missed and everything needs to be rerun. Review collected by and hosted on G2.com.

I find Hex's AI functionality to be better than comparable tools. I also appreciate the functionality that supports the AI, such as integrating with dbt .yml to grab descriptions and the ability to mark particular resources as higher or lower precedence for the agent. This combination leads to better AI outcomes. Additionally, I found Hex agent to be better than SimplyPut, the previous tool we used. Review collected by and hosted on G2.com.

I think importing dbt's analyses as 'verified questions' could be of use, as it's one thing to have AI know the dbt model metadata, but another to have it reference queries to answer specific questions. Additionally, it doesn't support a 'workflow' style of work, which usually leaves it standalone for my use cases. Using the agent via Slack would be better if we could have conversations from Slack itself instead of entering the tool, as Slack is more one-shot currently. Review collected by and hosted on G2.com.

Work together with our team on data projects, and using data to find useful answers without complexity. Review collected by and hosted on G2.com.

Rerunning all cells can make the app slow because of how it's designed. When working with long code, it's harder to use than a regular code editor. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

The Data Modeling suite is a bit rough (though it is in beta). What's particularly weird, is that I've had lots of issues where I will explicitly tell the AI where the data is located, and it still takes like 4 or 5 tries to actually find the data, the data model helps a lot with this, but it doesn't solve the underlying issue, and in-fact has made it worse in some scenarios, as the Data Model Validator does not check for ambiguous labels. Review collected by and hosted on G2.com.

I like the AI feature a lot. And also the flexibility to use SQL and Python in one shared notebook. The interface is very convenient. Compared to some other tools for SQL querying and dashboarding, I found Hex to be pretty intuitive with a linear user flow, scrolling up to down rather than switching between different tabs for SQL and Python, which is more convenient. I also find the embedding to Notion helpful for sharing or embedding live charts and dashboard into documentation. The initial setup was pretty easy. Review collected by and hosted on G2.com.

I think the AI feature can have more potential to learn from existing contacts and some better guidance that we can provide. Another thing might be making the shape of the notebook to have bigger RAM and faster speed. Those would be some quality of life improvements. But nothing major though. Still okay. Review collected by and hosted on G2.com.