Use cases

From complex ML forecasting to critical business dashboards, Hex lets data teams work together in Python, SQL, and no-code to do more with data, together.

icon-in-person

Sentiment Analysis

Decipher subjective information in text to determine its polarity and subjectivity, explore advanced techniques and Python libraries for sentiment analysis.

View all
vader

VADER sentiment analysis

Analyze social media data to understand the overall sentiment of users.

Social sentiment grid image

Social Media Sentiment Analysis

Parse out insights and trends from the sea of tweets, posts, and threads

Sentiment analysis grid image

Sentiment Analysis

Understand the meaning behind your unstructured text data, from reviews to support requests

NER grid image

Named Entity Recognition

Uncover the hidden entities in your text data, from classic literature to customer feedback.

icon-in-person

Data Clustering

Unleash the power of data clustering—an unsupervised machine learning technique that uncovers patterns and groups similar data together without the need for labeled data.

View all
Customer Segmentation Grid image

Customer Segmentation

Group users and customers into intelligent segments

cluster algos

Clustering algorithms

Group similar data points together to discover patterns, structures, or subgroups within a dataset.

Cluster real

Cluster analysis

Build an interactive K-means clustering app in minutes with Hex. Scale, reduce, and encode your features using Python— and then create an interactive app using input parameters.

doc similarity grid

Document Similarity with Embeddings

Explore document similarity using embeddings, swiftly visualizing and interpreting text clusters from your SQL warehouse.

icon-pulse

KPI Dashboards

Track and monitor business KPIs, offer insights into sales performance, customer satisfaction, and operational efficiency.

View all
Feature Usage

Feature Success

Jo Engreitz

Measure Feature adoption, retention and satisfaction with this interactive Hex app.

SQL dashboards grid image

SQL Powered Dashboards

Build flexible BI dashboards out of SQL queries

metrics dash cover

Company Metrics Dashboard

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

Churn

Customer Churn Dashboard

Build interactive frontends for powerful ML models

icon-cursor

Data Science

Unearth hidden insights and power business decisions with machine learning— or just good old applied statistics.

View all
outlier grid image

Outlier Detection

Detect and analyze anomalies in your dataset using robust Outlier Detection methods.

Network analysis grid image

Network analysis

Discover patterns, insights and structures in complex graph data

ML model dev grid image

ML Model Development

Build, test, and deploy powerful ML models

dbt audit helper grid image

dbt Audit Helper

Validate dbt PRs and document changes with a Hex UI

icon-help

Exploratory Analysis

Deep dives, rabbit holes, side quests, and ad-hoc explorations.

View all
Text to SQL

Text to SQL Chatbot

Jordan East

Learn how to build your own text to SQL chatbot in Hex using OpenAI and LangChain

SQL notebooks grid image

SQL Notebooks

The most powerful SQL IDE ever made

Polyglot grid image

Polyglot Notebooks

Polyglot notebooks for data science

No-code grid image

No-code Notebooks

Powerful data exploration without writing a line of code

icon-pulse

Data Visualization

Transform raw data into actionable insights with interactive visualizations, dashboards, and data apps.

View all
python viz grid

Python Data Visualization

Leverage Hex to transition from SQL data warehouse insights to dynamic visual storytelling using Python's top visualization libraries.

mapping libraries grid image

Python mapping libraries

Access Python's powerful mapping ecosystem right alongside SQL and native geospatial tools

Geospatial grid image

Geospatial Data Analysis

Use powerful GIS techniques alongside SQL and built-in mapping tools

icon-cursor

Data Modeling

Take raw data and transform it into ready to use data sets for predictive models, interactive apps for exploration, or for company reporting.

View all
feature selection grid

Market Basket Analysis

Identify high-impact product pairings and optimize promotional strategies with apriori market basket analysis

collaborative filter

Collaborative filtering

Build a recommendation engine with Hex and Python. Use collaborative filtering to find similar products and make personalized recommendations based on purchase history..

content based

Content based filtering

Content-based filtering and collaborative filtering are two data modeling techniques for recommending items to users. Turn your complex logic into an easily digestible app in Hex that anyone can use and start getting recommendations within seconds.

icon-cursor

Natural Language Processing

Empower your AI and ML applications to interpret, recognize, and generate human language with powerful Natural Language Processing (NLP) algorithms.

View all
vader

VADER sentiment analysis

Analyze social media data to understand the overall sentiment of users.

Social sentiment grid image

Social Media Sentiment Analysis

Parse out insights and trends from the sea of tweets, posts, and threads

Sentiment analysis grid image

Sentiment Analysis

Understand the meaning behind your unstructured text data, from reviews to support requests

NER grid image

Named Entity Recognition

Uncover the hidden entities in your text data, from classic literature to customer feedback.

icon-cursor

Feature Selection

Determine the most appropriate features of your Machine Learning model to make it easy to interpret, get accurate results, reduce overfitting, and optimize your computational resources.

View all
nonlin dr

Non-linear dimensionality reduction

Visualize high dimensional data using non-linear reduction techniques

Linear dr

Linear Dimensionality Reduction

Visualize high dimensional data using linear reduction techniques

feature selection grid

Feature Selection

Seamlessly apply feature selection methods to data fresh from your SQL warehouse

icon-in-person

Parameterized Queries

Upgrade your projects with parameterized SQL queries. Create interactive dashboards and exploratory data analysis with SQL queries that dynamically react to user input using Hex.

View all
use-case-grid-image-feature-success-interactive-dashboard

Feature Success Interactive Dashboard

Jo Engreitz

Build feature success dashboards with Hex. Monitor usage metrics using parameterized SQL, create interactive visualizations and effortlessly share your work.

icon-pulse

Reporting

Bring your business data to life with interactive reports, beautiful dashboards, and rich data stories.

View all
Rudderstack use case image

Replace Google Analytics with Rudderstack & Hex

Build a more in-depth and flexible analytics stack

Pop real

Period over period analysis

Compare various points in time across multiple periods

inventory

Inventory management

Leverage insights to make informed decisions about product inventory and ensure availability

use-case-grid-image-automating-quaterly-reviews

Automating Quarterly Reviews

Izzy Miller

Connect your data between Hex, Google Sheets and Google Slides. Empower your stakeholders to access data and charts that automatically refresh before the next QBR.

icon-pulse

Time Series

Discover meaningful patterns and trends by visualizing data over time.

View all
Time series prophet grid image

Time Series Forecasting with Prophet

Izzy Miller, Dev Advocate at Hex

Make simple time series modeling easy and configuration-free with Prophet

Time Series Forecasting Cover

Time Series Forecasting

One workspace with everything you need to build complex time series models

time series snowpard

Time series analysis in Snowpark

Forecast hourly restaurant traffic using UDTFs in Snowpark