Case Study: Microsoft achieves self-service analytics at scale with ClickHouse

Microsoft powers self-service analytics for 2,500 users with ClickHouse

Microsoft, specifically its WebXT team which manages major web properties like Bing and Edge, faced the challenge of analyzing petabytes of data from its services. They needed a self-service analytics tool that could provide interactive query responses in seconds for thousands of employees, replacing expensive third-party solutions and enabling faster innovation. The vendor chosen to address this was ClickHouse.

The solution involved building the Titan analytics platform using ClickHouse as the core data engine, combined with Apache Superset for visualization. This open-source approach saved millions of dollars in license fees compared to previous tools. ClickHouse's performance and custom optimizations enabled Titan to handle over 100,000 queries daily, serving 2,500 monthly users with dashboards for A/B testing and user analytics, while also achieving significant storage efficiencies.

Microsoft