GhumanNavneet/Analytics-Airlift

This repo contains the content for the Analytics Airlift comprising Azure SQL DW, Azure Databricks, Azure Data Factory, Azure Data Lake and Power BI.

Analytics Airlift

Agenda

Please note: This is a rough agenda, and the schedule is subject to change pending class activities, breaks, and interactions.

• Day 1: ADF - Data ingestion lab
  • Lab 1.1: LAB-Ingesting Data into a Blob with ADF
  • Lab 1.2: LAB-Ingesting_Data_into_a_ADLSGen2_with_ADF
  • Lunch
  • SQLDW - Loading lab
  • Lab 1.3: Data loading best practices Final - edits
  • Break
  • SQLDW - Query tuning lab
  • Lab 1.4: SQLDW - Query Performance Tuning
• Day 2: Azure-Databricks
  • Azure-Databricks-ETL
• Day 3: ETL_with_AzureDatabricks
  • Lab 2.1: ETL_with_AzureDatabricks Setup_Instructions