Hex Reviews & Product Details

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 use Hex for writing text queries to access Snowflake and find it much easier that way. It makes it easy to visualize data and helps with sharing interactive dashboards with teammates. I really like the scheduling aspect, where it's like live updating. The shareability and interactivity of the output are great. Hex is special because it updates more frequently, and I can set a schedule for it to update. This allows stakeholders to explore the data on their own, making it more than just a static graph. Review collected by and hosted on G2.com.

I do find that the integration with AI tools is really lacking right now. For example, in order for me to use Claude to create a dashboard, I have to download a YAML file, modify it, teach Hex how to read the YAML file, and then reupload it. It's super inefficient and super terrible. Review collected by and hosted on G2.com.

I love Hex for analytics, exploration, and upskilling. It offers more customizations than other BI tools, providing more control over the output, which I really like. The AI agent in Hex is phenomenal and speeds up my workload by 10 times. I find the initial setup to be super easy. It integrates well with our data stack, including our warehouse and dbt. I've switched to using Hex as my dominant tool, and so far, I love the way everything works. I haven't gotten past the honeymoon phase yet. Review collected by and hosted on G2.com.

sometimes the SQL element is tricky - it defaults to duckdb sometimes and im not sure why, which isnt compatible with redshift, but ai agent resolves it swiftly Review collected by and hosted on G2.com.

I really appreciate the Hex Threads functionality, which allows me to bypass writing queries and instead use natural language to ask questions and spot-check the logic. This feature is super helpful as it simplifies getting data insights. I also like the AI tools and the capability to write SQL and Python in one file, which was a key reason for switching from our previous product. Review collected by and hosted on G2.com.

I find it challenging to make it easier and faster to build dashboards. It would be better if I could create dashboards by using natural languages more fluidly. Also, there are some learning curves involved. Review collected by and hosted on G2.com.

I love the tools in Hex, especially the ability to rename and use dataframes, and how everything is integrated. The 'publish app' feature is also great, making it easy to share with both internal and external consumers. Being able to reuse dataframes in multiple cells is a must-have for organization. The initial setup was straightforward and without any issues. Review collected by and hosted on G2.com.

Lately I've been having connection issues with longer notebooks. It starts to take a long time to get to the database, and it slows down the notebook as a whole. Sometimes a simple query takes too long, especially when the notebook is getting large. Review collected by and hosted on G2.com.

I really like how Hex integrates SQL, Python, and AI, as it helps us work faster and smarter across different workflows. Python is a powerful tool for both analysis and data visualization, making it possible to accomplish almost anything necessary. I appreciate being able to pull, clean, analyze, and display data in an exec-ready format, which speeds up the process to valuable insights. Review collected by and hosted on G2.com.

I think notebooks can become quite long and bloated, running for a while. A cleanup assistant, or a way to break the notebook into blocks that run would be cool. Yeah, making it easier to run sections, and having an agent help reduce sprawl would be great. Or one to suggest something that has been done in a similar use case in another project when you are prompting. Review collected by and hosted on G2.com.

I love the fact that Hex allows me to create apps that can be used either as reports for deep analysis or interactive tools for nontechnical partners to explore and find answers themselves. It's so interactive and easy to use, making it a unique feature of Hex. I appreciate how Hex makes it really easy to create tools for my cross-functional partners and interactive dashboards because I can flip between Python and SQL seamlessly. The amount of visualizations I can create is basically unlimited. I can do complex analyses and easily create reports to share without having to switch between different tools. Everything can be done in one place. Review collected by and hosted on G2.com.

There's a lot of confusion from our nontechnical partners who frequently request edit access when it's not what they need. The developer seat is very expensive, which makes the data engineering team clamp down on who has edit capabilities and revoke access from those who accidentally ask for the wrong thing. I also find the AI feature in Hex not very helpful. It struggles with fixing SQL bugs, often making incorrect changes and reformatting everything without making it clear what the initial bug was. I would also love to have the app's aesthetics more in line with our company brand. Review collected by and hosted on G2.com.

I use Hex to support my analytics engineering workflows and for dashboarding. I find it really easy to create and collaborate on reports, and it offers a plethora of options for charting with a lot of flexibility, which I love. The flexibility in charting options and the ease of going from SQL to chart to sharing are huge positives for me. Templating inside of the SQL blocks is also great. The notebook style and app builder experience are well constructed and fit my workflow and thought process really well. Review collected by and hosted on G2.com.

Nothing comes to mind. It's fantastic. Review collected by and hosted on G2.com.

I use Hex to analyze data for my work, and it has significantly sped up my process. Tasks that would normally take hours now only take minutes. I really appreciate how much data it has and how easy the threads are to use. The platform is intuitive as it anticipates the next questions I might ask. With all the data available, I don't have to query anything; I can simply ask in plain English, which makes my workflow much faster. Also, the setup was incredibly easy; I just logged in and everything was ready to go. Review collected by and hosted on G2.com.

I don't like that the data or analysis can be wrong at times. There have been multiple instances where I would ask it something like 'review this file and tell me how many lives X employer has,' and it gives me the wrong count. It seems to have issues reading data from CSV files accurately. Review collected by and hosted on G2.com.

HEX is super smooth and easy to use, both from a data analyst perspective and as a customer. In my every day use, I can build complex workflows without much complication by combining SQL and Python cells. Most visualizations are built in within HEX, and for anything that isn’t, I can rely on Python libraries to create what I need.

Organizing projects in HEX is also straightforward. We can set up different collections per client and adjust permissions so the right people have access. Scheduling and alerts are great as well, and HEX’s capacity to run complex queries is great.

Lastly, the HEX support team provides fast answers and guidance. Every time I've shared a project with them they have been able to give me an appropriate answer, which is much appreciated. Review collected by and hosted on G2.com.

We’ve had a couple of bad experiences with the customer team itself, where they stopped replying to emails even when we had urgent requests.

From a product perspective, HEX could benefit from including a few more built-in graph types, such as box plots, for example. It would also help to have more options to style graphs more easily, like the ability to show null values, remove or add labels in faceting, and allow multiple series in faceting. Review collected by and hosted on G2.com.