Blog

All
Data teams
Security
Product
Design
Engineering
Friends of data
Data
Company
Subscribe
new home popout
An all-new workspace homepage

There’s no place like /home

visualizing-data-jupyter-notebooks
Recap: San Francisco Public Data Hackathon

We brought the city's cleverest data people together to explore public municipal datasets

Select w/ Hex
How to Boost Collaboration between Product and Data teams

Defining and testing an activation metric for product-led growth using an interactive data app.

How to get the most out of your Snowflake data

Practical tips for getting the most out of your Snowflake data, from Snowpark to cost controls and picking the right exploratory workbench.

modelbit-hero
Deploying ML models to Snowflake with Modelbit and Hex

A simple and elegant way to deploy machine learning models

stubhub
Faster and Better Insights: Building a Big Picture Data Team at StubHub

How can data teams balance operational efficiency and speed with quality and depth of data insights?

Charging for AI
Why Hex isn’t charging extra for “AI”

Magic should be free

Focus Your Data Team Blog Hero
Focusing your data team on what matters most

How do you go from from reactive ticket-answering to strategic, decision-impacting data work?

snowflake-hero
Six Reasons Hex and Snowflake Work Great Together

Why you should pair your powerful data warehouse with a collaborative data workspace

EPD Insights
Exploratory Product Analysis for Product & Engineering Teams

Helping your engineers, product managers, and designers find their own business-impacting insights.

DMHeroero
Managing Magic

Using the Data Manager to improve and customize Hex Magic for your organization’s data.

python-dashboard-hero
How to Build a Dashboard in Python

Turning your Python data visualizations into beautiful interactive dashboards

on-demand-gpus
Using On-Demand GPUs to Build and Deploy ML Models with Hex and Modelbit

On-demand GPUs, model training, and deployment.

Coalesce 2023
Coalesce Recap

Growth, Complexity, and Community

Eutelsat OneWeb
Eutelsat OneWeb’s Journey with Snowflake and Hex

Navigating the Stars With Data Collaboration

hipaa-multi-tenant
Introducing Hex HIPAA multi-tenant

Advancing data in healthcare, securely

dbt Innovation Partner of the Year Award
Transforming Data Workflows with dbt's Semantic Layer

Winning dbt's Innovation Partner of the Year Award

polyglot pushdown
Deepening Our Snowpark Integration

Switch between SQL, Python, and visual cells while using a Snowpark dataframe

Hex 3.0 Blog Image
Introducing Hex 3.0

One arbitrary version number for Hex, one giant leap for data people

ama-snowflake-hex-blog hero
Snowpark + Hex Ask Me Anything

Highlighted questions and answers from a live joint Snowflake and Hex session

jupyter kernel hero
What is the Jupyter kernel, and how does it work?

Learn how the computational engine for notebooks functions.

hex partnership with snowflake
Hex's Partnership with Snowflake: Behind the Magic

Behind-the-scenes look at how Hex built features that integrated with Snowflake.

hero-workrise
Building a Text-to-SQL Chatbot

How to use Hex, LangChain, and OpenAI to use natural language to query your database

Hex and Algolia
Automating Reporting at Algolia

How one data team transformed tedious, manual reporting tasks into seamless, automated workflows

hex-and-google-cloud-hero-image
Hex + Google: Analytics and Data Science in the Cloud

Announcing our partnership with Google and how we’re enabling larger data workflows for thousands of users

brand-inaccessability-hero
The Poles of Brand Inaccessibility

Using modern data tools to discover modern opportunities for exploration

feature-success-hero
The case for warehouse-based product analytics

Product analytics on top of warehouse allows for deeper insights into activation, retention, and churn.

Iterating on analytics
One Chart Forward, Two Queries Back

End to end tools make the modern analytics workflow faster

Jehvons Paradox Hero
The boundless demand for insight

What coal and Jevons’ paradox tell us about AI and data

Attribution hero
Why, when and how to use a first-touch attribution model

Or: this blog post has made $0

dim-red-techniques-hero
A practical guide to dimensionality reduction techniques

Practical examples of common dimensionality reduction algorithms in Python

dim-red-hero
Introduction to dimensionality reduction

Building an intuition around a common data science technique

Snowpark Container Services
Hex + Snowpark Container Services: Secure Analytics and ML for Enterprises

Analyze, model, and explore datasets without having to move data outside of a secure and governed Snowflake account.

Hex-Iceberg-tables
Apache Iceberg and Hex

Query Iceberg tables and build interactive reports on top with Hex

public-beta-magic-hero
Magic, for everyone

Powerful AI assist for data, now in Public Beta

kpi-dashboards-hero
Make data-driven decisions with KPI dashboards

Elevate your decision-making process by turning raw data into actionable insights and strategic outcomes

hex-and-snowflake
Hex + Snowflake: Notebooks in the Cloud

Announcing our Elite Partner Status and how we’re speeding up data workflows for thousands of users

nlp blog hero
Natural Language Processing in Python

Using computers to programmatically understand and interpret human language

collections-blog-hero
Introducing: Collections

Curate your workspace with a flexible and powerful organizational framework

Beyond linear notebooks

Reactive notebooks allow for better interpretability, reproducibility, and performance

funding-sequoia-hero
Data, magic, and some more money stuff

Announcing our partnership with Sequoia

dbt-transform
Metrics layers: past, present, future

Why dbt Labs’ acquisition of Transform is great for data stacks

Blog Post Illustration
Introducing: Hex Magic

AI tools meant to augment – not replace – human insight. Now in private beta.

hex-vegafusion-hero
Introducing VegaFusion 1.0: now a Hex OSS project

Infinitely scalable data visualization, with a more permissive license

components-hero
Introducing: Components

Stop repeating yourself repeating yourself reaepting yuroslef rpaetnig ouylefs

new-chart-cell-hero
Introducing: an all-new, interactive visualization experience for Hex

Point-and-click visual filtering, an all-new chart cell, custom color palettes, and more

cleaning-text-data-hero
Text cleaning for NLP with Python

Learn how to prepare text data for NLP tasks

exploratory-analysis-hero
A Guide to Exploratory Data Analysis in Python

What comes before sophisticated data analysis and modeling?

human-interest-hero
What does it mean to build a self-service analytics infrastructure?

How Human Interest’s data team empowers stakeholders across the company to use analytics every day

hex-and-dbt
Hex + dbt: Bringing trust, governance, and speed to the data stack

Announcing our partnership, product integrations, and how we’re changing data workflows for thousands of users

AB-hero
How to perform an A/B test

Compare versions of a product/service in order to observe which one performs the best.

we-took-down-prod-hero
We took down production by misconfiguring our ETL

Here’s what we learned and how you can avoid it

cohort-analysis-blog-hero
Intro to cohort analysis in Python

Analyze groups of customers to understand retention, predict churn, and find other patterns

dbt-package-hero
Writing Your First dbt Package

A comprehensive guide on how to create dbt packages with working code examples, and an open-source repo that you can build from.

modernizing notebooks hero
Modernizing Jupyter workflows with Hex + Snowflake

A supercharged, collaborative, cloud-native way to notebook

logistic-regression-hero
Getting started with logistic regression

Implementation of a binary classification algorithm in Python

bluecore-hero-2
An interview withQ&A with Bluecore’s Data Team: Part 2

We spoke about Bluecore’s revenue forecasting app, how the team prioritizes projects and measures success, reasons for adopting Hex, and more

linear-regression-hero
Getting started with linear regression

A common algorithm used to find the best-fitting line between two or more variables

Introducing Hex’s Integration with the dbt Semantic Layer

A new Metrics cell, dbt-flavored SQL in Hex, and more!

bluecore-hero
An interview withQ&A with Bluecore’s Data Team: Part 1

We spoke about Bluecore's data team and modern data stack, use cases for Hex, and more

systems-vs-storytelling-hero
Storytellers and System Builders

A New Way to Think About Data Roles

alltrails-hero
Hex at AllTrails

Enabling Exploratory Analysis with SQL & Python

beginner-to-python-hero
A beginner’s guide to Python notebooks

Why data teams use notebooks, and how to get them up and running for coding and exploratory analysis

orchestration-integrations-api-meta
Announcing: Orchestration integrations and the Hex public API

Trigger Hex apps right from Airflow and Dagster— or plug into the API and build something completely custom

Lead-Scoring-Hero
Predictive Lead Scoring with Python

How to build a lead scoring model that actually serves stakeholders

collab-changes-everything-hero
How collaboration changes everything, from design to data

Leaving fragmentation, local files, and version control hell in the past

documentation-dies-in-the-darkness-hero
Getting the most out of dbt docs

Bringing all the power of dbt’s documentation site, straight into Hex

Introducing: “No-Code” Cells

Bringing together SQL, Python, and no-code in Hex’s magical notebooks

stop-using-so-many-CTES-hero
Stop using so many CTEs

Why it's time to "break up" with your favorite SQL feature

notebooks-mds-hero
Notebooks weren't built for the modern data stack

Our tools for exploration and analysis are living in the past.

native-nb-erd-diagram
Bringing data notebooks into the cloud era

Query mode, Chained SQL, and Python pushdown for everyone

snowpark-hero
Introducing Snowpark for Python in Hex

Plus, Snowflake Partner Connect and Premier Partner status

hex-powered-pr-review
Hex for Analytics Engineers: Hex Powered PR Review

Streamlining analytics engineering workflows with Hex

notion-hex-hero
A new way to embed Hex apps in Notion

Announcing a new, richer way to embed data from Hex into Notion docs

versioning-hero
versioning_v3_final

Introducing an all-new way to version work in Hex

hex-for-analytics-engineers-data-transformation-hero
Hex for Analytics Engineers: Data Transformation

Streamlining analytics engineering workflows with Hex

building-data-apps-with-sql-hero
Building Data Apps with just SQL

Turning simple queries into impactful artifacts

sql-notebooks-sql-runners-hero
SQL Notebooks > SQL Runners

SQL finally gets literate programming

builder-hero
Building a Builder

Designing and engineering a new app layout engine from scratch

knowledge-hero
Going from data to knowledge

Data teams are still struggling to have impact.

series-b-hero
Data, Knowledge, and our Series B

Data teams are still struggling to have impact. We raised some money to help.

databricks-hero
Announcing our partnership with Databricks

Why we're excited to partner with Databricks to power the next generation of analytics workflows

melodie2
An interview withDr. Melodie Kao, Part 2

Part 2: Barriers to STEM equality and boundary setting

datathon-blog
Planning a Modern Datathon

How to run a hackathon for data in the age of the modern data stack

melodiekao
An interview withDr. Melodie Kao, Part 1

Part 1: How a PhD astrophysicist thinks about data

embed-worm-hero
Hex Everywhere

Embedding cells and apps for fun and profit

library-view
Introducing: Knowledge Library

High-impact data work isn’t just about churning out analysis; it’s about creating knowledge.

table-display-hero
Building Better Display Tables

A more beautiful and useful way to visualize dataframes.

series-a-hero
Our $16M Series A

Some more money stuff, and our partnership with dbt Labs

dbt-hero
Hex 💜 dbt

Our new dbt integration and partnership with dbt Labs

Hex 2.0: Reactivity, Graphs, and a little bit of Magic

Announcing a new, ✨ magic ✨ way to work with notebooks and build data apps

soc-2-hero
Announcing Hex's SOC 2 Type II Report

Security is our most important job. This report reflects how seriously we take our obligations for customer data.

df-sql-hero
Introducing: Dataframe SQL

Python or SQL? Why not both?

may-2021-latest-greatest
Hex Latest and Greatest: May 2021

SQL IDE, Chart Cell, Scheduling, and more!

mona-headshot
An interview withMona Khalil

An interview with Mona Khalil, Data Scientist at Greenhouse

announcing-hex
Announcing Hex

What we're doing, why we're doing it, and some money stuff

cm-headshot-2021-1
An interview withChris Moffitt

An interview with the author of Practical Business Python

sharing gap hero
The Sharing Gap

Communicating data work is as messy as ever.

multiplayer
A Pragmatic Approach to Live Collaboration

or: How I Learned to Stop Worrying and Love the Atomic Operation

incremental-line
On Software, Ships, and Shipping Incrementally

The only path around the 2.0 tar pit is incrementalism - replacing a legacy platform through small, deliberate steps.

data-roi-hero
Don’t Tell Your Data Team’s ROI Story

Next time you get asked to justify the ROI for your team, don't. Sit back, and let others tell the story for you.

long-live-code
Long Live Code

Truly empowering users doesn’t mean getting rid of code, but embracing it.

Further reading

Detecting Seasonality Through Autocorrelation

Autoencoders and methods like ACF and PACF effectively identify seasonality in time series data, enhancing business forecasting.

The Essential Steps in Data Preprocessing for Different Data Formats

Data preprocessing refines raw data for accurate analysis by handling missing values, normalizing and processing data.

Understanding the Importance of Stationarity in Time Series

Stationarity, crucial for reliable time series analysis, is confirmed through tests like ADF and KPSS, facilitating easier modeling and interpretation.

Unveiling Patterns Using Time Series Visualization

The article uses a mock AirPassengers dataset to visually demonstrate trends and seasonal patterns in the airline industry.

The Importance of Data Cleaning in EDA

Why and how to clean data

When To Choose Density-Based Methods

Compare, k-means, DBSCAN and Hierarchical Clustering

Scaling Hierarchical Clustering

Learn how Fastcluster, Apache Spark, and GPU-accelerated solutions can help.

Unveiling patterns in unlabeled data with k-means clustering

Sift through the noise and categorize datasets into actionable segments

How Overfitting Ruins Your Feature Selection

Learn how to prevent overfitting from impacting your model.

Using Autoencoders for Feature Selection

Learn how to use autoencoders which are a class of artificial neural networks for data compression and reconstruction.

Detecting and Remedying Multicollinearity in Your Data Analysis

Learn to ensure the validity, reliability, and accuracy of your model.

How To Use Univariate Analysis in Your Data Exploration

Learn how to describe, summarize, and find patterns in the data from a single variable.

Build anything with data

See interactive examples of what you can do with Hex, from complex ML forecasting to critical business dashboards.

use-case-category-grid-image-kpi-sentiment-analysis

Sentiment Analysis

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

use-case-category-grid-image-time-series

Time Series

Time series forecasting in Python is a powerful tool for predicting future values based on historical data. Discover meaningful patterns and trends to make better decisions and improve your business's bottom line.

use-case-category-grid-image-kpi-dashboards

KPI Dashboards

Track and monitor your business KPIs (key performance indicators) with ease using our interactive SQL and Python dashboard. Get insights into sales performance, customer satisfaction, operational efficiency and more.

use-case-category-grid-image-exploratory-analysis

Exploratory Analysis

Exploratory data analysis (EDA) in Python is a powerful tool that can help you to understand your data, identify patterns, and make better decisions. Hex comes pre-installed with a wide range of Python libraries, making it a popular choice for EDA.

use-case-category-grid-image-natural-language-processing

Natural Language Processing

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

use-case-category-grid-image-data-visualization

Data Visualization

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