When we restructured a cannabis delivery client’s delivery zones, the team had a handful of important questions we couldn’t easily answer:
- How did orders shift by city after the restructure?
- Which markets gained or lost traction?
- What were our true on-demand delivery times?
- Which channels were actually responsible for completed orders?
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.
2. Understanding city trends after the restructure
With the data modeled, I built dashboards showing orders by city over time. This gave leadership an immediate read on the restructure:
- Which cities were growing
- Which were declining
- Where volume was shifting week to week
- Where we needed to adjust staffing, driver coverage or marketing support
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:
- The share of orders delivered in under 45 minutes
- Where delays were happening
- Differences by city and time of day
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:
- A single source of truth
- A transparent operational benchmark
- A weekly reporting tool
- A shared foundation for strategic decisions
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.