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 Training includes EVERY detail. From very basics - Installation, details of each Power BI Visual, On-premise and Cloud Data Access, Azure Integration, Data Modelling and ETL Techniques, Power Query (M Language), DAX Functions, Variables, Parameters, Power BI Dashboards, App Workspace, Data Gateways, Alerts, Power BI Report Server Components, Power BI Mobile Reports, Excel Integration, Excel Analysis, KPIs, Microsoft PL 300 Certification guidance, 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 | 4 Weeks | 7 Weeks | 14 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 | ✔ | ✔ | ✔ |
PL 300 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 | ❌ | ✔ | ✔ |
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 : Workspace, Delta Tables | ❌ | ❌ | ✔ |
DP 203 Certification Guidance | ❌ | ❌ | ✔ |
DP 500 Certification Guidance | ❌ | ❌ | ✔ |
Total Course Fee* | INR 12000 USD 150 |
INR 17000 USD 200 |
INR 42000 USD 500 |
SQL Server & T-SQL Schedules | ||||
S No | Time (IST, Mon - Fri) | Start Date | ||
---|---|---|---|---|
1 | 6 AM - 7 AM | Oct 24th | Register | |
2 | 8 AM - 9 AM | Oct 18th | Register | |
3 | 6 PM - 7 PM | Sep 26th | Register | |
4 | 8 PM - 9 PM | Nov 6th | Register | |
5 | 9 PM - 10 PM | Oct 4th | Register |
Power BI Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
6 | 8 AM - 9 AM | Nov 14th | Register |
7 | 9 AM - 10 AM | Oct 2nd | Register |
8 | 6 PM - 7 PM | Dec 12th | Register |
9 | 8 PM - 9 PM | Oct 10th | Register |
Azure Data Engineer Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
10 | 7 AM - 8 AM | Oct 3rd | Register |
11 | 7 PM - 8 PM | Sep 25th | Register |
If above schedules does not work for you, please register for Power BI Training Videos
Custom Visuals | Power BI Mobile |
Big Data Sources | Big Data, JSON |
Excel Analysis | Excel Online |
Google Big Query | Report Server |
Gateways, Rest API | Power BI Admin |
✔ Tabular Mode | ✔ Data Models |
✔ Tabular Mode OLAP | ✔ Tabular Mode DAX |
✔ Cube Design | ✔ Excel Analytics |
Ch 1: DATABASE INTRODUCTION
|
Ch 5: SQL Basics - 3, TSQL INTRO
|
Ch 9: Functions, Procedures Basics
|
Ch 2: SQL SERVER INSTALLATION
|
Ch 6: Constraints, Index Basics
|
Ch 10: TRIGGERS & TRANSACTIONS
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: Joins Basics, TSQL Queries
|
Ch 11: Normal Forms, Cursors
|
Ch 4: SQL BASICS - 2
|
Ch 8: Group By, Views & Excel
|
Ch 12: TSQL Merge, Cursors
|
Case Study 1: Database Design with Tables, Constraints, Keys & Relations |
Case Study 2: Joins with Group By, Sub Queries, Views, Excel Analytics |
Part 1: Power BI Report Design |
Part 2: Power Query, Cloud (Service) |
Part 3: DAX & Report Server |
Ch 1: POWER BI INTRODUCTION
|
Ch 7: POWER QUERY LEVEL 1
|
Ch 13: DAX Functions - Level 1
|
Ch 2: Basic Report Design
|
Ch 8: POWER QUERY LEVEL 2
|
Ch 14: DAX Functions - Level 2
|
Ch 3: Visual Interaction, Visual Sync
|
Ch 9: POWER QUERY LEVEL 3
|
Ch 15: DAX Functions - Level 3
|
Ch 4: Grouping & Hierarchies
|
Ch 10: POWER BI CLOUD - 1
|
Ch 16: DAX Functions - Level 4
|
Ch 5: Filters & Bookmarks
|
Ch 11: POWER BI CLOUD - 2
|
Ch 17: Power BI Report Server
|
Ch 6: Big Data Access, Visuals
|
Ch 12: POWER BI CLOUD - 3
|
Ch 18: Power BI Admin & AI
|
Power BI : Realtime Project (Sales - Retail) |
||
Phase 1 : Basic Report Design
|
Phase 2 : SME Level
|
Phase 3: Deployments (Cloud, Server)
|
Part 1: Azure Data Factory, Synapse Analytics |
Part 2: Data Lake Storage, Stream Analytics |
Part 3: Databricks, Spark, Python |
||
Chapter 1: Cloud Basics, Azure SQL
|
Chapter 1: Azure Fundamentals - Storage
|
Chapter 1: Azure Intro, Azure Databricks
|
||
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 2: Azure Storage Operations
|
Chapter 2: SparkDatabase, SQL Notebooks
|
||
Chapter 3: Azure Data Factory, Pipelines
|
Chapter 3: Azure Storage Security, ACLs
|
Chapter 3: Python Intro, Data Loads
|
||
Chapter 4: OnPremise Data Loads, Upsert
|
Chapter 4: SQL Database Migrations
|
Chapter 4: PySpark with ADLS
|
||
Chapter 5: File Incremental Loads in ADF
|
Chapter 5: Azure Tables & Replication
|
Chatper 5: PySpark Widgets
|
||
Chapter 6: ADF Data Flow - 1
|
Chapter 6: Azure Stream Analytics, IoT
|
Chapter 6: Architecture, Workflows
|
||
Chapter 7: ADF Data Flow - 2
|
Chapter 7: Azure Event Hubs
|
Chapter 7: Databricks Security, Scala
|
||
Chapter 8: Azure Synapse Analytics
|
Chapter 8: Storage Architecture, Queues
|
Chapter 8: Scala with ADLS, Azure SQL
|
||
Chapter 9: Synapse Analytics with Spark
|
Chapter 9: Monitoring & Key Vaults
|
Chapter 9: DeltaLake Incr Loads, DWH
|
||
Chapter 10: Synapse Security & Parameters
|
Real-time Project (End to End)
|
|||
Chapter 11: Change Data Capture (CDC)
|
Azure Data Engineering with Power BI (For Power BI Registrations)
|
Above course curriculum applicable for registrations from Sep 1st, 2023
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!