Hex Reviews & Product Details

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.

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

I love the downfall cell update logic and how you can access upstream cells easily. The separation of the App Logic and Notebook parts helps to show exactly what we want to present. It combines freedom in data querying and visualization with the ability to present things neatly. I also enjoy being able to query easily and be quite 'drafty' with my querying, while still presenting something clean to stakeholders. Also, being able to pull out a viz in a few minutes is really nice Review collected by and hosted on G2.com.

I've been having python version problems lately, and I can only do up to 3/4 nested sections in the Notebook, and I would like to be able to create more. Review collected by and hosted on G2.com.

I like Hex for its AI feature, which helps me keep progressing by identifying what breaks my queries. It can test join keys, figure out where my script is wrong, and even help me write an entire query when I explain what I need. I also appreciate the ability to bring multiple data sets together from different places and review them in various ways. Review collected by and hosted on G2.com.

I find it challenging to easily identify join keys in the exploration tab. While you can click through two data lakes, I wish the AI could help identify matches to other data tables or data lakes. Additionally, I wish that Hex would let me separate my notebook into separate tabs, similar to how the front-facing app is separated. I don't like when my notebook scrolls for so long and wish I could toggle between tabs. Review collected by and hosted on G2.com.

I like Hex mostly for its interface, which makes it easy to create queries using different codes like SQL and Python. This allows us to access data from different sources efficiently. It's helpful to have everything in one place, especially since we deal with multiple sources of information that need different processing and SQL languages. The integration with Google Forms and other tools is also very helpful. Review collected by and hosted on G2.com.

Hex is very slow, which is a big downside. I also have issues with cache not refreshing as expected, especially with large projects, and it takes a long time to refresh. There are limitations on tables, particularly with conditional formatting, as it can only be applied based on the value of the specific column, rather than referencing a different column or using a formula for more dynamic functionality. Review collected by and hosted on G2.com.

It is so easy to combine SQL with Python! I love how accessible it is to call variables created in different cells. The charts and pivot tables tools also work great and are very intuitive. Review collected by and hosted on G2.com.

This is probably related with my subscription tier, but I cannot work with tables with millions of rows, so I need to reduce my datasets early in the projects, which may be a bit limiting sometimes. Review collected by and hosted on G2.com.

I use Hex for understanding revenue, costs, capacity use, and reliability of our infrastructure. I appreciate how it makes it way easier to get visibility into what's going on and to share insights between technical and non-technical parties. It's like a lingua franca for working with finance. I really like the ease of integration with BigQuery and the overall look and feel of the dashboards it creates. It's easier for me to use Hex to query BigQuery than using BigQuery's own UIs. The initial setup of Hex was also very easy. Review collected by and hosted on G2.com.

There are a few things: 1. The autocomplete is still really bad for Python. 2. Better inline views of tables, etc to guide me in creating queries. 3. I'd love to have some more chart types to play with. 4. There should be better support for blending different time series into the same plot without creating additional dataframes and hacking it the hard way. For example, blending a revenue query with a cost query is actually kind of hard. Review collected by and hosted on G2.com.

I like the organization of the notebook in Hex, clean and tidy thanks to the ability to rename everything, and I find it easy to update using the search tool. I appreciate the ability to comment, which allows me to ask for feedback on charts directly. I find the integrated AI very useful for solving errors by providing context, for performing extractions with great accuracy and Python code. Additionally, the ability to give personalized instructions is an advantage, as Hex is able to correctly filter the various tables based on the requests made. Review collected by and hosted on G2.com.

The default charts of Hex are limited and lack important features. They are not very interactive once published in a dashboard, and the axis names cannot be parameterized with input. The collections function is unclear and lacks a system of folders and subfolders, making it difficult for stakeholders to find the dashboards and analyses of their interest. The settings for publishing a notebook are unclear regarding the use of the cache. The graph mode of the notebook is interesting but currently confusing and does not help in understanding the organization. Review collected by and hosted on G2.com.