This SSIS in the Cloud class will take users through the process of creating simple SSIS packages that interact with various Azure Storage options like Azure Blob Storage and Azure SQL DB. It will start with creating, deploying, and executing packages that move data in the Cloud via an on-premises solution. Then users will be introduced to Azure Data Factory and the feature known as Lift and Shift which will allow us to deploy our packages to an Azure SQL Database and execute them uses Cloud resources. Users should have a basic understanding of SSIS prior to watching this class.
Overview
COURSE DIFFICULTY
COURSE DURATION
6h 26m
Skills Learned
After completing this online training course, students will be able to:
Build professional dashboards and reports with interactive visualizations
Design efficient data models using star schemas and relationships
Design dimensional data models for analytics
Transform and analyze data to generate insights
Power Automate Developers, BI Developers, Data Analysts
None
01. What You Need to Get Started
02. TMDL Overview
03. Using the Interface
04. TMDL Language Basics
05. Modifying Source Queries
06. Managing Measures
07. Limitations and Considerations
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build professional dashboards and reports with interactive visualizations
Design efficient data models using star schemas and relationships
Design dimensional data models for analytics
Transform and analyze data to generate insights
WHO SHOULD ATTEND
Power Automate Developers, BI Developers, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. What You Need to Get Started
02. TMDL Overview
03. Using the Interface
04. TMDL Language Basics
05. Modifying Source Queries
06. Managing Measures
07. Limitations and Considerations
