Complete Real-time and Practical Power BI Training with Real-time Scenarios. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed, efficiency, and understanding.
This Power BI Online Training includes EVERY detail of each Power BI Visual, Usage and Properties as per the latest versions. This Power BI course includes On-premise and Cloud Data Access, REST API, Azure Stream and R Integration including Data Modelling and ETL Techniques with Basic to Advanced Power Query (M Language), DAX Language Functions, Power BI Dashboards, Streaming Datasets, App Workspace, Content Packs, Data Gateways, Alerts, Power BI Report Server Components, Power BI Mobile Reports, Excel Integration, Excel Analysis, KPIs for Big Data Analytics, DataFlows and Microsoft DA 100 Certification are also a part of this Power BI Online Training course in addition to Mock Interviews, Resume Guidance, Concept wise Interview FAQs and ONE Real-time Project.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Course includes | Power BI | T-SQL, Power BI |
T-SQL, Power BI, Azure Data Engineer |
Total Duration | 3.5 Weeks | 5.5 Weeks | 11.5 Weeks |
Power BI Report Design | ✔ | ✔ | ✔ |
Power BI Desktop, Custom Visuals | ✔ | ✔ | ✔ |
Data Modelling with Power Query | ✔ | ✔ | ✔ |
Data Modelling with DAX | ✔ | ✔ | ✔ |
Power BI Cloud, Excel Analysis | ✔ | ✔ | ✔ |
Power BI Mobile, R, REST API | ✔ | ✔ | ✔ |
DA 100 Exam Guidance | ✔ | ✔ | ✔ |
Real-Time Project in Power BI | ✔ | ✔ | ✔ |
SQL Database, T-SQL Queries | ❌ | ✔ | ✔ |
Normal Forms, Joins, Query Tuning | ❌ | ✔ | ✔ |
Sub Queries, Stored Procedures | ❌ | ✔ | ✔ |
Excel Pivot Tables, Pivot Charts | ❌ | ✔ | ✔ |
Azure Fundamentals and Azure AD | ❌ | ❌ | ✔ |
Azure Data Factory & ETL Concepts | ❌ | ❌ | ✔ |
Azure Synapse Analytics, SQL Pools | ❌ | ❌ | ✔ |
Synapse Studio with Analytics Workspace | ❌ | ❌ | ✔ |
Azure Storage (BLOB), Data Lake Storage | ❌ | ❌ | ✔ |
Azure Data Lake Analytics & U-SQL | ❌ | ❌ | ✔ |
Azure Cosmos DB & NoSQL. Databricks | ❌ | ❌ | ✔ |
Python Notebooks and Spark Clusters | ❌ | ❌ | ✔ |
Azure Stream Analytics & SAQL for ETL | ❌ | ❌ | ✔ |
Azure Functions and Azure Key Vaults | ❌ | ❌ | ✔ |
Data Engineer Exam Guidance (DP 203) | ❌ | ❌ | ✔ |
Total Course Fee * |
INR 9,000/-
USD 122 |
INR 13,000/-
USD 176 |
INR 36,000/-
USD 487 |
Trainer: Mr. Sai Phanindra T
All Session Are Completely Practical & Real Time
Schedules for SQL Server & T-SQL | |||
S No | Timings (IST) | Start Date | |
---|---|---|---|
Regular Schedules [Mon - Fri] | |||
1 | 6 AM - 7 AM | July 5th | Register |
2 | 8 AM - 9 AM | Aug 2nd | Register |
3 | 10 AM - 11 AM | July 12th | Register |
4 | 6 PM - 7 PM | June 27th | Register |
5 | 8 PM - 9 PM | July 19th | Register |
6 | 9 PM - 10 PM | Aug 8th | Register |
Power BI Training Schedules | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Regular Schedules [Mon - Fri] | ||||
1 | 8 AM - 9 AM | Aug 30th | Register | |
2 | 6 PM - 7 PM | July 25th | Register | |
3 | 9 PM - 10 PM | July 11th | Register |
If above schedules does not work for you, please register for Power BI Training Videos
Custom Visuals | Power BI Mobile |
Big Data Sources | R, Python, JSON |
Excel Analysis | Excel Online |
Google Big Query | Report Server |
Gateways, Rest API | Power BI Admin |
✔ 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 |
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 |
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
|
1. Azure Fundamentals: What is Cloud? Advantages of Azure Cloud? IaaS, SaaS & PaaS. Azure Data Engineer Technologies, Job Roles. DP 200, 201 Exams Azure Account Registration and Free Trail Activation; Understanding Azure Resources and Resource Types; Creating Resource Groups in Azure Portal; | ||
2. Azure SQL Server: Azure Resources; Resource Groups; Azure SQL Server [Logical Server] Creation; Server Name Format and Firewall Rules; Azure Services Access with Firewall; Test Connections with SSMS Tool and Azure Data Studio Tool; Creating Azure SQL Databases in Portal, T-SQL; Tables, Data Inserts; | ||
3. Azure SQL DB Migrations: Azure SQL DB Migrations from OnPremise; Using Data Migration Assistant Tool; Migration Assessments; Deploy Schema & Migrate Data Options; Onpremise Versus Azure SQL DB Differences; Generating bacpac Files From SSMS Tool; Azure SQL DB Exports & Imports; |
Mod 1: Azure Data Factory, Azure Synapse, Azure Data Share, Azure Key Vaults |
Mod 2: Azure Storage, Azure Data Lake Storage, Azure Data Lake Analytics, U-SQL |
Mod 3: Azure Databricks, Azure Cosmos DB, Azure Stream Analytics, NoSQL |
Ch 1: Azure Data Factory, Synapse Intro
|
Ch 11: Azure Storage Concepts
|
Ch 21: Azure Databricks Configurations
|
Ch 2: Azure Synapse Architecture
|
Ch 12: Azure Tables & Azure BLOB
|
Ch 22: Databricks Notebooks, Spark Jobs
|
Ch 3: Azure Data Factory Architecture
|
Ch 13: Azure Files, Queues & Security
|
Ch 23: Python Notebooks & Operations
|
Ch 4: Azure Data Lake with ADF
|
Ch 14: Azure Monitor, KQL, Power Shell
|
Ch 24: Scala Notebooks, SQL Notebooks
|
Ch 5: On-Premise Data to Azure
|
Ch 15: Azure Stream Analytics, Event Hubs
|
Ch 25: Databricks Jobs & Power BI
|
Ch 6: Incremental Loads with ADF - 1
|
Ch 16: Azure Data Lake Storage (ADLS)
|
Ch 26: Azure Cosmos DB - Architecture
|
Ch 7: Incremental Loads with ADF - 2
|
Ch 17: ADLS Monitoring, Alerts
|
Ch 27: Azure Cosmos DB Queries Level 1
|
Ch 8: Mapping Data Flow in ADF
|
Ch 18: Azure Key Vaults & ADL Analytics
|
Ch 28: Azure Cosmos DB Queries Level 2
|
Ch 9: Wrangling Data Flow in ADF
|
Ch 19: Data Lake Analytics, U-SQL 1
|
Ch 29: Azure Notebooks, Azure Functions
|
Ch 10: ADF : End to End Implementation
|
Ch 20: Data Lake Analytics, U-SQL 2
|
Ch 30: Azure Cosmos Admin, Power BI
|
Real-time Project @ Ecommerce Domain: Includes On-Premise Migrations with bac Files, Azure Storage Compoments, Azure Data Ingestions using Azure Data Factory; Big Data Storage with Azure Synapse and Azure Cosmos Database; Big Data Analytics using Azure Databricks and Azure Stream Analytics. This Real-time Project also includes End User Reporting with Power BI. Additionally includes Resume Support and DP 200, DP 201 Certification Guidance. |
Complete Real-time and Practical Power BI Training with Real-time Scenarios. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports and compelling visualizations for your day to day corproate business data needs!