I have built a data warehouse using Redshift from scratch. It just implemented the materialized view few months ago which can help reduce the timing of complex queries and massive SQL operations in real time. And it is possible to build real-time dashboards embedded in web applications.