CRM Analytics provides out-of-the-box connectors for integrating external data sources like Microsoft Azure SQL Data Warehouse. To meet the requirement of daily automated data loading, the Microsoft Azure SQL Data Warehouse Connector can be used to pull data into CRM Analytics. Once the data is imported, dataflows or recipes can be used to transform and merge this data with the organization's Salesforce data. Recipes allow for merging datasets and applying any necessary transformations, ensuring the data from Azure is combined and transformed appropriately before analysis.
Reference: CRM Analytics Connectors and Dataflows