The perfect finish
for Maniko's data
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 reveal the details
Spreadsheets doing too much
Y42 ran the data pipelines, but analysis, reporting and planning all happened in Sheets. Every question meant another tab.
A setup at its limit
The spreadsheet setup stopped scaling as the business and its data volumes grew.
Fragile refreshes
Data refreshes kept breaking, and trust in the numbers suffered.
One stack, three eras
Gemma rebuilt Maniko's data platform step by step.
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 & support tools
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 & support tools
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 drugstore retail business, down to EBITDA.
Click Total, Online or Retail to switch the view.
Enabling Maniko to start every morning with yesterday's revenue and profit.
Daily P&L overview
How is Maniko performing over time?
Illustrative example modelled on a real Maniko report - all figures fictional.
A data function that keeps up with the brand
More case studiesheyDataglow25All case studies
© Gemma Analytics · Case Study Maniko