Hex Reviews & Product Details

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.

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.

Very intuitive to use. Reports can be super quick to spin up.

We find it great for sharing insights across an entire team (unlimited viewer licences is a huge plus for us).

The support has been excellent, both super responsive and helpful. Review collected by and hosted on G2.com.

Only suggestion is that some expansion to the chart options would be useful. Heat maps or charts which can graph dynamic/input variables would be particularly useful for us. (I don't find using Python to implement these looks as polished as the inbuilt charts). Review collected by and hosted on G2.com.

I love the AI agent built into Hex. The agent is accurate and is trained to automatically update and requery tables as needed. It allows me to find which tables in the database I need, automatically query hundreds of thousands of results quickly, provide concise analysis through its AI, and quickly create tables and charts through simple prompting. The AI agent has allowed me to ask questions about the data and get an understanding of data structures prior to writing any SQL queries. It shows its work by recording the chat transcript and each SQL query and table of results that it creates with every iterative prompt. Also, it was very easy to get started when I created my account. Review collected by and hosted on G2.com.

There could be a way to preview data better. With the amount of data that my company has and with how the data in those tables has changed over time, it would be helpful to preview recent results instead of a snapshot of the oldest records. I would like a date filter for the preview on the data table, or searching for individual record fields in the data preview to see if the table has the item I am looking for. Review collected by and hosted on G2.com.

I appreciate how easy it is to create custom reports and analyses, ranging from simple descriptive statistics to more advanced analytics. As a data developer at my company—combining aspects of both data engineering and analysis—I really enjoy coding in notebooks. We use BigQuery as our datawarehouse so the integration was so easy. Additionally, since I serve as the admin for our Hex account, I find the platform’s user-friendly interface for management to be a major advantage. I’d also like to mention that whenever I’ve needed support, whether for questions or to resolve bugs, customer support has always provided helpful answers or solutions. Review collected by and hosted on G2.com.

As a developer, I can't say that there's anything I currently dislike about Hex. However, from an admin perspective, I wish there were more detailed statistics available about users and their interactions with the platform. At the moment, I can only access limited information, such as users' most recent views, but I don't have a comprehensive overview of the entire user experience within this tool. Review collected by and hosted on G2.com.

It's very straightforward to start writing analyses, and to host them on the internet for others to see. The provided interactive elements also make it possible to write dashboards to help automate simple business processes that require human input. This part of the review is short and sweet because, for suitable use cases, Hex is very powerful and intuitive! Review collected by and hosted on G2.com.

This is more of a business process issue than a Hex issue, but here goes: It is important to scope out your project before starting with Hex. Once the number of cells in a project begins to swell (~70+ cells), the optimizations for notebook visuals become an editing problem. Ctrl-F will fail to take you to the correct cell, and trying to scroll up or down through the notebook becomes very sluggish as every cell you scroll over takes time to load, as they are unloaded once they are far enough away from the viewport. I cannot find a good workaround for this issue. Additionally, there is no multiline find-and-select, which can make refactoring code an enormous pain, especially when coupled with the notebook size issue. Review collected by and hosted on G2.com.