Datavations, a New York-based company founded in 2020, has developed a comprehensive data and optimization platform tailored for the home improvement industry, aiding manufacturers in inventory and pricing decisions to secure retail shelf space. The platform relies on a proprietary web aggregation system that collects extensive store-level data, which is then processed by machine learning algorithms to align closely with actual sales metrics across numerous categories. Initially, Datavations used a standard data stack involving S3, Databricks, and Tableau, but faced challenges with cost and performance as the company expanded. To address these issues, they transitioned to a ClickHouse-powered architecture that streams data through Amazon Kinesis Firehose and separates processing and analytics tasks across dedicated ClickHouse instances, significantly reducing costs and improving speed and data quality. This new setup not only optimizes data storage and query performance but also enables real-time analytics and exploratory data analysis without disrupting production workflows. Looking ahead, Datavations plans to migrate to ClickHouse Cloud for enhanced parallel processing capabilities and is exploring AI-native workflows using ClickHouse's MCP server, aiming to further innovate and enhance their data-driven services for clients.