Business Intelligence

SQW04 Selecting the Best Azure Cloud-Based Modern Data Warehousing Solution


9:30am - 10:45am

Level: Intermediate

Ginger Grant

Principal Data Geek

Desert Isle Group

What is the best choice for your organization when selecting a solution for a Cloud based data warehouse in Azure? Of course you can use the Data Warehousing dedicated sql pool of Azure Synapse Analytics, but is that the right choice for your organization? Can you meet the needs of the organization with lower Azure spend? In this session, we will explore all of the different Azure tools which can be used to house a data warehouse and determine which one is the best choice given different use cases. We will review the different maintenance and skill level needed to use each tool and provide a walk-through of which choice would be best in your organization. We will explore the reasons for using Azure SQL, Azure Synapse Serverless pool with an Azure Data Lake Gen 2, and Azure Synapse dedicated pool. Learn which one will best meet your needs and the ETL processes you can use to load the data from whatever source it may be using.

You will learn:

  • Understand the different Data Warehousing options, their features, weaknesses and strengths.
  • Provide methods for selecting the correct application for a given environment by understanding how to match the data tasks to the appropriate tool to provide the best match with the lowest Azure Spend
  • The different features available in each product to give a good understanding of the different elements as well as provide a roadmap to upgrade should the data situation change in the future