The situation
A leading fragrance and beauty company runs a profitable, growing business that spans fulfillment, wholesale, direct-to-consumer, marketing, and brick-and-mortar retail. Business-critical data comes from many sources, including internal operational systems and external partners, but none of it was adding up to a clear view of the whole.
Leadership envisioned a data-driven organization where the right insights reached decision-makers daily. However, external data was arriving in whatever format and accuracy retail and wholesale partners chose to share, with no meaningful way to influence either. Spot solutions were fragmented, inefficient to maintain, and often inconsistent in what they showed.
The challenge
The company needed a foundation flexible enough to absorb partner data however it arrived, integrated enough to surface a single view across channels, and durable enough to support new needs and requirements as they arose, including those driven by AI.
The approach
Revel Labs started by defining what “data-driven” means for this business. Working with leadership, the team identified the decisions the company makes daily, the data those decisions require, and the integration points needed to handle partner data however it arrived.
From there, the work moved to design. What separates a foundation that serves the business from one that becomes its own problem is execution, starting with the technologies underneath. The team right-sized the solution for the needs of the company, focusing on agility, low cost, and low complexity.
The solution
Revel Labs built a modern data foundation on BigQuery, with dbt managing transformations, dlt loading data from source systems, dagster orchestrating the pipelines, and Power BI surfacing the reports and dashboards.
The architecture brings together operational and partner data across all areas of the business, normalizing inputs that arrive in different shapes into a single, shared model. For the first time, the company has a consistent view of how each brand and channel is performing.
On top of the foundation, the team delivered the first wave of business insight dashboards:
- Retail sales and inventory across direct-to-consumer and brick-and-mortar retail
- Executive insights for a daily view of overall business performance
- Expanded product and retail location data insights
- Marketing performance
Each dashboard is built on the same foundation, so numbers reconcile across views. Future dashboards will inherit the same structure.
The outcome
Decisions that used to rely on workarounds now have data behind them. From leadership-level reviews to operating-team channel choices, the daily work draws from one shared foundation. New partner data, when it arrives, gets absorbed into that foundation rather than triggering a new point solution.
The platform runs in production today. Revel Labs continues to operate and evolve it as a managed service, working alongside the company on what comes next.
The ongoing opportunity
n addition to powering the dashboards delivered today, the foundation makes a wider set of capabilities possible. These include:
- AI-enabled insight and decision support
- Real-time integration with new wholesale and retail partners
- Predictive analytics on product performance and demand
- Additional dashboards as new business needs surface
What began as a data and reporting initiative is now the foundation for how the company sees itself and decides what comes next.