Use cases

Table templates

Table display cells are a way to visualize, filter, and format tabular data without writing any code. Simply choose a dataframe and use the Table display settings to apply any fitlers, change the data format of any column, hide any column, wrap text.

Churn Prediction

Izzy Miller

Hex is the most powerful development environment for prototyping and deploying predictive models. With direct SQL access to your data warehouse, a polyglot environment for developing and deploying models, and a built in app builder, the data science feedback loop has never been tighter.

Cohort analysis

Izzy Miller

With Hex, you can easily dive into cohort analysis using Python and unlock insights about your customer groups. Explore their behavior over time, spot retention patterns, and discover valuable nuggets of information. By defining cohorts based on shared characteristics, like the month of their first purchase, you'll gain a deeper understanding of how different customer sets behave. Hex empowers you to make smarter decisions and optimize your business strategies by leveraging the power of cohort analysis.

Collaborative filtering

Izzy Miller

Understand how collective user tastes can be used to find products that are similar to each other and make personalized recommendations based on purchase history. Hex makes it easy to build a recommendation engine using collaborative filtering with Python, and then deploy it as an interactive web app.

Network analysis

Izzy Miller

This project demonstrates a simple network graph analysis using data from the Silk Road forums, the igraph package, and Hex. Most network analyses and community data analysis projects are done as static point-in-time analyses, but Hex makes it easy to provide an interactive window into the data and let users explore the network graph themselves. WARNING: This dataset contains information about illegal activity as well as a lot of bad language. Explore the raw data at your own risk!

Period over period analysis

Izzy Miller

Period over period analysis in a notebook has never been easier or more flexible. With a powerful Python workspace that also supports SQL, you can build a fully interactive report for anyone, and give them the tools to customize their timeframes and periods of interest. When you're done, just click "Publish" and your results are instantly shareable.

Python Data Visualization

Izzy Miller

With Hex, effortlessly visualize data from your SQL data warehouse using Python's robust tools like Matplotlib, Seaborn, Altair, and Plotly, ensuring a seamless transition from data storage to insightful visuals.

Sentiment Analysis

February 19, 2024

Hex provides a flexible workspace to parse unstructured text data and perform sentiment analysis with SQL and Python. Hex's polyglot environment means you can use Python packages like NLTK, TF-IDF, SpaCy, or just some good old fashioned regex and case statements in SQL directly against your data warehouse.

Named Entity Recognition

February 19, 2024

Unearth insights from your business text data using Named Entity Recognition (NER). Leverage Python libraries like SpaCy or NLTK, or employ SQL queries for precise entity extraction from your data warehouse. With Hex, it becomes easy to conduct deep-dive analyses like this comparison of entity profiles across famous Russian and American authors (spoiler: Chekhov likes "EVENTS"). Make your textual data exploration more efficient and intuitive, and let Hex transform the way you understand your data.

Customer Churn Dashboard

Izzy Miller

Reduce customer churn with predictive insights. Discover how our Random Forest model can forecast potential customer drop-offs before they happen, saving you the higher costs of acquiring new clients. Dive into our project to see how we turn data into retention strategies for your business.

Interactive Data stories

Izzy Miller

Like Google Docs, but fully interactive and synced to your data in real time. Build long-form analysis using SQL, Python, or No-Code, and publish beautiful reports that end users will love.

Customer lifetime value Dashboard

Izzy Miller

Understand and optimize your customer's lifetime value (CLV) with this comprehensive example of using Python and SQL to model future spending habits. You'll learn the basics of LTV modeling, explore several different scenarios like buy-till-you-die and gamma-gamma, and get a template of an interactive report on top of these models that anyone at your organization can use. Hex makes it easy to explore datasets, build complex predictive behavioral models, and then communicate findings in an interactive report— all from the same tool.

VADER sentiment analysis

Izzy Miller

Hex provides a flexible and powerful workspace that empowers users to effectively parse unstructured text data and perform sentiment analysis seamlessly using SQL and Python. With VADER, an exceptional sentiment analysis tool, Hex allows you to gain valuable insights into the sentiment expressed by users on social media platforms regarding a wide range of topics. By leveraging VADER's capabilities within Hex, you can uncover and understand the emotional tone and opinions of social media users, enabling you to make data-driven decisions and enhance your understanding of customer sentiment.

Linear Dimensionality Reduction

Izzy Miller

Hex simplifies linear dimensionality reduction, enabling efficient feature extraction from high-dimensional data. Whether you're visualizing high-dimensional data, discovering clusters, or training models, Hex provides a collaborative workspace that supports your preferred workflow. With seamless integration of Python and SQL, you can effortlessly apply popular techniques like PCA, ICA, and truncatedSVD.

Python mapping libraries

Izzy Miller

Hex is a remarkably versatile interface for GIS and geospatial data analysis, giving you full access to the capabilities of top Python mapping libraries like GeoPandas, Plotly, and Mapbox, while ensuring a smooth integration with your data warehouse. Hex even has a native map cell for effortless visualization of geospatial data. With Hex, you're equipped with a plethora of both code and no-code tools for converting, scrutinizing, and visualizing geospatial data. When you've concluded your analysis, sharing your interactive maps and diagrams is just a few clicks away.

SQL Notebooks

Izzy Miller

All the organizational power of code notebooks, tailor-made for your SQL workflows. Chain SQL queries, join across data sources, and access cloud-scale data in a collaborative SQL IDE.

Company Metrics Dashboard

Izzy Miller

Don't limit yourself to traditional, old-fashioned BI. Hex lets you turn even the most flexible and complex analyses into beautiful, easy to use dashboards.

Exploratory Data Analysis

Izzy Miller

Exploratory data analysis in Hex is like no other tool you've used before. SQL, Python, rich text, and a library of no-code tools are right at your fingertips in the same workspace. When you're done, just click "Publish" and your results are instantly shareable.

See what else Hex can do

Discover how Hex data scientists and analysts use Hex for everything from dashboards to deep dives.

Python templates

Hex’s first-class Python support unlocks a world of opportunity for data exploration.

SQL templates

Query your warehouse, uploaded files, or dataframes directly with SQL.

Map templates

Map cells let you visualize geographic data in a customizable interactive map.

Chart templates

Chart cells let you visualize and explore the dataframes in a Hex project, without writing code.

Input parameter templates

Input parameters are a core, unique part of Hex. Input parameters can be created in the Notebook view and then added, optionally, to an app.

Markdown text templates

Text and Markdown cells let you add narrative, explanations, and context to your data project.

Made with

🍩

☕

🥟

🍺

🍰

🔮

🔒

🥖

🍷

🛌

💜

🥨

🛹

🍤

🧄

🍞

🥥

⛳

on 🌎.

Company

Careers Customers Media kit Newsroom

Product

Notebooks Hex Magic Enterprise For Teams App Builder Pricing Integrations Security

Resources

Blog Docs Quickstart Events Use cases Changelog Trust Center

Contact

Support Sales Twitter Email us