Explore the process of migrating an on-premise data warehouse to the cloud in this comprehensive conference talk from PASS Data Community Summit. Learn how to evaluate the scalability and cost-effectiveness of Azure SQL Data Warehouse, provision resources, and design efficient data loading strategies using Azure Data Factory and PolyBase. Discover techniques for optimizing performance through distribution schemes and compressed in-memory indexes, and gain insights into analyzing workloads with DMVs. Address security concerns by exploring best practices for managing cloud-based data warehouses. Gain valuable knowledge to confidently transition your data infrastructure to the cloud, overcoming common challenges and leveraging the full potential of cloud-based data warehousing solutions.