Case Study

× Glow25

Building a modern data infrastructure
for fast, data-driven decisions

An interactive case study. Click your way through the story: meet the brand, solve the challenges, explore the stack and see the results.

5 Levels 4 Challenges 1 Mission

Can you solve all four data challenges and unlock the full stack?

Use the dots on the right to navigate anytime

Glow25 Kollagen Plus
Glow25 collagen powder
Level 1 · The Company

Meet Glow25

Glow25 is a Berlin-based “pro-aging” brand developing collagen-based beauty and wellness products. Rather than fighting age, they help customers feel good in their skin, at any age.

Collagen-based beauty & wellness products
Online-first, operating across Europe
E-commerce, subscriptions & rapid shipping
Fast-growing D2C brand with a loyal subscriber base
Level 2 · The Challenge

Data everywhere, insights nowhere

Four challenges stood between Glow25 and data-driven decisions.
Click each card to solve it.

0 / 4 solved
Solve all four challenges to unlock the next level
Level 3 · The Engine Room

Gemma Tech Stack

Every solution you just unlocked runs on this stack, along the data value chain from data creation to activation.

01Data Creation & Capturing
02Data Pipeline & Management
03Data Reporting & Activation
Sources

E-commerce, marketplaces, marketing & CRM

Shopify
WooCommerce
Amazon
eBay
Kaufland
Shop Apotheke
Reybex
Meta
Google Ads
Google Analytics
Klaviyo
Braze
Loading

Automated ingestion & orchestration

Airbyte
Fivetran
Apache Airflow
Python
Storage

Cloud data warehouse

Google BigQuery
Transformation

Modelling, testing & docs

dbt
Reporting

Self-service BI + AI interface

Lightdash
Data Consumers

Where insights create value

Business teams & management
Data science / AI applications
Reverse ETL → e.g. CRM
Google Sheets
The highlighted tools are the core of Glow25's final stack.
Level 4 · The Results

Dashboards in action

Fast, maintainable Lightdash dashboards, plus an AI interface for questions in natural language. Click a dashboard to zoom in.

Glow25 dashboard

E-commerce executive view: revenue per channel, ROAS and acquisition trends at a glance.

Lightdash

All figures are hidden for confidentiality.

Book a discovery call