Enterprises today face a myriad of choices and challenges when attempting to gain both near real time and long term insights from their data; a Modern Data Warehouse. They must learn to deploy and manage Kafka, Spark, Hive, LLAP and a myriad other technologies. Architects and developers have to spend time to understand not just the capabilities of each technology and service but also how they can all be made to work together to meet their unique business goals. In this session, we will go over how enterprises can build a cloud-based modern data warehouse on Azure using open-source projects available as part of Azure HDInsight and Azure Databricks. We will walk through each step of the end to end analytics pipeline from data ingestion to visualization. Come and learn about the best practices, guidelines and tips-and-tricks when choosing the technology to use at each step such that you can deliver the most secure, manageable and functional data warehouse anywhere in the cloud.