Good Product, Broken Data

Alto Supply Co. is a fast-moving e-commerce brand selling eco-friendly household essentials. Their customer base was growing, but their data stack wasn’t keeping up. Every report required a different spreadsheet, numbers often didn’t match across tools, and leadership had stopped trusting their own dashboards.

They didn’t need more metrics—they needed the right ones, delivered reliably, and without endless manual work.

That’s when they brought in NimbleStax.

Goal: Stop the Spreadsheets, Start Scaling

We worked closely with Alto’s product and marketing teams to define exactly what mattered. What they needed wasn’t complicated—it was clarity. They wanted daily visibility into:

• Customer retention by product type

• Revenue by channel

• Weekly operational KPIs for internal reporting

And they wanted it without pulling CSVs and cleaning data by hand every Monday.

Our Approach: Right-Sized Stack + Automation

We rebuilt their stack with a minimal, modern toolkit—no overkill, no unnecessary platforms. Here’s what we delivered:

• Airbyte to pull data from Shopify and Meta Ads

• Google BigQuery as their lean, cloud-native warehouse

• dbt to transform raw data into clean models

• Metabase for clear, real-time dashboards anyone could use

Then we automated everything—from ingestion to dashboard delivery—with a custom orchestration script.

Code Highlight: Simple Daily Orchestration Logic

Here’s a real snippet of what powers Alto’s daily update system—written in Python using cron and dbt CLI.

python daily_pipeline.py

import subprocess
import logging
from datetime import datetime

def run_dbt():
    logging.info("Running DBT transformations...")
    result = subprocess.run(["dbt", "run"], capture_output=True, text=True)
    if result.returncode == 0:
        logging.info("DBT run completed successfully.")
    else:
        logging.error("DBT run failed:\n%s", result.stderr)

def log_success():
    with open("logs.txt", "a") as f:
        f.write(f"Pipeline completed at {datetime.now()}\n")

if __name__ == "__main__":
    run_dbt()
    log_success()

This script runs every morning via cron and ensures Alto’s team wakes up to fresh, actionable dashboards—no manual steps involved.

The Outcome: Clean Data, Zero Drama

Within 3 weeks, Alto Supply had a fully automated reporting pipeline. Their metrics were no longer debated—they were trusted. The marketing team now tracks ad performance in real time, and leadership uses weekly snapshots to guide inventory and hiring.

Most importantly: no one touches spreadsheets anymore.

Why This Worked

We didn’t over-engineer. We asked the right questions, kept the stack lean, and automated just enough to remove friction without adding complexity. Alto Supply didn’t just get cleaner data—they got their time back.

Final Thought

The best data stack is the one that gets used.
Want your team to stop cleaning data and start using it?

→ Let’s build something simple and powerful. Book a discovery call.

Book a discovery call