Blog

All
Company
Data
Data teams
Design
Engineering
Friends of data
Product
Security
Subscribe
Introducing: Hex Magic

AI tools meant to augment โ€“ not replace โ€“ย human insight. Now in private beta.

How to query a SQL database from Pandas

Get data into pandas without downloading csvs

Metrics layers: past, present, future

Why dbt Labsโ€™ acquisition of Transform is great for data stacks

Introducing VegaFusion 1.0: now a Hex OSS project

Infinitely scalable data visualization, with a more permissive license

Introducing: Components

Stop repeating yourself repeating yourself reaepting yuroslef rpaetnig ouylefs

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

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

Text cleaning for NLP with Python

Learn how to prepare text data for NLP tasks

How to build a sentiment analysis model in Python

Learn how to classify the sentiment in a body of text

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

A Guide to Exploratory Data Analysis in Python

What comes before sophisticated data analysis and modeling?

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

How to perform an A/B test

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

How to do Funnel Analysis with SQL and Python

Tracking user events, actions, and drop-off

We took down production by misconfiguring our ETL

Hereโ€™s what we learned and how you can avoid it

Connecting to and querying MySQL from Python

Querying one of the most commonly used databases from Python

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.

Intro to cohort analysis in Python

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

Modernizing Jupyter workflows with Hex + Snowflake

A supercharged, collaborative, cloud-native way to notebook

Connecting to and querying BigQuery from Python

Four steps to read data from your BigQuery warehouse directly into Python

Getting started with logistic regression

Implementation of a binary classification algorithm in Python

Q&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

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!

Q&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

How to Get Your Data From Postgres to Snowflake

Extracting from a production PostgreSQL database and loading into Snowflake

Deploying ML models to Snowflake with Modelbit and Hex

A simple and elegant way to deploy machine learning models

Storytellers and System Builders

A New Way to Think About Data Roles

How to Build a Dashboard in Python

Turning your Python data visualizations into beautiful interactive dashboards

Hex at AllTrails

Enabling Exploratory Analysis with SQL & Python

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

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

Predictive Lead Scoring with Python

How to build a lead scoring model that actually serves stakeholders

How collaboration changes everything, from design to data

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

How to write SQL in Python with Pandas

Two and a half ways to query Pandas DataFrames with SQL

Getting the most out of dbt docs

Bringing all the power of dbtโ€™s documentation site, straight into Hex

Connecting to and querying Snowflake from Python

Four steps to read data from your warehouse directly into Python

Introducing: โ€œNo-Codeโ€ Cells

Bringing together SQL, Python, and no-code in Hexโ€™s magical notebooks

Stop using so many CTEs

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

Notebooks weren't built for the modern data stack

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

Connecting to and querying Redshift from Python

Learn how to read data from your Redshift warehouse directly into Python

Bringing data notebooks into the cloud era

Query mode, Chained SQL, and Python pushdown for everyone

Introducing Snowpark for Python in Hex

Plus, Snowflake Partner Connect and Premier Partner status

Hex for Analytics Engineers: Hex Powered PR Review

Streamlining analytics engineering workflows with Hex

A new way to embed Hex apps in Notion

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

versioning_v3_final

Introducing an all-new way to version work in Hex

Hex for Analytics Engineers: Data Transformation

Streamlining analytics engineering workflows with Hex

Building Data Apps with just SQL

Turning simple queries into impactful artifacts

SQL Notebooks > SQL Runners

SQL finally gets literate programming

Building a Builder

Designing and engineering a new app layout engine from scratch

Going from data to knowledge

Data teams are still struggling to have impact.

Data, Knowledge, and our Series B

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

Announcing our partnership with Databricks

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

An interview withDr. Melodie Kao

Part 2: Barriers to STEM equality and boundary setting

Planning a Modern Datathon

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

An interview withDr. Melodie Kao

Part 1: How a PhD astrophysicist thinks about data

Hex Everywhere

Embedding cells and apps for fun and profit

Introducing: Knowledge Library

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

Six Reasons Hex and Snowflake Work Great Together

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

Building Better Display Tables

A more beautiful and useful way to visualize dataframes.

Our $16M Series A

Some more money stuff, and our partnership with dbt Labs

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

BI Tools & Hex

Why advanced data teams need both BI tools and flexible data workspaces

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.

Introducing: Dataframe SQL

Python or SQL? Why not both?

Hex Latest and Greatest: May 2021

SQL IDE, Chart Cell, Scheduling, and more!

An interview withMona Khalil

An interview with Mona Khalil, Data Scientist at Greenhouse

Announcing Hex

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

An interview withChris Moffitt

An interview with the author of Practical Business Python

The Sharing Gap

Communicating data work is as messy as ever.

A Pragmatic Approach to Live Collaboration

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

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.

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

Truly empowering users doesnโ€™t mean getting rid of code, but embracing it.