FIELD NOTE · DEC 2025

Building a Delivery Intelligence Dashboard in HEX

When we restructured a cannabis delivery client’s delivery zones, the team had a handful of important questions we couldn’t easily answer:

We had plenty of raw data, but no centralized BI setup and no analyst to make sense of it.

To close that gap, I built a delivery intelligence dashboard in HEX, giving the company a clearer picture of what was happening across the business. Work that would normally take a data team and an expensive Looker or Tableau setup came together with a low-cost HEX subscription.

1. Turning raw data into a usable model

I started by uploading our order exports into HEX: Blaze logs, internal CSVs and attribution fields. The goal was to move from scattered spreadsheets to a structured dataset that could answer time-based questions across cities and order types.

Using HEX’s Python and SQL cells, I cleaned and standardized the data, created city-level time series, segmented on-demand vs. scheduled orders, and tagged pre- and post-restructure periods. That gave us a flexible foundation for real analysis.

With the data modeled, I built dashboards showing orders by city over time. This gave leadership an immediate read on the restructure:

Instead of relying on gut feel, we could finally see the impact in one place.

3. Measuring real delivery speed

The next question was operational: how fast are we actually delivering on-demand orders?

By charting order times, assignment times and delivery completions, we built a clear wait-time distribution. It showed:

It became a benchmark for the ops and dispatch teams and helped identify where routing or staffing changes were needed.

4. Knowing which channels drive real orders

With attribution data layered in, we created a view of completed orders by channel: Weedmaps, direct traffic, SMS and email, search, and paid tests. This changed how we evaluated marketing and helped us invest more confidently in the channels driving actual revenue, not just impressions or clicks.

5. Sharing the dashboard across the company

Once the dashboard was stable, I shared it with managers across marketing, operations, customer support and leadership. It quickly became:

HEX didn’t just answer one question. It gave the whole team visibility into the business.

Outcome

In a matter of days, we went from scattered CSVs to a working intelligence dashboard that clarified market trends, delivery performance and channel ROI. The team could make decisions faster and with more confidence, without a full analytics hire or heavy BI infrastructure.

I’d recommend HEX to any small or mid-sized business without a dedicated data team.

← all field notesTalk through your growth with Jamie →