Hex Reviews & Product Details

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.

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.

I love how Hex's AI agent keeps improving with every release, really empowering my job through brainstorming, code building for SQL or Python, and general debugging. It's pretty smart and handles notebook cells, such as deletion, creation, input, and filters, effectively builds apps on its own, and significantly speeds up the delivery of data apps. I use Hex for data analytics, developing data apps, sharing notebooks with colleagues, and cooperating with fellow data analysts. The integration with Slack for notifications and the ability to attach graphs in Notion smartpapers are also valuable. Review collected by and hosted on G2.com.

I don't like the repetitive clicks for formatting metrics and repetitive specifications to prompt the AI agent. Also, the repetitive cell creations just for adding text in the app builder are tedious. The notification system should be more flexible about the conditions to trigger alerts, not limited to when a dataframe reaches a certain amount of rows. Initially, using Kjingas grammar for dynamic filters was not straightforward, and it was unclear how to feed SQL codes stored in strings from other dataframes. Review collected by and hosted on G2.com.

I use Hex for executing data science and analytics tasks, like creating internal-facing dashboards and running ETL processes. I find it very easy to access Snowflake data and like the ability to switch between SQL and Python to complete complex tasks. Creating dashboards is particularly simple, and I love the ease of creating parameterized workflows. My two favorite features are the ease of dashboard creation and the fantastic AI tool. The AI tool stands out because it views the entire codebase, understands what I'm trying to accomplish, and does a great job of writing its own code or fixing errors. Setting up Hex was very easy, which is one of my favorite parts because it makes sharing notebooks and components with my teammates super easy. I can also see the source code for dashboards very easily, which I really enjoy. Review collected by and hosted on G2.com.

I feel there is a data engineering component that could be improved. I would LOVE to see an ability to run workflows that save files into a Hex filesystem that would make files accessible across other projects. One thing I've been struggling with is using components that involve complex queries in dashboards with live filters because by making one change it re-executes the entire component. Ideally, I'd like to have some workflows that run the component code daily, save out a CSV file, then my dashboard accesses that CSV file so it doesn't waste compute and improve dashboard speed and end user experience. It's not easy for data scientists to get access to Snowflake to create temporary tables, so having some kind of HDFS setup would be great to allow us to easily quick and dirty save out files for re-use within Hex or download for using in other setups. Review collected by and hosted on G2.com.

I like that Hex is generally pretty easy to use and rerun once I make updates to previously generated sections of a dashboard. The things that I know how to do with Hex are pretty intuitive. Review collected by and hosted on G2.com.

There are some things that just don't feel super intuitive. I wish it was easier to just query from something that I utilize quite frequently. Finding things within a similar structure or source could be a huge improvement because oftentimes, I find it hard to just do basic things that I do all the time. You have to create the right kind of module or query from the right data source. Review collected by and hosted on G2.com.

I like that Hex gives you everything in one place: data connection & exploration, code editor, AI agent, ability to publish apps, and schedule runs. Plus, it seems like every time I wish Hex fixed something or added support for a new feature, it gets done before I even asked them to do it. Hex moves fast with their product innovation! I also like the Google Drive connection interface. This has been handy when building internal tools that need to write output to somewhere that non-technical users can access. I also like the customer support chat. Review collected by and hosted on G2.com.

The Slack integration for the Hex agent doesn't yet have enough controls for our organization because we need to manage data privacy and restrict who can read the results of different queries based on what region they are in. Because of this, we continue to use a tool our team built internally for our own data Slack bot instead of the new Hex one. We have also explored Hex's embedded analytics offerings but found that it's not quite mature enough for our requirements. Hex's embedded analytics bills per API call instead of per unique user, which is very expensive based on our setup where a user may need to access many different reports, and most other embedded analytics vendors are billing per distinct user per month. Also, the permissions and sharing controls are not as mature. Review collected by and hosted on G2.com.