×
The perfect finish
for Maniko's data
Use the dots on the right to navigate anytime
Meet Maniko
When growth outruns the spreadsheet
At the end of 2023, all of Maniko's analysis, reporting and planning lived in Y42 and Google Sheets.
Hover over a problem to flip it and see the fix
One tool for everything
Sheets was the database, the analysis layer and the dashboard. Every question meant another tab.
A setup at its limit
The system stopped scaling as the business grew. Refreshes broke and trust suffered.
Two worlds of revenue
The online shop and the drugstore business reported in separate silos. Nobody saw the whole brand.
One stack, three eras
Gemma rebuilt Maniko's data platform step by step.
Build the three eras in order and watch the stack grow.
The Spreadsheet Era
Y42 pipelines feed Google Sheets. Analysis, reporting and planning all live in spreadsheets.
The Modern Data Stack
Fivetran and Airflow load every source into BigQuery. dbt models the data, Tableau reports it.
The AI-First Stack
Reporting moves from Tableau to Lightdash, and AI agents like an AI PR reviewer join the team.
Maniko's data platform
Nothing here yet. Click "Era 01" on the left to see where Maniko started.
Sources
Shop & marketing tools
Pipelines
All-in-one platform
Everything else
Analysis, reporting & planning
Sources
Shop, marketing, retail, logistics & support
ClickUp
Loading
Automated ingestion & orchestration
Storage
Cloud data warehouse
Transformation
Modelling, testing & docs
Reporting
Dashboards & analysis
Data Consumers
Where insights create value
Reverse ETL (e.g. CRM)
Sources
Shop, marketing, retail, logistics & support
ClickUpLoading
Automated ingestion & orchestration
Storage
Cloud data warehouse
Transformation
Modelling, testing & docs
Reporting
True self-service BI
Data Consumers
Where insights create value
AI agents
Claude CodeReverse ETL (e.g. CRM)
Yesterday's profit, every morning
On top of the stack, Gemma built a daily profit & loss statement. It covers the online shop and the retail shelves at dm and Rossmann, down to EBITDA.
Enabling Maniko to see yesterday's revenue and profit every morning, instead of waiting for the year-end accounts.
A data function that keeps up with the brand
From a spreadsheet system at its limit to an AI-first stack that answers questions the day they come up.
Scales with growth
New sources plug straight into the stack, so the platform grows with the brand instead of spawning new spreadsheet tabs.
Self-service insights
Enabling faster decisions through self-service dashboards in Lightdash, so the team no longer waits on an analyst for every question.
One source of truth
Bringing online and drugstore retail together in a single model, for one consistent picture of the whole business.
Profit visible daily
Turning profitability from a year-end surprise into an everyday management tool, visible every morning.
© Gemma Analytics · Case Study Maniko