Hex Reviews & Product Details

- Semantic layer is very easy to use and model together with AI Agent, allows to make a solid ground for single source of truth when it comes to metrics - Impeccable Python notebooks development workflow - Really nice visuals Review collected by and hosted on G2.com.

On the slower end than most of BI tools when used for Business Intelligence workflows since apps work as a notebooks Review collected by and hosted on G2.com.

I like Hex because it's powerful for data analysis. I appreciate being able to create dashboards that show data based on user emails, allowing customization for each user. It solves the problem of having to rely on engineering since I can build what I need myself. I love that I can do more than just dashboards, including coding and using AI, which offers fantastic possibilities. Review collected by and hosted on G2.com.

I would use Hex fully if it were simple to create dashboards, as simple as Metabase for example. Review collected by and hosted on G2.com.

I love Hex's straightforward setup process, which involved no technical difficulties and was seamless, especially on the HIPAA stack. The real-time collaborative notebook view is invaluable for deep analytics, and the customizable publishable app view is perfect for sharing insights with the business. I find the seamless transition between SQL and Python, along with the capability to directly hook into our databases, to be the most powerful features, allowing me to easily share notebooks and build accessible apps. Review collected by and hosted on G2.com.

I think they're overdoing it on the AI stuff and forgetting that a lot of times you actually just want data visualizations. The current data visualization library is inferior to that of Tableau. I wish they would focus on enhancing the visualization library first before going crazy with AI features. They're releasing features at a very rapid rate, leading to frequent outages, especially during workdays. This has been pretty disruptive and things have been breaking pretty frequently along the way. Review collected by and hosted on G2.com.

Great interface for deep dives into issues. Review collected by and hosted on G2.com.

Some features not easily available via SQL and have to be converted to python which limits flexibility. Color palette is limiting. Review collected by and hosted on G2.com.

Flexibility and customization are strong points, and the analytics are powerful. I also appreciate the AI features, MCP, and the available integrations. Review collected by and hosted on G2.com.

It can be slow at times, and the interface and information architecture feel a bit complex to navigate, especially when I’m trying to figure out when to use projects versus threads versus explorations. Review collected by and hosted on G2.com.

Hex masterfully combines the capabilities of a top-tier BI tool, a SQL editor, and a Python notebook into a user-friendly yet robust platform. The latest AI agent features are truly impressive and are evolving quickly. As long as you grant Hex adequate access to your data model, you can significantly enhance your analytic abilities - some might even say it’s like gaining access to a highly efficient data analyst. Review collected by and hosted on G2.com.

Occasionally, there are intermittent service disruptions. Additionally, navigating within notebooks could be improved, as it's easy to get lost and end up scrolling through long sequences of cells. While some navigational features have been introduced, it would be helpful if drag-and-drop functionality were expanded to allow moving cells more easily within a notebook. Review collected by and hosted on G2.com.

Hex has an intuitive interface which allows you to learn and do more things than you thought you could. It also has an AI assistant that is very helpful when a mistake is made on your code or you forget about something, making it easier to work and do your day-by-day tasks. It also has an easy way to integrate with the databases, making it easier to consult the datawarehouse. Review collected by and hosted on G2.com.

It could be more dynamic when it comes to the design of dashboards. Sometimes I feel like I need the freedom to be more creative and the things that I have to work with are not quite what I am looking for. They are great, but limited creatively. Review collected by and hosted on G2.com.

Hex has an intuitive, user-friendly interface combined with the flexibility to switch effortlessly between SQL and Python. With Hex, I can quickly prototype queries in SQL to explore and aggregate data, then pivot to Python for more advanced transformations, data cleaning, or machine-learning workflows, all without leaving the same environment. Review collected by and hosted on G2.com.

What I find limiting about Hex is its predominantly linear dashboard layout, which can make it challenging to present data in the most impactful way for stakeholders. Because elements are arranged top-to-bottom, it’s harder to create more flexible, grid-based or story-driven layouts that guide viewers through key insights. Review collected by and hosted on G2.com.

I find Hex really user-friendly. I like the seamless connection to BigQuery, which makes integrating data from Databricks or BigQuery easy. I also appreciate the write-back function capability. The setup was pretty seamless, thanks to the support team at Hex, which ensures integration with us is smooth. Review collected by and hosted on G2.com.

I think one of the features that I would like to see Hex enhancing is the machine learning capability. For example, model registry, experiment feature store, and all these kinds of essential features for machine learning. Review collected by and hosted on G2.com.

I’ve been exploring Hex for over two weeks now, and it’s been full of great surprises. From importing data to using the SQL editor, Python, and chained SQL, to create charts the whole process has been smooth and easy to use.

I tried out Magic, and it’s by far the best technical AI assistance I’ve experienced — the results were about 95% accurate. Complex KPIs, period calculations, parameter handling, and input integration in SQL were solved without me having to write a single formula by myself. It was all Magic.

Publishing reports, managing versions through Git, or downloading them is very straightforward. Role-based access is also simple and clear.

Giving suggestions for project descriptions, project name, chart name, it was all magic to do magic.

One of my favorite features is Components — it makes building and reusing visuals incredibly efficient. Review collected by and hosted on G2.com.

One thing I’d love to see improved in Hex is having more chart options. Sometimes, the available visuals feel a bit limited, and having more variety would really help in presenting data in the best way.

Also, when it comes to tables and pivots, it would be great to have more control over formatting — like being able to bold or italicize text, add color to titles, and customize the look of subtotals and row level totals. I’d also love to see dynamic title changes based on parameters; it would make dashboards feel much more interactive and polished.

Another big one for me is the ability to change X-axis values dynamically in charts. That would give a lot more flexibility when working with different datasets or time ranges. Review collected by and hosted on G2.com.