Back to workData
Real-time financial reporting
A data warehouse and dashboards consolidating sales, margins and cash flow across five subsidiaries.
- Client
- Retail group
- Industry
- Distribution
- Year
- 2024
- Technologies
- Python · dbt · PostgreSQL
Key figures
5
subsidiaries consolidated
40+
automated KPIs
-90%
reporting time
The challenge
Monthly reporting relied on hand-consolidated Excel files, with frequent discrepancies between teams' numbers.
Our solution
We automated extraction from Odoo and the subsidiaries' tools, modelled the data with dbt and delivered role-based Metabase dashboards for management, finance and sales.
Results
- Consolidated metrics refreshed every night
- One shared definition for every KPI
- Monthly reporting produced in minutes