This impeccable Azure BI Training course is carefully designed for aspiring BI Developers, Consultants and Azure Professionals. This Azure BI Online Training includes basic to advanced Azure Data Factory (ADF), Azure Storage, Azure Data Lake (ADL) and Azure Analysis Services (AAS) concepts with Real-time Project on End to End Implementation. This Azure BI Online Training course also includes Azure Migrations, Azure DataWarehouse (ADW) [Azure Synapse], Azure Data Bricks for Big Data Analytics, helpful for your next Job as well as to reshape your resume.
Complete practical and realtime Azure BI Training course with 24x7 LIVE server, Resume Guidance, ONE Real-time Project with Interview & Placement Assistance.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
1. Azure Data Engineer 2. Power BI |
1. Azure Data Engineer 2. Power BI 3. Python |
1. SQL Server 2. Azure Data Engineer 3. Power BI 4. Python |
|
Total Duration | 11 Weeks | 15 Weeks | 18 Weeks |
Power BI: Report Design, Visuals | ✔ | ✔ | ✔ |
Power BI: M Lang, DX for ETL | ✔ | ✔ | ✔ |
Power BI: Report Server, Admin | ✔ | ✔ | ✔ |
ADF : Azure Data Factory | ✔ | ✔ | ✔ |
ADF : Data Imports, ETL | ✔ | ✔ | ✔ |
ADF : Data Flows, Wrangling | ✔ | ✔ | ✔ |
ADF : Transformations, ETL | ✔ | ✔ | ✔ |
Synapse: Configuration, Loads | ✔ | ✔ | ✔ |
Synapse: ETL with ADF, DWH | ✔ | ✔ | ✔ |
Synapse: Performance Tuning | ✔ | ✔ | ✔ |
Synapse: MPP, cDWH, DIUs | ✔ | ✔ | ✔ |
ADB : Azure Data Bricks | ✔ | ✔ | ✔ |
ADB : Architecture, Data Loads | ✔ | ✔ | ✔ |
ADB : Run Spark Jobs, Pools | ✔ | ✔ | ✔ |
ADB : Workspace, Delta Tables | ✔ | ✔ | ✔ |
Storage : Storage & Containers | ✔ | ✔ | ✔ |
Storage: BLOB Imports | ✔ | ✔ | ✔ |
Storage: Security | ✔ | ✔ | ✔ |
DP 500 [ADE + Power BI] | ✔ | ✔ | ✔ |
Python Jupyter Notebooks | ❌ | ✔ | ✔ |
Python Functions, JSON | ❌ | ✔ | ✔ |
Python for Big Data Analytics | ❌ | ✔ | ✔ |
Python Data Frames, Pandas | ❌ | ✔ | ✔ |
SQL: Database Basics, T-SQL | ❌ | ❌ | ✔ |
SQL : Constraints, Joins, Queries | ❌ | ❌ | ✔ |
T-SQL : Queries, SProcs, Lock Hints | ❌ | ❌ | ✔ |
SQL: Views, Group By, Self Joins | ❌ | ❌ | ✔ |
Total Course Fee* | INR 37000 USD 465 |
INR 59000 USD 725 |
INR 64000 USD 810 |
Trainer: Mr. Sai Phanindra T
All Session Are Completely Practical & Real Time
SQL Server & T-SQL Schedules | ||||
S No | Time (IST, Mon - Fri) | Start Date | ||
---|---|---|---|---|
1 | 6 AM - 7 AM | Dec 5th | Register | |
2 | 8 AM - 9 AM | Dec 13th | Register | |
3 | 6 PM - 7 PM | Nov 22nd | Register | |
4 | 8 PM - 9 PM | Jan 22nd | Register | |
5 | 9 PM - 10 PM | Dec 19th | Register |
Power BI Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
6 | 8 AM - 9 AM | Jan 3rd | Register |
7 | 6 PM - 7 PM | Dec 11th | Register |
8 | 8 PM - 9 PM | Dec 25th | Register |
Azure BI Training Highlights :
✔ Azure Fundamentals | ✔ Azure AD |
✔ Azure SQL Concepts | ✔ Azure Migrations |
✔ Azure AD | ✔ Azure Key Vaults |
✔ Azure Monitor | ✔ Azure Functions |
✔ Azure Data Factory | ✔ Azure Synapse |
✔ Azure Synapse | ✔ Azure Strorage |
✔ Data Lake Storage | ✔ Data Lake Analytics |
✔ Stream Analytics | ✔ IoT, Event Hubs |
✔ Azure Cosmos DB | ✔ Azure Databricks |
✔ Azure Notebooks | ✔ U-SQL & NoSQL |
✔ Python, Scala | ✔ Spark Clusters |
✔✔ End to End Real-time Project @ Resume |
Ch 1: DATABASE INTRODUCTION
|
Ch 6: CONSTRAINTS, INDEXES
|
Ch 11: TRIGGERS & TRANSACTIONS
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 7: JOINS BASICS, TSQL QUIRIES
|
Ch 12: NORMAL FORMS, MERGE
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 8: GROUP BY, LINKED SERVERS
|
Ch 13: TSQL Queries: Group By, Joins
|
Ch 4: SQL BASICS - 2
|
Ch 9: VIEWS - BASICS, DATA TYPES
|
Ch 14: Architecture, Cursors & CTEs
|
Ch 5: SQL Basics - 3, TSQL INTRO
|
Ch 10: FUNCTIONS, PROCEDURES BASICS
|
Case Study 1 - Database, Table Design
Case Study 2 - Query Writing |
Part 1: Power BI Report Design |
Part 2: ETL, Data Modeling, DAX |
Part 3: Power BI Cloud, Admin |
Ch 1 : POWER BI BASICS
|
Ch 7 : POWER QUERY LEVEL 1
|
Ch 13 : POWER BI CLOUD - 1
|
Ch 2: BASIC REPORT DESIGN
|
Ch 8 : POWER QUERY LEVEL 2
|
Ch 14 : POWER BI CLOUD - 2
|
Ch 3 : Visual Sync, Grouping
|
Ch 9 : POWER QUERY LEVEL 3
|
Ch 15 : EXCEL & RLS
|
Ch 4 : Hierarchies, Filters
|
Ch 10 : DAX Functions - Level 1
|
Ch 16 : Report Server, RDL
|
Ch 5 : Bookmarks, Azure, Modeling
|
Ch 11 : DAX Functions - Level 2
|
Ch 17: MSBI Integrations
|
Ch 6 : Visualization Properties
|
Ch 12 : DAX FUNCTIONS Level 3
|
Ch 18 : REAL-TIME PROJECT
|
Mod 1: Azure Data Factory [ADF], Synapse |
Mod 2: Azure Storage & Stream Analytics |
Mod 3: Azure Databricks & SparkSQL |
Chapter 1: Cloud Basics, Azure SQL DB
|
Chapter 1: Azure Storage & Containers
|
Chapter 1: Azure Intro, Azure Databricks
|
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 2: Azure Migration, BLOB Imports
|
Chapter 2: SQL Notebooks & Python
|
Chapter 3: Azure Data Factory Concepts
|
Chapter 3: Azure Tables, Shares
|
Chapter 3: Python Notebooks
|
Chapter 4: ADF Pipelines, Polybase
|
Chapter 4: Azure Storage Security, Admin
|
Chapter 4: Open Data Sources, DeltaLakes
|
Chapter 5: OnPremise Data with ADF
|
Chapter 5: Azure Monitoring, Power BI
|
Chapter 5: Databricks Security & Jobs
|
Chapter 6: ADF Data Flow - 1
|
Chapter 6: Azure Stream Analytics, IoT
|
Chapter 6: Databricks @ BLOB, Power BI
|
Chapter 7: ADF Data Flow - 2
|
Chapter 7: IoT Hubs & Event Hubs
|
Chapter 7: Databricks Integrations
|
Chapter 8: Azure Synapse Analytics
|
Chapter 8: Azure Stream Analytics Security
|
|
Chapter 9: Synapse Analytics with Spark
|
||
Chapter 10: Incremental Loads @ Synapse
|
||
Chapter 11: Optimizations, Power Query
|
||
Chapter 12: Pipeline Monitoring, Security
|
Part 1: Python Fundamentals |
Part 2: Python For Data Analytics - 1 |
Part 3: Python For Data Analytics - 2 |
Ch 1: Data Analytics Intro & Python
|
Ch 7: Python Functions
|
Ch 13: Data Analytics - Pandas
|
Ch 2: Basic Operations with Python
|
Ch 8: Python Classes & Arrays
|
Ch 14: Data Analytics - DataFrames
|
Ch 3: Data Types & Variables
|
Ch 9: Python Modules
|
Ch 15: Data Analytics - Pandas
|
Ch 4: Python Operators, Conditions
|
Ch 10: Python JSON & RegEx
|
Ch 16: SQL Server with Python - 1
|
Ch 5: Python Loops, Iterations
|
Ch 11: Python User Inputs & TRY
|
Ch 17: SQL Server with Python - 2
|
Ch 6: Python Collections
|
Ch 12: Python File Handling
|
Ch 18: Power BI with Python
|
SQL School Training Institute is at your reach, 24 x 7 for Trainings, Jobs and Placements on SQL Server, SQL DBA, MSBI Trainings. Also include Azure SQL, Azure DBA, Azure BI and Power BI Training Courses. We provide LIVE Online Training, In-house Classroom Training as well as On-demand Video Tranings and Certification Trainings - 24 x 7. All our trainings are completely real-time and 100% practical. We provide Placement and Consulting Services in addition to Project Oriented Trainings. Register Today for Free Demo