# Building data cubes across subscriptions, usage and marketing for a SaaS business

> A private-equity-backed SaaS business · SaaS & Tech

A private-equity-backed SaaS business gained a single view of subscriptions, product usage and marketing through three purpose-built data cubes and self-service dashboards.

## What was the problem?

The SaaS business had extensive product and customer data but lacked a consolidated view across marketing, sales and product usage. It wanted to democratise data access across teams and understand customer behaviour to improve acquisition, reduce churn and grow market share.

## What did QuantSpark do?

QuantSpark built three data cubes: subscriptions and contracts for financial and board reporting, product usage to identify and predict churn, and marketing attribution to find the most profitable customers and effective channels. The work moved through discovery of the existing data infrastructure, data modelling to relationalise data held in non-relational stores, data engineering including a cost-effective cloud storage environment and a pipeline connecting digital advertising and web-analytics platforms, and a suite of self-service dashboards. An open-source SQL transformation tool kept the build cost-effective and maintainable.

## What changed?

Automated board reporting, saving significant analyst hours and reducing key-person risk, and democratised data access across teams. The engagement created a measurable basis for return on investment through high-value customer identification and churn prediction; the firm expects this return to grow over time (a forward-looking projection).

---

Canonical page: https://quantspark.ai/case-studies/data-cubes-saas-subscriptions-usage-marketing
More about QuantSpark: https://quantspark.ai/llms.txt