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 Classroom 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 Repots, Excel Integration, Excel Analysis, KPIs for Big Data Analytics, Microsoft OneDrive, Google Big Query Datasets and Facebook are also a part of this Power BI Classroom 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, MSBI |
Total Duration | 1 Month | 1.5 Months | 2.5 - 3 Months |
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 | ❌ | ✔ | ✔ |
Complete MSBI (SSIS, SSAS, SSRS) | ❌ | ❌ | ✔ |
ETL with DWH Database Design | ❌ | ❌ | ✔ |
OLAP Cube Design. MDX, DAX | ❌ | ❌ | ✔ |
SSRS Reports, Cube Reports | ❌ | ❌ | ✔ |
MSBI with Power BI Integration | ❌ | ❌ | ✔ |
MCSA Certification Guidance | ❌ | ❌ | ✔ |
End-to-End Project, Resume | ❌ | ❌ | ✔ |
Total Course Fee * |
INR 9,000/-
USD 122 |
INR 13,000/-
USD 176 |
INR 28,000/-
USD 380 |
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 | Feb 16th | Register |
2 | 8 AM - 9 AM | Feb 9th | Register |
3 | 6 PM - 7 PM | Jan 26th | Register |
4 | 8 PM - 9 PM | Jan 18th | Register |
5 | 9 PM - 10 PM | Feb 8th | Register |
Power BI Training Schedules | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Regular Schedules [Mon - Fri] | ||||
1 | 8 AM - 9 AM | Mar 9th | Register | |
2 | 6 PM - 7 PM | Feb 15th | Register | |
3 | 9 PM - 10 PM | Jan 19th | 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 |
SQL Queries & T-SQL Programming |
||
Ch 1: SQL SERVER INTRODUCTION
|
Ch 7: JOINS, T-SQL Queries : Level 1
|
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 8: Group By, T-SQL Queries Level 2
|
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 9: JOINS, T-SQL QUERIES Level 3
|
|
Ch 4: SQL BASICS - 2
|
Ch 10: View, SPs, Function Basics
|
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 11: Triggers & Transactions
|
|
Ch 6 : CONSTRAINTS,INDEXES BASICS
|
Ch 12 : ER MODELS, NORMAL FORMS
|
|
Real-time Case Study - 1
(Sales & Retail) Objective : DB Design, Table Design, Relations Involves Purchases, Products, Customers and Time Data with Various Data Types. |
Real-time Case Study - 2
(Sales & Retail) Objective : Query Writing, Excel Integration Excel Pivot Tables, Pivot Charts, Data Formatting, ODC Connections & Labelling |
Part 1: Power BI Report Design |
Part 2: ETL, Data Modeling, DAX |
Part 3: Power BI Cloud, Admin |
Day 1 : POWER BI BASICS
|
Day 7 : POWER QUERY LEVEL 1
|
Day 13 : POWER BI CLOUD - 1
|
Day 2: BASIC REPORT DESIGN
|
Day 8 : POWER QUERY LEVEL 2
|
Day 14 : POWER BI CLOUD - 2
|
Day 3 : Visual Sync, Grouping
|
Day 9 : POWER QUERY LEVEL 3
|
Day 15 : EXCEL & RLS
|
Day 4 : Hierarchies, Filters
|
Day 10 : DAX Functions - Level 1
|
Day 16 : Report Server, RDL
|
Day 5 : Bookmarks, Azure, Modeling
|
DAY 11 : DAX Functions - Level 2
|
Day 17: MSBI Integrations
|
Day 6 : Visualization Properties
|
Day 12 : DAX FUNCTIONS Level 3
|
Day 18 : REAL-TIME PROJECT
|
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
|
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!