Monitoring dashboard with analytics

In the project, we mainly pull data from tiktok based on provided data by customer. Mainly different brand share their requirements and the backend system pull data from tiktok. Once the data is in our system, the monitoring dashboard generate analytics on different timeseries queries. I was in-charge to develop the monitoring dashboard backend. The backend was based on Python, Django. The complex queries I wrote, was able to calculate analytic data from 60+ TB data in real time. I used redis and django ORM for complex query. In few places, I used raw sql queries to make it faster. Also used materialized views to have data.