×
The perfect finish
for Maniko's data
Build the stack era by era and paint all five nails to complete the manicure.
Use the dots on the right to navigate anytime
Meet Maniko
Maniko brings the nail salon home. UV gel strips and press-on nails give you a studio manicure in minutes, no appointment needed.
When growth outruns the spreadsheet
At the end of 2023, all of Maniko's analysis, reporting and planning lived in Y42 and Google Sheets.
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.
Maniko's data platform
Nothing here yet. Build the first era 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
Reverse 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.
Maniko sees yesterday's revenue and profit every morning, not at year-end.
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 into the stack instead of spawning new spreadsheet tabs.
Self-service insights
With Lightdash, the team answers its own questions instead of waiting for an analyst.
One source of truth
Online shop and drugstore retail live in one model. One picture of the whole business.
Profit visible daily
The daily P&L turns profitability from a year-end surprise into an everyday management tool.
© Gemma Analytics · Case Study Maniko