Azure Data Factory with Power BI - Live Training
| Class | Start Date | Status | Price |
|---|---|---|---|
| Azure Data Factory with Power BI This class is free for Recent Masters Graduates |
Jan 23 | Open | $2,500.00 |
Azure Data Factory with Power BI - Online Training
| Class | Start Date | Status | Price |
|---|---|---|---|
| Azure Data Factory with Power BI This class is free for Recent Masters Graduates |
Jan 23 | Open | $2,500.00 |
TO RESERVE YOUR SPOT:
Call: (540) 449-5501
E-mail: vijay@vxltraining.com
$500 payment immediately to reserve your spot and balance after the first day of class.
All of our credit card payments are processed by PayPal and are 100% secure.
You MUST EMAIL US with:
1) Name 2) Phone Number and 3) The Course you have signed up for, after you make your payment.
Please select the Option and Click on the Buy Now Button to pay for your class
Please select the Class and Option and Click on the Buy Now Button to pay for your class
Curriculum
This Class will be Power BI and Azure Datafactory Together. Please look at our Power BI course for the contents of the Power BI section of this course.
Unit 1 ) Relational Data Stores AND SQL in Azure
- Introduction to Relational Data Stores
- Hands-on: Create a Single Database Using Azure Portal
- Hands-on: Create a managed instance
Assignments in Unit 1
Unit 2 )
- Data Analytics Tools and Concepts in Azure
- Azure Data ware House Concepts
- Star schema and snowflake schemas
Unit 3)Azure Data Factory
- Flow Process of Data Factory
- Why Azure Data Factory
- Integration Runtime in Azure Data Factory
Azure data factory Pipelines.
• Copy data in cloud
• Copy on-premises data to cloud
• Copy data in bulk
• Copy data incrementally
• Load ADLS Gen2
• Load SQL DW
• Load SAP BW
Assignments in Data Factory Pipelines.
Azure Data Factory Dataflows
- Data transformation
- What are mapping data flows?
- Create data flow
- Data flow expression language
- Debug data flow
- Execute data flow activity inside pipeline
- Monitor data flow
- Data flow performance
ADF transformations :
New Branch, Condition split, Join, Lookup, Union, Derived Column, Aggregate, Alter Row, Pivot…
Assignments in Data Factory Flows.
Unit 4) Data Lake and Azure Cosmos DB
- Data Lake Key Concepts
- Azure Cosmos DB
- Why Azure Cosmos DB?
- Azure Blob Storage
- Why Azure Blob Storage?
Hands-on:
Working with Azure Cosmos DB
Unit 5) Azure Data Bricks
- What is Azure Databricks?
- Azure Spark-based Analytics Platform
- Apache Spark in Azure Databricks
- Hands-on: Run a Spark Job on Azure Databricks using the Azure portal
- Hands-on: ETL Operation by using Azure Databricks
- Hands-on: Stream data into Azure Databricks using Event Hubs
Assignments in Data Factory Data Bricks.
UNIT 6) Azure Stream Analytics
- Working of Stream Analytics
- Key capabilities and benefits
- Hands-on: Analyse phone call data with stream analytics and visualize results in Power BI dashboard
- Stream Analytics Windowing Functions
- Tumbling window
- Hopping Window
- Sliding Window
- Session Window
UNIT 7) Azure synapse Analytics
- Working with Azure synapse Analytics
- Create object in Azure synapse
- Loading the data from Various sources to Azure Synapse
- Creating Power BI reports based on Azure Synapse.
Unit 8) Monitoring & Security
- What is Azure Monitor?
- Metrics
- Logs
- Metrics Vs Logs
- What data does Azure Monitor collect?
- What can you Monitor?
- Insights and Core Solutions
- Alerts in Azure
- Flow of Alerts
- Key Attributes of an Alert Rule
- What can you set alert on?
- Manage alerts
- Alert States
- How to create an alert?
- Hands-on: Create, View, and Manage Metric alerts using Azure Monitor
- Hands-on: Monitor your Azure Data Factory Pipelines proactively with Alerts
- Azure Security Logging & Auditing
- Types of Logs in Azure
- Azure SQL Database Auditing
- Server-level vs. Database-level Auditing Policy
- Hands-on: Azure SQL Database Auditing
Project 1 )
Financial Data loading using Azure Data Factory from On premise source system to AZURE SQL DB Datawarehouse.
Project 2 )
Purchasing,Inventory,Production data Data loading using Azure Data Factory from On premise source system to AZURE SQL DB Datawarehouse.
Class Location
22710 Haggerty Rd
Ste 191
Farmington Hills MI 48335
Class Timings
Sat - Sun 1pm - 4pm
Wed - Fri - 7PM - 9PM
Office Location
22710 Haggerty Rd
Ste 191
Farmington Hills MI 48335
FAQ
You don’t need any prior knowledge of Business Intelligence for this course. Our course is designed to train you on everything you need to be a skillful Business Intelligence professional. You should just be willing to work hard and complete all projects on time
Other Information
Any Questions Please call me at 540-449-5501
or
Email: vijay@vxltraining.com
This class is free for Recent College Graduates!
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign are trademarks or registered trademarks of SAP AG.