Home / Business Intelligence Courses / Azure BI
Azure Data Factory
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. Risus commodo viverra maecenas accumsan lacus vel facilisis.
Classroom | Online | Fast Track | Self Paced
Course Highlights
Live Projects
Placement Assistance
Expert Trainers
Premium Training
Live Video Share
Real-Time
Case Studies
Frequently Asked Questions
What is ADF and What are it's uses?
Azure Data Factory is Azure's cloud ETL service for scale-out serverless data integration and data transformation. It offers a code-free UI for intuitive authoring and single-pane-of-glass monitoring and management. You can also lift and shift existing SSIS packages to Azure and run them with full compatibility in ADF.
Is ADF easy to learn?
It is easy to learn because of simple cloud service, processes and many low code interfaces.
Does ADF have a market?
Yes, Microsoft is the leader in Analytics and Business Intelligence since 16 years. It is providing its wonderful support to the current cutting edge processes and technologies by its monthly updates. And also On-Premise MSBI and Cloud Power BI providing other BI supportive services beside Azure BI. Kindly visit the following links to know more about the Azure BI Market & Leadership - https://powerbi.microsoft.com/en-us/blog/microsoft-named-a-leader-in-the-2022-gartner-magic-quadrant-for-analytics-and-bi-platforms/ - https://powerbi.microsoft.com/en-my/blog/microsoft-named-a-leader-in-the-forrester-wave-augmented-bi-platforms-q3-2021/
What if I miss a training session?
No need to worry, daily videos are in the class room folder and materials in the materials folder. You can watch and practice and also reach out to the trainer for queries
What type of study materials and videos we will get and how long they are available?
You will get all materials after a week of your joining which you can download and use. Daily live class recordings will be placed in a folder and you will have access for maximum 12 months. Lab practice documents and required Power BI credentials provided for practice till one year.
Quick Enquiry
Why Join Vinay Tech
In-Depth Curriculum
Our educational program aims to comprehensively cover all & important points & aspects of the subject
Course Specialized Trainers
Our Trainers are high experienced industry experts with their teaching methods designed for their particular course
10+ Years of Experience
We’ve come a long way teaching from hundreds to thousands, so we use our experience in guiding students in the right path
Students Favourite
Vinay Tech House is prefered by many students as their favourite, rating as the best in teaching
Curriculum
Cloud Computing Concepts
- What is the "Cloud"?
- Why cloud services
- Types of cloud models
- Deployment Models
- Private Cloud deployment model
- Public Cloud deployment model
- Hybrid cloud deployment model
- Characteristics of cloud computing
- On-demand self-service
- Multi-tenancy and resource pooling
- Measured service
- Cloud Data Warehouse Architecture
- Shared Memory architecture
- Shared Disk architecture
- Shared Nothing architecture
Core Azure services
- Core Azure Architectural components
- Core Azure Services and Products
- Azure solutions
- Azure management tools
- DWH Life Cycles
- DWH Approaches (INMON and KIMBALL)
- Data Granularity, Data movement stages
Azure Pricing and Support
- Azure subscriptions
- Planning and managing costs
- Azure support options
- Azure Service Level Agreements (SLAs)
- Service Lifecycle in Azure
Azure SQL Database
- Introduction Azure SQL Database
- Comparing Single Database
- Managed Instance
- Creating and Using SQL Server
- Azure SQL Database Tools
- Migrating on premise database to SQL Azure
- Purchasing Models
- DTU service tiers
- vCore based Model
- Server-less compute tier
- Service Tiers
- General purpose / Standard
- Business Critical / Premium
- Hyperscale
- Deployment of an Azure SQL Database
- What is SQL elastic pools
- Choosing the correct pool size
- Creating a New Pool
- Manage Pools
- Monitoring and Tuning Azure SQL Database
- Configure SQL Database Auditing
- Export and Import of Database
Azure Storage Service
- Storage Service and Account
- Creating a Storage Accounte
- Standard and Premium Performance
- Understanding Replication
- Hot, Cold and Archive Access Tiers
- Working with Containers and Blobs
- Types of Blobs
- Block Blobs,
- Append Blobs
- Page Blobs
- Blob Metadata
- Soft Delete
- Azure Storage Explorer
- Access blobs securely
- Access Key
- Account Shared Access Token
- Service Shared Access Token
- Shared Access Policy
- Storage Service Encryption
- Azure Key Vault
Azure Data Factory
- What is Data Factory?
- Data Factory Key Components
- Pipelinee
- Activity
- Linked Service
- Data Set
- Integration Runtime
- Triggers
- Data Flows
- Page Blobs
- Integration Runtime Provision Required Azure Resources
- Create Resource Group
- Create Storage Account
- Provision SQL Server and Create Database
- Provision Azure Data Factory (ADF) Service
Exploration of Copy Activity
- Understanding Data Factory UI
- Copy Data from Blob Storage to SQL Database
- Copy data from storage account to storage account
- Create Linked service and Create Dataset
- Create Pipeline - Integration Service
- Copy Data from on-premise SQL Server to Blob Storage Working with Activities
- Understanding Lookup Activity
- Understanding for Each Activity
- Filter Activity
- Get Metadata Activity Azure
- Lift and Shift
- Provisioning Azure - SSIS Integration Runtime
- Execute SSIS Packages from Azure
- Execute SSIS Packages from SSISDB Triggers,
- Monitoring Pipeline
- Debug Pipeline
- Trigger pipeline manually
- Monitor pipeline
- Trigger pipeline on schedule
Scenarios and Use Cases Explanation
- ADF Introduction
- Important Concepts in ADF
- Create Azure Free Account for ADF
- Integration Runtime and Types
- Integration runtime in ADF-Azure IR
- Create Your First ADF
- Create Your First Pipeline in ADF
- Azure Storage Account Integration with ADF
- Copy multiple files from blob to blob
- Filter activity __ Dynamic Copy Activity
- Get File Names from Folder Dynamically
- Deep dive into Copy Activity in ADF
- Copy Activity Behavior in ADF
- Copy Activity Performance Tuning in ADF
- Validation in ADF
- Get Count of files from folder in ADF
- Validate copied data between source and sink in ADF
- Azure SQL Database integration with ADF
- Azure SQL Databases - Introduction Relational databases
- Creating Your First Azure SQL Database
- Deployment Models
- Purchasing Modes
- Overwrite and Append Modes in Copy Activity
- Full Load in ADF
- Copy Data from Azure SQL Database to BLOB in ADF
- Copy multiple tables in Bulk with Lookup & ForEach in Data Factory
- Logging and Notification Azure Logic Apps
- Log Pipeline Executions to SQL Table using ADF
- Custom Email Notifications Send Error notification with logic app
- Use Foreach loop activity to copy multiple Tables- Step by Step Explanation
- Incremental Load in ADF
- Incremental Load or Delta load from SQL to Blob Storage in ADF
- Multi Table Incremental Load or Delta load from SQL to Blob Storage
- Incrementally copy new and changed files based on Last Modified Date
- Azure Key Vault integration with ADFs
- Azure Key Vault, Secure secrets, keys & certificates in Azure Data
- ADF Triggers:
- Event Based Trigger in ADF
- Tumbling window trigger dependency & parameters
- Schedule Trigger
- Self-Hosted Integration Runtime
- Copying On Premise data using Azure Self Hosted integration Runtime
- Data Migration from On premise SQL Server to cloud using ADF
- Load data from on premise SQL Server to Azure SQL DB
- Data Migration with polybase and Bulk insert
- Copy Data from SQL Server to Azure SQL DW with polybase & Bulk Insert
- Data Migration from On premise File System to cloud using ADF
- Copy Data from on-premise File System to ADLS Gen2
- ToCopying data from REST API using ADF
- Loop through REST API copy data TO ADLS Gen2-Linked Service Parameters
- AWS S3 integration with ADF
- Migrate Data from AWS S3 Buckets to ADLS Gen2
- Activities in ADF
- Switch Activity-Move and delete data
- Until Activity-Parameters & Variables
- Copy Recent Files From Blob input to Blob Output folder without LPV
- Snowflake integration with ADF
- Copy data from Snowflake to ADLS Gen2
- Copy data from ADLS Gen2 to Snowflake
- Azure CosmosDB integration with ADF
- Copy data from Azure SQLDB to CosmosDB
- Copy data from blob to CosmosDB
- Advanced Concepts in ADF
- Nested ForEach -pass parameters from Master to child pipeline
- High Availability of Self Hosted IR &Sharing IR with other ADF
- Data Flows Introduction
- Azure Data Flows Introduction
- Setup Integration Runtime for Data Flows
- Basics of SQL Joins for Azure Data Flows
- Joins in Data Flows
- Aggregations and Derive Column Transformations
- Joins in Azure Data Flows
- Advanced Join Transformations with filter and Conditional Split
- Data Flows - Data processing use case1
- Restart data processing from failure
- Remove Duplicate Rows &Store Summary Credit Stats
- Difference Between Join vs. Lookup Transformation& Merge Functionality
- Dimensions in Data Flows
- Slowly Changing Dimension Type1 (SCD1) with HashKey Function
- Flatten Transformation
- Rank, Dense_Rank Transformatioss
- Data Flows Performance Metrics and Data Flow Parameters
- How to use pivot and unpivot Transformations
- Data Quality Checks and Logging using Data Flows
- Batch Account Integration with ADF
- Custom Activity in ADF
- Azure Functions Integration with ADFF
- Azure Databricks Integration with ADF
- ADF Integration with Azure Databricks
- Azure Data Lake Analytics integration with ADF
Introduction to Azure Databricks
- Introduction to Databricks
- Azure Databricks Architecture
- Azure Databricks Main Concepts
- Databricks Integration with Azure Blob Storage (Read data from Blob Storage and Create Blob mount point)
Introduction to Python
- Features of Python
- Python Virtual Machine (PVM)
- Frozen Binaries
- Memory management in Python
- Garbage collection in Python
Projects Covered
Project - 01
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Project - 02
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Interested in a Free demo? Want to learn more?
Get Certified by Vinaytech House
Vinay Tech’s course completion certificate will be provided upon the completion of the
course successfully. It increases the value of your resume and you can attain leading
job posts with the help of this certification in leading MNCs. The certificate can be printed out
like a hard copy or handed digitally
Need help with Microsoft ETL Certification?
Our Student Say!
Our Learners Work At
