I appreciate Hex for its ability to seamlessly integrate both Python and SQL in a single interface, allowing me to efficiently analyze and visualize sports analytics data. The platform's support for Python libraries enables me to perform complex visualizations while also refining SQL queries, ensuring efficient performance. I value how Hex empowers me to conduct advanced data analysis, which was a significant reason for switching from Power BI. The advanced capabilities offered by Hex are useful for executing complex analytics and visualizations, providing a robust solution for my analytical needs. Review collected by and hosted on G2.com.

I find Hex to be highly reliant on users having coding abilities, which can be a barrier for those who do not code. This reliance makes even basic visualizations somewhat limited if you're using no-code options. Review collected by and hosted on G2.com.

I really appreciate Hex for its ease of use, from writing queries to creating quick visualizations. The process is so efficient that it significantly reduces the time to create something useful, especially compared to other tools like PowerBI. Additionally, Hex's AI agent has been a substantial boost to my productivity, benefiting both technical and non-technical users. Setting up Hex was very easy, which made the transition smooth and hassle-free. Overall, the ability to complement our workflows with such a powerful tool makes Hex an indispensable part of our analytical process. Review collected by and hosted on G2.com.

A significant blocker for us to fully use dashboards in Hex is the lack of a robust scheduling feature. While it technically exists, I've encountered multiple times at multiple companies that scheduled runs get into a frozen state. The scheduled runs start to pile up and crash Hex giving us an error that we're out of capacity of our kernel usage. The only way to fix this is contact Hex support to clean it up on the backend which has taken multiple days of downtime. Review collected by and hosted on G2.com.

I enjoy the dashboard. very informative Review collected by and hosted on G2.com.

Would like a statement balance of what needs to be paid. I would like to match to our payables. Review collected by and hosted on G2.com.

The best thing about Hex is honestly how it combines SQL and Python in a really smooth, cell-based way. I love that you can break down long SQL queries into smaller CTEs, run them step by step, and actually see what’s happening at each stage. Makes debugging and collaborating way easier compared to writing one giant query in Snowflake. Also love how you can quickly switch to Python when needed and then use the magic cell to pivot or make a chart. It just feels way more natural for analysis. Review collected by and hosted on G2.com.

I’d say the charting options could be more powerful. A lot of times I still have to go back into Python to build visualizations that I can’t do natively in Hex. Not a huge deal, but would be nice if that was stronger. Another thing is that Hex doesn’t really “understand” our database schema - like if there was some way to feed it a model schema and get smarter code suggestions, that’d be a game changer. Right now Snowflake feels a little ahead on that front. Review collected by and hosted on G2.com.

I use Hex daily to seamlessly work with data from multiple sources and APIs, consolidating them to answer business and industry questions effectively. It's easy to use and powerful, allowing me to build custom apps and automations effortlessly. I love how I can easily share my notebooks as projects with others, fostering collaboration. The AI features are incredibly helpful for completing queries and writing code, making my tasks more manageable. I run my notebooks on a schedule and send Slack messages with the latest numbers, ensuring my team stays informed. Hex's integration with tools like Google Drive for backups and API services for exporting and processing data adds significant value, enhancing data handling and communication. The ongoing releases by Hex's team consistently add small features that simplify my workflow, such as copying chart styles and enhancing chart functionalities. I've found the initial setup of Hex extremely easy, having done it multiple times for different teams. It's a product that I've introduced to many, who have also come to love it for its efficiency and capabilities. Review collected by and hosted on G2.com.

Sometimes it's hard to rearrange my cells when I have a lot of them, which would be great to improve that UX. Review collected by and hosted on G2.com.

I really like how Hex makes it easy to handle the tables I need for building SQL and Python cells with just a prompt. The magic AI feature of Hex is incredibly valuable as it assists me in writing SQL queries, even when I'm unsure about the exact table or columns that contain the data I'm looking for. It breaks down complex queries into manageable chunks for me. Additionally, Hex helps me with CSS, HTML, and JS for my iterative charts, which end up looking quite impressive. Review collected by and hosted on G2.com.

Hex has a limitation when it comes to the size of data it can handle, with a cap at 10mb for data rendering. This is problematic for me as I often need to load historical data up to 50mb, making it impossible to visualize such datasets due to this restriction. Additionally, the ability to filter visuals is limited. I cannot create a chart that can filter other visuals, and the current filtering capabilities within Hex are not as advanced as I would like. I want to be able to apply a filter on a visual that dynamically adjusts the data across the notebook. There is also a need for an enhanced interaction between JavaScript objects and Python for a more seamless workflow. Lastly, I prefer using IPython display for my notebooks because they look more modern compared to the visuals provided by Hex. Review collected by and hosted on G2.com.

I love Hex because it has been instrumental as our main BI tool, especially when I'm the sole data professional at our company. The Hex AI agent is truly amazing and beneficial for business users and development within Hex. It's been a key asset, allowing even non-technical team members to explore data with ease, significantly improving time to insight. The flexibility to dive deep into analyses with Hex's notebook approach is something I particularly enjoy as an analytics professional. It enables me to explore data thoroughly and manage deep dives effortlessly. The ability to use the AI agent almost daily through Slack demonstrates its integration and effectiveness across the company, from our CEO to AEs, making data accessible and insightful despite occasional minor errors. Overall, Hex is a powerful tool that has enriched our data analysis capabilities significantly. Review collected by and hosted on G2.com.

I often have trouble with scheduled runs with notebooks - either a run fails or the environment isn't loading properly. Sometimes this has to do with the auto-caching, other times the notebook kernel just fails. When I open a notebook and it just says 'failure' when the kernel fails, I don't know how to even start debugging that. Review collected by and hosted on G2.com.

I like Hex for the user experience and quick dashboard development. It also provides convenience in scheduling, distributed compute, and quick dashboarding. Additionally, data access to many different hosting platforms is a significant benefit. Review collected by and hosted on G2.com.

It slows down data science development as there is a lag or pulling large amounts of data is slow due to how it offloads the distributed data compute pools to the different data sources compared to Databricks. Also, the lack of customizability on dashboard development where I tend to show static seaborn or matplotlib plots vs Hex interactive plots. Review collected by and hosted on G2.com.

I find Hex incredibly valuable due to its capability to streamline my workflow by allowing seamless analysis and sharing of data across colleagues. Its unique combination of SQL and Python functionality makes it extremely versatile and powerful for data analysis tasks. The scheduling feature is a lifesaver as it enables running scripts automatically and delivers notifications, which are crucial for monitoring and alerting me about failing tests, thereby maintaining the integrity of projects. I highly value the schedule updates, AI assistant, and magic features, which work exceptionally well and are superior to many competitors. Notifications enhance real-time awareness of tasks, while the dual support of SQL and Python in Hex enhances its computational capability tremendously. Furthermore, its integration with other tools like Snowflake, Slack, and GitHub is smooth and enhances my operational efficiency. The initial setup was very easy, which made the transition to Hex smooth and hassle-free. Overall, my experience with Hex has been overwhelmingly positive, as reflected in my recommendation score of 10. Review collected by and hosted on G2.com.

I find managing permissions quite cumbersome with Hex. Creating groups or assigning dedicated permissions and access controls currently feels very manual. It’s an aspect that could benefit from a more streamlined process. Additionally, the integration of code with a GitHub repository is limited because it needs to be enabled on a per-notebook basis. This requirement makes it challenging to maintain and can be a significant blocker for larger organizations. Review collected by and hosted on G2.com.

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.