Businesses that manage large volumes of data daily face increasing challenges in data analysis, necessitating the use of efficient databases like ClickHouse and streaming platforms such as Redpanda. Traditional relational databases are inadequate for the analytical demands of growing companies, leading to the adoption of OLAP databases like ClickHouse, known for its speed and scalability in handling vast data volumes. ClickHouse can integrate with various databases and streaming platforms, including Kafka and Redpanda, to facilitate real-time data processing. Redpanda, compatible with Kafka's API, offers a resource-efficient and high-performance streaming solution, which can be seamlessly integrated with ClickHouse for businesses that require reliable real-time analytics. The text provides a step-by-step tutorial for setting up a real-time streaming system using Redpanda and ClickHouse, using a real estate agency as a scenario to illustrate how these technologies can streamline data reporting and analysis processes. The tutorial guides users through setting up Docker containers for both platforms, creating databases and tables, and running SQL queries for data analysis, ultimately demonstrating how to achieve fast, reliable data streaming and querying.