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 | |
---|---|---|---|
Azure BI |
SQL Server with Azure BI |
SQL Server with Azure BI, SQL DBA |
|
Total Duration | 18 Weeks | 20 Weeks | 24 Weeks |
MSBI - SSIS: ETL, Data Warehouse | ✔ | ✔ | ✔ |
MSBI - SSIS: Dimension, Fact Loads | ✔ | ✔ | ✔ |
MSBI - SSIS: Star & Snowflake Schemas | ✔ | ✔ | ✔ |
MSBI - SSAS: OLAP Cube Design | ✔ | ✔ | ✔ |
MSBI - SSAS: MDX, DAX, XMLA, DMX | ✔ | ✔ | ✔ |
MSBI - SSAS: Data Modeling with MDX | ✔ | ✔ | ✔ |
MSBI - SSAS: Data Modeling with DAX | ✔ | ✔ | ✔ |
MSBI - SSRS: Report Design, Hosting | ✔ | ✔ | ✔ |
MSBI - SSRS: Azure Cloud Data Source | ✔ | ✔ | ✔ |
MSBI: MCSA Certification Guidance | ✔ | ✔ | ✔ |
MSBI: Real-Time Project | ✔ | ✔ | ✔ |
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 | ✔ | ✔ | ✔ |
Azure SSIS | ✔ | ✔ | ✔ |
Azure Analysis Services | ✔ | ✔ | ✔ |
DP 500 [ADE + Power BI] | ✔ | ✔ | ✔ |
SQL: Database Basics, T-SQL | ❌ | ✔ | ✔ |
SQL : Constraints, Joins, Queries | ❌ | ✔ | ✔ |
T-SQL : Queries, SProcs, Lock Hints | ❌ | ✔ | ✔ |
SQL: Views, Group By, Self Joins | ❌ | ✔ | ✔ |
Total Course Fee *
*Course Payable in Installments |
INR 63,000 USD 852 |
INR 67,000 USD 906 |
INR 84,000 USD 1136 |
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 | Mar 14th | Register |
2 | 8 AM - 9 AM | Feb 21st | Register |
3 | 9 AM - 10 AM | Feb 7th | Register |
4 | 12:30 PM - 1:30 PM | Feb 14th | Register |
5 | 6 PM - 7 PM | Feb 2nd | Register |
6 | 8 PM - 9 PM | Feb 28th | Register |
7 | 9 PM - 10 PM | Mar 20th | Register |
Power BI Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
8 | 8 AM - 9 AM | Mar 15th | Register |
9 | 12:30 PM - 1:30 PM | Mar 8th | Register |
10 | 9 PM - 10 PM | Feb 15th | 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: SQL SERVER INTRODUCTION
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 9: JOINS, T-SQL QUERIES Level 3
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 6 : CONSTRAINTS,INDEXES Basics
|
Ch 10: VIEW, SPs, Function Basics
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: JOINS, T-SQL Queries : Level 1
|
Ch 11: Triggers & Transactions
|
Ch 4: SQL BASICS - 2
|
Ch 8: Group By, T-SQL Queries Level 2
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Real-time Case Study - 1
(Sales & Retail)
Objective : Database Design, Table Design and Relations. Involves Purchases, Products, Customers and Time Data with Various Data Types. |
Real-time Case Study - 2
(Sales & Retail)
Objective : Queries, Excel Integration Pivot Tables, Pivot Charts, ODC Connections |
SQL Server Integration Services (SSIS) |
SQL Server Analysis Services (SSAS) |
SQL Server Reporting Services (SSRS) |
Ch 1: SSIS INTRO, INSTALLATION
|
Ch 1: SSAS INTRO, CONFIGURATION
|
Ch 1: SSRS INTRO, INSTALLATION
|
Ch 2: SSIS ETL PACKAGES: BASICS
|
Ch 2: CUBE DESIGN WITH SSAS, EXCEL
|
Ch 2: BASIC REPORT DESIGN
|
Ch 3: MERGE & FUZZY LOOKUP
|
Ch 3: HIERARCHIES, MDX - LEVEL 1
|
Ch 3: GROUPING, REPORT PARAMETERS
|
Ch 4: SSIS CHECKPOINT & PIVOT
|
Ch 4: CALCULATIONS, MDX - LEVEL 2
|
Ch 4: CHARTS, DASHBOARDS, FITLERS
|
Ch 5: EVENTS, LOOPS, EXPRESSIONS
|
Ch 5: PARTITIONS & AGGREGATIONS
|
Ch 5: EXPRESSIONS, SHARED DATASETS
|
Ch 6: SSIS with ETL, Warehouse (DWH)
|
Ch 6: KPIs, OLAP CUBE DEPLOYMENTS
|
Ch 6: REPORT BUILDER, GAUGES
|
Ch 7: Checksum & DWH Design
|
Ch 7: TABULAR CUBE DESIGN
|
Ch 7: REPORT BUILDER, MAP REPORTS
|
Ch 8: CDC Transformations for DWH
|
Ch 8: TABULAR MODE CUBES, DAX - 1
|
Ch 8: REPORT MANAGEMENT
|
Ch 9: Fact Table Design, DWH Loads
|
Ch 9: TABULAR MODE - DAX LEVEL 2
|
Ch 9: MOBILE, KPI, CUBE REPORTS
|
Ch 10: DWH MIGRATIONS, SCRIPT Task
|
Ch 10: OLAP DATABASE MANAGEMENT
|
Ch 10: PROJECT WORK in SSRS
|
Ch 11: SSIS DEPLOYMENTS, UPGRADES
|
Ch 11: Real-time Project for SSAS
|
End to End Implementation (Real-time)
|
Ch 12: Realtime Project for SSIS & DWH
|
Ch 12: Integration with Power BI [Plan C]
|
MSBI Resume Guidance, Interview FAQs
|
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
|
Azure SSIS Training Content |
Chapter 1: SSIS Migrations to Azure Data Factory Provision Azure SQL Server Integration Services; SSIS DB Creation and Configuration Recommendations; Node Size, Node Number and Edition / License Options; Count, Parallel Execution Settings and DIUs; Edition Settings, logical SQL Server Configurations; SSIS DB Access from SSMS, SKU & Edition Checks; SSIS Package Validations with Connection Parameters; Generation of ISPAC Files in On-Premise, Validations; SSIS Catalog Database, Catalog Folders Creation; SSIS Deployments with ISPAC to Azure SSIS Catalog DB; Package Verifications and Acess from ADF Portal; SSIS Package Execution from ADF Portal, SSIS Store; |
Chapter 2: Azure SSIS from Visual Studio (SSDT) Accessing Azure Data Factory Resource from SSDT; Storage Account and BLOB Container Configurations; Azure SQL Server Deployment for SSIS Catalog DB; Configuring Azure Data Factory, Azure SSIS IR; Using Azure Enabled Integration Services Project in SSDT; Enabling, Linking ADF Account to SSIS Project; Using Azure BLOB Upload Task in SSIS - SSDT Tool; Storage Account, Access Key & Authentication Tests; SSIS Import and Export Operations with Azure; Excel Sheet to Azure SQL Database Tables in SSIS; Connection Settings and Package Executions in Azure; PIVOT Operations in SSIS, Data Uploads to Azure; |
Chapter 3: SSIS Packages with Azure Feature Pack Azure Feature Pack Installations and Real-time Usage; Using Azure BLOB Destination with ETL in SSIS; Using Azure SQL Server Databases with ETL in SSIS; SSIS Package Design with Azure Connections, Parameters; Azure SSIS Runtime Configurations, SSIS DB usage; Azure SSIS Package Executions with T-SQL Scripts; Real-time Considerations with Azure SSIS Migrations; Security Options - Data Security at Rest, TDE Options; Tools - Azure SSIS IR Customizations and Precautions; Pricing - Azure Hybrid Benefit (AHB), DIU and DTU Costs; 3rd Party Tools - Azure SSIS Feature Pack, IR Customization; Networking - Odata Sources, WAN & VNET Considerations; |
Chapter 4: Elastic Jobs with Azure SSIS DB Working with Azure SSIS DB - Standard Edition; Elastic Job Agent Service and Job Databases; Creating Master Keys and Database Credentials; Job Database Configurations with T-SQL Scripts; Testing Elastic Jobs from Azure Portal, T-SQL; Setting Retention Window in Azure SSIS DB with T-SQL; Start, Stop & Schedule Azure SSIS IR; Working with Web Activity in Azure Data Factory; Web Activity : PUSH / PULL Settings, Messages; Azure Management URLs, Azure SSIS IR Start & Stop; MSBI Authentication with Web Activity, Security; Execute SSIS Package Activity with ADF Pipeline; ADF Trigger Schedules and Tumbling Window; |
Chapter 5: Azure SSIS Projects : Versioning, ADF Jobs Azure SSIS Projects : Deployments and Exports; Azure SSIS Projects : Improts to SSDT Environment; Enabling ADF for Existing SSIS Projects, Parameters; SSIS Package Deployments. Deployment Rollbacks, LSN; Creating ADF Jobs from SSMS - using SSIS Schedules; Trigger Edits and Configuration Settings with ADF Jobs; Azure SSIS - Security Management; Creating Logins and Users in Azure SQL Server; User Mapping with SSIS Catalog Database, Scripts; Folder Level and Project Level Permissions in SSSDB; Read, Modify and Manage Permissions in SSIS DB; Principal IDs and Permission Types, Object Types; IAM : ADF Security @ Azure Active Directory Users, Groups; |
Azure SSAS Training Content |
Chapter 1: Azure Analysis Services OperationsAzure Analysis Services : Architecture and Purpose; PaaS Implementation of SSAS in Azure Cloud; Azure Analysis Services : Advantages over MSBI SSAS; Deployment, Integration and Low Cost of Ownership; Server Side Encryption (SSE) with Azure BLOB Data; SSAS Data Models with Azure Analysis Services; Deployment Options and Workflow Operations; Azure Analysis Services: Query Processing Unit (QPU); Service Tiers (Plans): Developer, Basic and Standard; Data Source Types and In-Memory Options in AS; Creating and Connecting to Azure Analysis Services; Sample Models: Creation, Connection and Analytics; |
Chapter 2: Data Models with Azure Analysis ServicesCreating Data Models in SQL Server Data Tools; Tabular Mode Data Models with Azure SQL Database; Working with In-Memory Xvelocity Vertipaq Database; Multi Factor Authentication (MFA) with SSMS Tool; Creating Analysis Services Tabular Mode Projects; Compatibility Levels and Integrated Workspace; Navigators, In-Memory Data Processing & Cubes; Data Model Deployments with Azure Analysis Server; Dimension & Attribute Identification in Data Models; Aggregated Measures, KPIs and Excel Data Analytics; Creating Hierarchies and Attribute Relations; Azure Active Directory Authentication For Azure AS; |
Chapter 3: Azure Data Sources and DAX CalculationsAzure Synapse (Data Warehouse) Data Sources; Azure Storage Tables and Azure Files (BLOB) Data; Azure Cosmos Databases for Azure Analysis Services; Using SMK: Service Managed Key for Data Models; Using Azure Active Directory (AAD) Users and Groups; Using Azure Service Principals and Tenants for Azure AS; Using Service Vaults for Authentication Options; Direct Query and Import Options with Azure Sources; DAX Implementations with Azure Data Sources; DAX Measures and DAX Calculations for Attributes; Formatting Date and Time Calculations with DAX; YoY, YTD, MoM, QTD, YTD, MTD DAX Calculations; |
Chapter 4: Azure AS with On-Premise Data SourcesAccessing On-Premise Data Sources For Azure AS; OnPremise Versus Azure Analysis Services; MSMDSRV.EXE Versus Azure PaaS Components; Azure Storage Account For Azure AS OLAP DB Store; In-Memory Vertipaq Database Concepts with OLAP; MCE : Maximum Core Entitlement with Azure OLAP; On-Premise OLAP Cube Deployments (Tabular); Migrating On-Premise to Azure Analysis Services; Creating abf Files with On-Premise OLAP Database; Creating and Using Azure Storage Containers; Restoring abf Files in Azure Analysis Services (PaaS); Testing OLAP DB Migrations with Excel Analyzer; |
Chapter 5: Azure AS Data Model ManagementStart & Stop Options. Scale Up & Scale Down Options; Azure Analysis Services: Monitoring, Activity Logs; Event Severity, Quick Insights and Usage Metrics; Diagnostic Events, Errors and Alerts in Azure AS; Configure OLAP Database Replica, Backups & Restores; Detach and Attach OLAP Databases, Migrations; IAM : Identity and Access Management with Azure AS; Analytical Role, Monitor Role in Azure AS Data Models; Owner Role, Contributor Role & Reader Role; AD User Permissions, Firewall, Alerts and Metrics; Firewalls, Data Security and Row Level Security; Common Errors and Solutions with Azure Analysis; |
Chapter 6: End to End Implementation with Azure ASCreating Azure Data Sources and Azure Synapse; Creating Azure Analysis Services Resources, Models; Creating Data Models with Azure Synapse Databases; Tabular Mode Data Models : Design and Compatibility; Data Imports, Data Preview, Processing & Deployment; DAX For Aggregated Measures, Aggregated Columns; RLS: Row Level Security Implementation with DAX; OLAP Deployment Options and OLAP Server Settings; OLAP Database Builds and Deployment Target Files; XMLA Scripts, OLAP DB Scripting & Cloning Options; Power BI for Azure Analysis Services Data Models; Interactive Reports Design with Azure OLAP Databases; |
Module I: SQL Server & T-SQLInstallation, Architecture, DB Basics |
Module II: Basic SQL DBABackup-Restores, Jobs, Performance Tuning, Security |
Module III: Advanced SQL DBAHA-DR, Errors & Solutions, Always-On, SLA |
Ch 1: JOB ROLES, INSTALLATION
|
Ch 10: BACKUPS - DB, Filegroup, File
|
Ch 19: REPLICATION For HA - Level 1
|
Ch 2: SSMS Tool, SQL BASICS - 1
|
Ch 11: RESTORES & DB RECOVERY
|
Ch 20: REPLICATION For HA - Level 2
|
Ch 3: SQL BASICS For DBAs - 2
|
Ch 12: JOBS, MAINTENENCE PLANS
|
Ch 21: LOG SHIPPING (HA - DR)
|
Ch 4: SCHEMAS, TEMP TABLES
|
Ch 13: SECURITY MANAGEMENT - 1
|
Ch 22: DB MIRRORING (HA - DR)
|
Ch 5: CONSTRAINTS, INDEX Basics
|
Ch 14: MIGRATIONS & SECURITY - 2
|
Ch 23: Health Checks, Issues, Solutions
|
Ch 6: JOINS & AUDITS
|
Ch 15: Tuning 1 - Audits, Indexes
|
Ch 24: PATCHES, UPGRADES, CUs
|
Ch 7: View, Procedures, UDF Basics
|
Ch 16: Tuning 2 - INDEX MANAGEMENT
|
Ch 25: ALWAYS ON AVAILABILITY
|
Ch 8: Triggers & Transactions
|
Ch 17: Tuning 3 - Tuning Tools
|
Ch 26: SQL DBA PROJECT - Level 1
|
Ch 9: Server, DB Architecture
|
Ch 18: Tuning 4 - Lock Management
|
Ch 27: SQL DBA PROJECT - Level 2
|
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