Azure Data Engineering Course with Advanced Power BI

Course Outline

Module 1: Introduction to Azure Data Engineering  

• Overview of Azure Data Services  

• Setting up an Azure account and subscription  

• Introduction to Azure Data Factory 

Module 2: Data Ingestion in Azure  

• Azure Data Factory pipelines for data ingestion  

• Azure Blob Storage and Azure Data Lake Storage  

• Data ingestion from on-premises sources  

Module 3: Data Transformation with Azure Data Factory  

• Data transformation activities in Azure Data Factory  

• Data wrangling and cleansing  

• Introduction to Azure Databricks for advanced transformations  

Module 4: Building Data Warehouses in Azure  

• Introduction to Azure SQL Data Warehouse  

• Designing data warehouses for analytics  

• Data loading and querying in Azure SQL Data Warehouse  

Module 5: Introduction to Azure Synapse Analytics   

• What is Azure Synapse Analytics  

• How Azure Synapse Analytics Works  

• Explore Azure Synapse Analytics 

Module 6: Working with Azure Stream Analytics   

• Understand data streams  

• Understand event processing  

• Understand window functions 

Module 7: Introduction to Power Query   

• Features of Power Query  

• How to get Data from different data Sources  

• How to use Query Editor  

• Understand Modeling data and Relationships  

Module 8: Advanced Power BI Concepts  

• Data modeling in Power BI  

• Creating complex DAX calculations  

• Advanced visualizations and custom visuals  

Module 9: Power BI Dataflows and Composite Models  

• Introduction to Power BI dataflows  

• Building and managing dataflows  

• Creating composite models for complex data relationships  

Module 10: Power BI Embedded and Custom Visuals  

• Embedding Power BI reports into applications  

• Developing custom visuals using Power BI developer tools  

• Security and authentication in Power BI Embedded