Techwards Transforms Revenue Planning for Squatwolf Using Databricks
Squatwolf, a premium direct-to-consumer (DTC) gym wear brand with Series B funding of $30 million, faced limitations in revenue forecasting due to reliance on aggregate monthly data. Built on Shopify, the brand integrates multiple platforms for attribution, email marketing, social media, and legacy systems. Techwards was engaged to modernize their forecasting infrastructure and provide deeper, actionable insights across customer segments and SKUs.
Problem Statement
Squatwolf’s analytics were hindered by three key challenges:
- Lack of Granular Data: Forecasting relied on monthly summaries, restricting detailed insights for planning and performance tracking.
- Tool Limitation: Legacy system-based workflows couldn’t handle daily or SKU-level forecasting, making it hard to scale and automate insights.
- Manual Processing: Without granular inputs, analysts had to perform error-prone, time-consuming manual work to extract insights.
Solutions
Techwards delivered a modern forecasting solution built on the Databricks ecosystem:
- Granular Revenue Forecasting: Designed a forecasting model providing yearly, monthly, and daily predictions, tailored for both performance planning and strategic alignment.
- Data Cleaning & Base Layer Setup: Established a clean, segmentable data foundation, organizing historical performance and customer segments for high-quality forecasting inputs.
- Unified Data Platform: Migrated analytics workflows to Databricks, leveraging Delta Lake, MLflow, and Apache Spark for real-time processing, efficient querying, and automated report generation.
Outcome
Squatwolf transitioned to a scalable forecasting platform, delivering real-time, SKU-level insights. The switch to Databricks enabled continuous data updates, streamlined workflows, and empowered the business with accurate forecasting and segment-specific targeting. This transformation replaced error-prone manual processes with reliable, automated analytics—setting the foundation for long-term growth and agility in the DTC fitness market.
