Industrial holdingDWH / BI
Task. An industrial holding with several legal entities assembled management reports manually: 30 data sources, different accounting systems, a consolidated report took 1–2 days, and figures from different departments did not match.
Solution
We built a corporate data warehouse and BI platform: integrated 30 sources (1C, CRM, production accounting, HR), set up automatic data-quality checks and a single metrics glossary. Executives got real-time dashboards.
Results
1–2 days → 15 minfaster management decisions
30data sources integrated
5×less effort for reporting
3 days → 2–4 hintegration time per source
Technologies: ClickHouse, Airflow, dbt, DataLens, PostgreSQL, Docker.
Project stages
- Requirements (1–2 weeks) — KPI tree design across the holding’s business units.
- Data platform (4–8 weeks) — warehouse, pipelines and quality controls.
- Dashboards & ML (3–6 weeks) — executive reporting and forecasting models.
- Adoption — training and decision-process integration.
Where this applies
Analytics platforms serve holdings in Kazakhstan, retail groups in Tashkent and Almaty, and diversified businesses in Kyrgyzstan and Turkey. See data management & analytics.