Company
Date Published
Author
Increff
Word count
1004
Language
English
Hacker News points
None

Summary

Increff, a retail SaaS company, was facing challenges in managing its complex supply chains and optimizing inventory with its previous business intelligence (BI) platform. The platform struggled to handle massive datasets of over 200 million records, causing query performance issues and bottlenecks. To address this, Increff reimagined its BI platform using ClickHouse Cloud, a scalable and high-performance data architecture that integrates with over 90 data sources. By adopting a new star schema design, partitioning, and optimized data types, Increff achieved sub-second query speeds and reduced data preparation times by 70-80%. The company is now exploring advanced features like projections, materialized views, and AI-driven tools to further improve performance and user experience. With the new architecture, Increff can support the world's leading retail brands in making smarter, faster decisions with confidence.