What is our primary use case?
Hex provides fast and rich analytics with an easy-to-use platform that even non-technical users find accessible for getting their analytics. I use
Hex for all my analytics, and it significantly speeds up my work. What previously took two to three days now takes only a few hours, approximately half a day. The AI agent in Hex is excellent for conducting extensive analytics and helps generate insights for our stakeholders, enabling them to make data-driven decisions accurately. I appreciate the guides feature that establishes the context and business logic of my company's data, making it easy for the AI to understand this context. Setting up Hex does not require creating semantic models; you simply provide a database with minimal context and figures, and it determines what to do next.
I find Hex very friendly, particularly in how it fits the workflow of a data analyst, even though I am a data scientist. The connectivity between cells in the notebook functionality is something I appreciate, and I value that Hex can mix SQL and Python while storing all variables and tables to build upon them. The ability to use it with my cloud code via the Hex CLI for scaffolding analysis is beneficial, and I also enjoy the polished design of Hex.
How has it helped my organization?
Hex has positively impacted my organization because it helps me quickly solve the data-related questions I encounter daily as a data scientist, allowing me to stay on top of what is working and what needs my attention.
Hex has helped my team by troubleshooting issues faster, improving observability, and enabling data-driven decisions, which reduces manual investigation and saves time, allowing my team to focus more on development and improving performance.
Using Hex has shortened the time from two to three days for gathering analytics to a few hours, roughly six to eight hours. Hex has also saved my team four to six hours per week by reducing manual data analysis and speeding up troubleshooting, which helps us make faster and more informed decisions.
What is most valuable?
The best features Hex offers are rich analytics, seamless integrations, ease of use, flexibility, an intuitive interface, and powerful AI features, which I find very valuable.
The unique aspects of Hex that stand out compared to other BI tools include its ease of use and flexibility, as well as its ability to seamlessly integrate SQL and Python for data analysis. Its intuitive interface and powerful AI features enable us to gain quick insights and efficient collaboration, making it a very valuable tool for both technical and non-technical users.
Hex provides good data security and governance through access controls and permission management, so I feel confident using its AI features. I believe it has been reliable regarding data security.
Using Hex's AI has been very helpful; it has been accurate and reliable, generally providing correct and useful outputs for data analysis and SQL generation.
Hex integrates very seamlessly with other AWS services we use, especially with Amazon Redshift and Amazon S3, making connecting data straightforward.
What needs improvement?
Notebooks can quickly become messy once you start creating many cells in the same notebook, making it easy to lose your place while scrolling to find the cell you are looking for. I am not fully convinced by the notebook and app partitioning because it feels clunky and confusing in practice.
I would appreciate the agent to have different modes, such as fast or thinking options.
For how long have I used the solution?
I have been using Hex since 2020, which is roughly six years, and I was using Hex even with my previous employer.
What do I think about the stability of the solution?
Hex is generally stable and reliable with good performance for everyday data analysis and reporting.
What do I think about the scalability of the solution?
The scalability of Hex is one of the best key advantages we get from using it, as it scales effectively with data volumes and team usage while supporting collaborative analytics and larger workloads.
How are customer service and support?
I find the customer support to be helpful and responsive, as the team provided clear guidance when we had some issues with documentation.
I would rate the customer support a nine out of ten, as they have been very great.
Which solution did I use previously and why did I switch?
Previously, we relied on Jupyter Notebooks, but we switched to Hex for better collaboration, easier data analysis, and more efficient sharing of insights across the team.
How was the initial setup?
Hex was easy to deploy in our
AWS environment since it is cloud-based and requires minimal setup; connecting data sources and configuring access permissions was straightforward, requiring little technical support.
Hex's configuration process was straightforward; setting up data connections, permissions, and workspaces was relatively easy, although some advanced testing required technical knowledge and additional testing.
What was our ROI?
Hex has delivered a positive return on investment by reducing manual data analysis and speeding up reporting; we estimate saving around four to five hours per week, allowing my team to focus on higher-value work without needing additional staff. I am very satisfied because I can complete my analysis within a few hours, approximately six hours, instead of the two to three days it typically would take.
What's my experience with pricing, setup cost, and licensing?
The procurement process for Hex was straightforward, as evaluating the features and pricing was relatively easy; the agents in
AWS Marketplace were very clear and professional, although reviewing licensing options and getting internal budget approval took some additional time.
Hex's billing experience is manageable and accurate, but clearer usage tracking and more detailed cost breakdowns would help us better monitor our spending and predict costs more accurately.
Overall, I find the pricing of Hex to be very manageable compared to what we receive, and the setup costs were also manageable, but clearer pricing tiers and more flexible licensing options would make budgeting much easier.
Which other solutions did I evaluate?
Before choosing Hex, we evaluated Jupyter Notebooks and SQL-based workflows.
What other advice do I have?
I give Hex a five out of five because it has been a true game-changer in my work; what previously took two to three days can now be done in half a day, which represents a significant improvement for me.
I highly recommend Hex for teams looking to improve data analysis and collaboration. Before settling on Hex, I suggest starting with a small project to connect key data sources and evaluate how much time it saves before expanding its use.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)