BI users usually query the Data warehouse a few times a minute but as systems are more real-time, developers start to expose analytics to the end user. This talk is about every single pain we had during the last few years developing data projects with high ingestion rate, low latency and high number of queries per second. No fancy architectures, nothing crazy, just pains and real solutions we apply to solve those use cases with high volume of data and high concurrency.