Azure Data Factory (ADF) is a cloud-based service for data integration. ADF is used to integrate disparate data sources from across your organization including data in the cloud and data that is stored on-premises. In this course, you will learn how to create data-driven pipelines to direct the movement of data. You will also be introduced to an alternative option to Azure Data Factory and that is using SSIS to work with your cloud resources. Once packages have been developed in SSIS you must choose between storing and executing those packages on-premises or in the cloud. You will then learn about the difference between hosting SSIS on-premises vs. Azure Lift and Shift.
BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.
What to Know Before the Class
The target audience of this class is the data integration professional who is tasked with orchestrating data movement processes within the organization. This class assumes that you have no previous knowledge of Microsoft’s Azure Platform or Azure Data Factory. Some experience using SSIS or another ETL tool could be helpful but is not necessary. Most course work will be performed using Azure resources and therefore there are not many pre-requisites for this course.