Today we’re launching end-to-end no-code workflows including spreadsheet-style calcs, data browsing, and endorsements. They live alongside our existing SQL, Python, and AI tools, making Hex the first platform to bring these modalities together in one place.
Today we’re announcing a bunch of amazing new features in Hex – and our first launch on Product Hunt!
Why didn’t we do this sooner? Honestly I’m not sure, we were just busy. But better late than never…
For anyone who hasn’t used Hex yet, it’s the world’s most powerful workspace for analytics and data science. It lets you work between SQL, Python, and no-code – all in one place. It’s already being used by over 1000 teams worldwide to better understand data, develop models, and make better decisions.
A lot of you might think of Hex as a “notebook” – but we’re executing on a much bigger vision. We want it to be easy to work – and work together – with data, no matter your technicality level.
Here’s what’s new…
NEW DATA BROWSER AND NO-CODE QUERYING
Searching for and previewing data has never been easier. Find tables, columns, or descriptions and instantly see previews. When you find the data you need, no-code cells load it directly from underlying databases - no SQL needed.
SPREADSHEET-STYLE FUNCTIONS
[*insert “Hexcel” pun here*]
Hex speaks spreadsheet! Now you can add new fields using the world’s most popular data language – ExcelLang. over 60 of the most common spreadsheet functions. When you execute a calc, Hex’s compute engine compiles it to dialect-specific SQL, and pushes it down to the full scale of the underlying data.
ENDORSED STATUSES
Endorsed Statuses improve our existing Statuses feature and visually indicate trusted, governed assets. They can only be added by Admins and Workspace managers, and they are fully customizable, so you can add whatever name, color, and icon best suits your workflow.
FASTER MAGIC AI TOOLS
Our Magic AI tools make it easy to go from a prompt to analytics. With our new updates and the latest GPT4o model, chart generation is 10x faster and everything else will feel 2x snappier. Plus, we’ve added diff-based editing for Python.
We believe the future of analytics is multi-modal, allowing you to work between code, no-code, and text prompts to build with data. We couldn’t be more excited about building toward that future and what it unlocks for everyone using Hex.
Barry
congrats on the launch! the integration of no-code querying and spreadsheet-style functions in hex sounds incredibly intuitive. how do you envision these new features impacting the day-to-day workflow of current users who primarily rely on the traditional SQL and Python tools?
Congrats! Can you explain how Hex facilitates collaboration around data and integrates with other data science tools?
ChatGPT
"Hex just raised the bar for versatility in workflow platforms—no code, no problem. 💪
Tried it. But it's way too complex. I think maybe just adding text to the sidebar would help a lot. And maybe the opening view should be a bit more about task that can be performed. Like easy me in to it 😅
Hex is a revelation for data enthusiasts like me! The way it brings together complex datasets and makes them understandable is just fantastic. I've been able to uncover insights that were previously hidden, and the collaboration features are a hit with my remote team. It's like we're all looking at the same dashboard, even though we're miles apart. Hex has truly become the central hub for all our data needs!
Combining no-code workflows with SQL, Python, and AI is ambitious—do you think this hybrid approach can truly cater to both non-tech and tech-savvy users without alienating either group?
Hex looks super cool, Barry! The new features seem awesome. How does Hex ensure that the no-code querying and spreadsheet-style functions are powerful enough for advanced users but still easy for beginners to use?
This looks like a very promising tool for democratizing data analysis! I especially love the idea of combining spreadsheet-style calculations with SQL, Python, and AI in one platform. This could open up a lot of possibilities for teams with varying levels of technical expertise.
My question is, how easy is it to switch between these different modalities within a project? Is there a smooth transition between no-code and code-based workflows?
I'm so excited about the launch of Hex's no-code end-to-end workflows! The integration of spreadsheet-style calculations, data navigation, and endorsements, along with existing SQL, Python, and AI tools, makes this platform incredibly powerful and versatile.
I used Hex in a really early version at a previous startup, and it felt promising but early...It's been exciting to see Barry and team deliver on that promise - going from a data scientist focused cloud python notebook to a truly horizontal data tool.
I started my career in tech as a data scientist (lots of really slow Hive queries at Yahoo) and I remember using Mode in ~2015, and how useful it was for ad-hoc queries and custom reports. I loved Mode in the early days, but at some point it felt like the evolution stalled, like a promise unfulfilled.
Fast forward to a few months ago when we started using Hex at Product Hunt - It sounds like hyperbole but Hex feels like the analytics tool I've dreamed about. It allows for ad-hoc queries while staying relatively close to the data (good for collaboration, traceability), and allows everyone to work with data in their language of choice: sql, python, and now spreadsheets!
The charts are beautiful and somehow I never have to think too hard to get the chart I'm looking for. Tufte would be proud.
Plus the AI magic really does help someone like me with very rusty SQL get the right answer without banging my head against a wall.
Also as a tool builder, it's been really interesting to see how the team has navigated complexity and multiple user paths to similar goals. There's been a ton of craft that goes into this and it shows.
Congrats on the launch, Hex team!
I'm a big fan of hex and I've found it's been a super useful tool for us! It makes building and sharing dashboards about our data really straightforward and quick. In fact, just yesterday I was able to go from question about our data to a chart I could share around in almost no time at all 🚀
Congrats on the launch!
Exciting to see spreadsheet-style calcs, data browsing, endorsements, SQL, Python, and AI tools together!
