Hex Reviews & Product Details

I work with dashboards and analyses using Hex, and I really appreciate how Hex Agent AI speeds up delivery significantly. It's super smart and has a lot of capabilities, allowing me to build whatever I want with very little need for corrections. The initial setup was super easy too, only needing access, with the DE team handling data ingestion. Overall, I'm very satisfied, given that I rated my likelihood to recommend Hex as a 10. Review collected by and hosted on G2.com.

I think Hex Agent AI could be improved by allowing it to look at existing notebooks outside the one I'm currently working on. Review collected by and hosted on G2.com.

The agent that helps optimise projects, with the added flexibility to use Python and Hex in the same project with minimal effort. Review collected by and hosted on G2.com.

The front-end presentation is harder to make look polished and presentable compared with other tools. Review collected by and hosted on G2.com.

- The core value prop: Able to write SQL / Python in the same notebook and generate local variables from external data sources / queries.

- Navigation is awesome

- Able to create externally-facing applications and visuals for use by other business users.

- The AI isn't terrible.

I use this every day. The team uses this every day. Good tool, powerful tool. Review collected by and hosted on G2.com.

- Data refreshes hard to understand, especially in the context of compute power, spend, etc. Feel like in some ways it's forcing refreshes / re-runs too often, driving increased spend for no reason.

- Cached data sometimes creates hallucinations.

- Inability to reference external data connections with in-notebook variables simultaneously.

- Little bit non-intuitive for charts in terms of config.

- Some bugs, e.g. take over session from someone sometimes get locked up.

- Autocomplete isn't super robust. Review collected by and hosted on G2.com.

Cloud notebook: Hex is a great improvement upon an open-source cloud data notebook solution like Jupyter Lab, because it takes care of all of the DevOps in the background, has a solid role-based data access functionality, supports flexibly switching between SQL and Python code when working with the same data frame.

DWH Connection: Snowflake connection works like a charm and allows to quickly check the schemas and metadata of every DWH table

Dashboards: Adding user inputs and making dashboards is a breeze. Data viz and dashboarding flexibility is better than in Databricks.

AI: And on top of it, it's built-in AI functionality helps write analytical code much faster. Review collected by and hosted on G2.com.

- It does not have a robust folder structure, only single-level "Collections", which means that in a larger organization, information organization will be a problem.

- Instead of integrating with Github, it implements it own version control system which is not super transparent to use Review collected by and hosted on G2.com.

I really like how Hex allows me to get engineering efficiency data without having to write SQL, making me more effective in getting the data. I also appreciate the ability to publish apps, which lets other people see my research. Review collected by and hosted on G2.com.

The transition from notebook to app is not perfect. It's hard to organize blocks and move them around. Review collected by and hosted on G2.com.

I really appreciate Hex for its simplicity and high level of customization, which makes it stand out from other complex and expensive tools like Tableau. The integration process with Hex was incredibly easy and went smoothly, enhancing its usability right from the start. It serves excellently as a reporting tool living on top of our data warehouse, providing us with robust capabilities to visualize and automate SQL queries, which can be easily shared with stakeholders. I find the workbooks in Hex to be extremely user-friendly and versatile, supporting transitions from SQL to Python effortlessly, which allows for reusing larger and more expensive queries by converting them into dataframes. These features make Hex much more sophisticated than typical business intelligence software, improving our workflow significantly. Additionally, Hex integrates well with Big Query, which is a critical aspect of our data management. Overall, Hex reflects a sophistication in design, capability, and functionality that keeps me satisfied and willing to continue using it. Review collected by and hosted on G2.com.

I would like to see improvements in R integrations. Review collected by and hosted on G2.com.

I like the design of the Hex product, which makes the interaction visually pleasing and intuitive. Additionally, the data loading performance is excellent, allowing for quick analysis without delays. The initial setup of Hex was very fast and easy, facilitated by the notebook view, which made the transition and adaptation to the system super smooth. The advanced technology of Hex was one of the main reasons for replacing PowerBI, which shows its superiority in features and innovation. Review collected by and hosted on G2.com.

I believe that the integrations could be improved, especially those related to Google. It would be beneficial to have direct connections with Google's APIs. Review collected by and hosted on G2.com.

I find Hex easy to use, conversational, and efficient. It saves me time by allowing me to easily get information from our database, which used to require creating reports, filters, and translating data. Review collected by and hosted on G2.com.

I find Hex unstable sometimes, and the Slack integration can fail. Review collected by and hosted on G2.com.

1. Integrates data from various different sources seemlessly

2. SQL type of coding across different data

3. Easy to use scripting languages along Review collected by and hosted on G2.com.

Some basic features like for example inability to set a Max or Min in Date picker input

Graphs can be more presentable Review collected by and hosted on G2.com.

Hex’s most significant accomplishment is its ability to democratize data analysis. It’s incredibly easy to use, with a clean and intuitive interface that makes it a pleasure to work in. The platform allows anyone in our organization who is comfortable with SQL, Python, or R to connect to our data, perform their own analysis, and share their findings. This has all but deprecated our old, rigid BI reporting processes. Reporting was a bottleneck. It required highly technical, tool-specific knowledge that few people possessed. Now a much larger portion of the company can build reports and data apps.

The collaborative nature of Hex is a core strength. We can easily share notebooks with colleagues, work together in real time, and leave comments, fostering a truly collaborative data culture. The ability to take a completed analysis and publish it as a light-weight, interactive data app is a feature we rely on daily. These apps allow non-technical users across the organization to filter, explore, and interact with the data directly, without needing to understand the underlying code. This has empowered every department to be more data-driven in their decision-making.

Finally, the platform feels forward-thinking and modern. The AI-native features, particularly "Hex magic," are great, helping us to be more efficient and productive with our work. Review collected by and hosted on G2.com.

While we are overwhelmingly positive about Hex, there are a few areas where we believe the platform could grow. The primary challenge we face is organization, both within individual notebooks and across our entire body of work. As our content has grown, it’s become easy to get lost in a sea of notebooks. While the tag-based system helps, it requires a level of intentionality from every user that is difficult to enforce at scale. A more robust, folder-like structure would be a welcome addition to help us better organize projects and departments.

We appreciate the existing Git integration for backing up notebooks, but we would love to see a more integrated workspace system that could mirror a Git repository's structure. This would provide a more scalable and familiar way for technical users to manage version control and project organization, ultimately making it easier to maintain a clean and structured environment for everyone. Review collected by and hosted on G2.com.