Use cases

Python templates

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

Customer Segmentation

Izzy Miller

Enhance your marketing and sales strategies with a detailed Customer Segmentation model built using SQL & Python. Using K-Means clustering, you can intelligently segment your customer base into distinct groups based on purchase behavior, demographics, and other significant characteristics, enabling targeted marketing campaigns and personalized customer experiences. Hex lets you use Python's machine learning libraries for feature scaling and encoding, and K-Means for defining clear, actionable customer clusters— and also makes it easy to power these analyses with data right from your SQL warehouse.

Outlier Detection

Izzy Miller

Detect and analyze anomalies in your dataset using robust Outlier Detection methods. With Hex, you can easily integrate Python's Scikit-learn, use IQR techniques, or apply Z-Scores to pinpoint outliers. Streamline your data analysis, ensure quality, and drive accurate results by efficiently identifying and addressing these deviations.

Inventory management

Izzy Miller

See how to use data science to enhance inventory decisions with this comprehensive project focused on analyzing, predicting, and optimizing inventory levels. Using historical sales data and trends, we build a robust predictive model with Python and SQL that factors in seasonality, trends, and demand fluctuations. Hex's seamless integration of SQL, Python, and intuitive visualization tools makes it easy to explore inventory data, build predictive stock-level models, and communicate findings in an easy-to-understand, interactive report. This model ensures you maintain the optimum level of stock during peak periods, thus minimizing costs and preventing out-of-stock scenarios.

Social Media Sentiment Analysis

Izzy Miller

Hex provides a flexible workspace to parse text data like social media posts and perform sentiment analysis with SQL and Python. Hex's polyglot environment means you can use Python packages like NLTK and SpaCy directly on data from your warehouse— or in this case, just a good old fashioned logistic regression against a simple .csv file. From simple 5-minute project to production deployed data applications, Hex makes it easy to perform any kind of sentiment analysis on social media (or any) data.

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.

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 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.

Time Series Forecasting with Prophet

Izzy Miller, Dev Advocate at Hex

Hex is your go-to platform for flexible time series forecasting directly with your data warehouse, enabling you to construct powerful predictive time series models using Python and SQL, without any needless data shuffling. It's particularly handy when integrated with libraries like Prophet for detailed daily temperature forecasting. Once you've nailed your model, it's simple to add interactive elements, making your forecasts not just informative, but engaging. You can take your model straight from creation to production, all from within the intuitive Hex interface. No fuss, no extra steps - just efficient, effective data science at your fingertips.

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.

Natural Language Processing

Izzy Miller

Building a natural language processing app that uses Hex, HuggingFace, and a simple TF-IDF model to do sentiment analysis, emotion detection, and question detection on natural language text.

See what else Hex can do

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

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.

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.