Power BI Training Classes

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.

Power BI Training (DAX, Power Query, Cloud Service, Report Server Admin, Excel)

	PLAN A	PLAN B	PLAN C
Course includes	Power BI	Power BI & T-SQL	Power BI, T-SQL, MSBI
Job Roles (Applicable For)	Data Analysts Business Analyst	Business Analysts Power BI Dev	Microsoft BI Dev BI Consultant, Architect
Total Duration	3.5 weeks	6 weeks	12 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
Python Integration, Data Flows
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 (IS / AS/ RS)
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 8,000/-	INR 11,000/-	INR 23,000/-

Trainer & Profile : Mr. Sai Phanindra T

Timings (IST)		Course Start Date
Schedules for Power BI Training
1	9 AM - 10 AM	Oct 1st	Register
2	11:30 AM - 12:30 PM	Oct 2nd Week	Register
3	6:30 PM - 7:30 PM	Oct 21st	Register
Schedules for SQL Server & T-SQL Training
1	6:30 AM - 7:30 AM	Oct 3rd Week	Register
2	9 AM - 10 AM	Oct 21st	Register
3	10:15 AM - 11:15 AM	Sept 25th	Register
4	5:30 PM - 6:30 PM	Sept 23rd	Register
5	7:30 PM - 8:30 PM	Oct 11th	Register

If above schedules does not work for you, please register for Power BI Training Videos

TRAININGS ARE PRACTICAL, REAL-TIME.

TRAINING HIGHLIGHTS

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

Power BI Training Course Contents:

Brochure:

Register Today

Mod 1: SQL Server TSQL Queries Applicable for Power BI Plan B, C	Mod 2: Power BI Report Design Applicable for Power BI Plan A, B, C	Mod 3: ETL, Data Modelling Applicable for Power BI Plan A, B, C	Mod 4: Power BI Cloud, Admin Applicable for Power BI Plan A, B, C
SQL 1: SQL, Power BI Introduction Data, Databases & BI Technologies OLTP, DWH,OLAP,HTAP Databases BI and Data Science Components Power BI for Business Analysts Power BI for Data Scientists Real-time Job Responsibilities Versions, Editions of SQL Server Database Engine Service (OLTP) SQL Server 2017,2019 Installation Default and Named Instances Master, Model, MSDB, TempDB Resource Database, Login Types SQL Server Authentication Modes "sa" System Account, File Stream Local & Remote Lab Connections	PBI 1 : POWER BI BASICS Power BI Job Roles in Real-time Power BI Data Analyst Job Roles Business Analyst - Job Roles Power BI Developer - Job Roles Power BI for Data Scientists Comparing MSBI and Power BI Comparing Tableau and Power BI MCSA 70-778, MCSA 70-779 Exam Types of Reports in Real-World Power BI EcoSystem, Architecture Power BI Licensing Plans - Types Power BI Desktop Installation Power BI Desktop RS Installation Report Builder & RS Mobile Install Power BI Cloud Configuration	PBI 9 : POWER QUERY LEVEL 1 Power Query M Language Purpose Power Query - Operation Types Power Query Architecture and ETL QUERY Concept, Data Validations Power Query Mash Up Operations Data Types, Literals and Values M Language Expressions, Primitives Structured Data in Power Query LIST, RECORD and TABLE Power Query Connection Formats let, source, in statements @ M Lang Power Query Functions, Parameters Invoke Functions, Execution Results Power Query Edits, Applied Steps Promote/Demote Header Formatting	PBI 17 : POWER BI CLOUD - 1 Power BI Service Registration Power BI Service Architecture App Workspace Creation in Cloud Publish from Power BI Desktop Reports, Datasets in Power BI Cloud Deployment Verifications in Cloud Creating Dashboards, Realtime Use Pin Visuals, Pin LIVE Report Pages Dashboard Creation with Tiles, Media Tiles - Images, Web Content, Chapters Subscriptions, Insights and Refresh Metrics, Distribution Methods, Actions View Related & Featured Dashboards Favorites, Shares, Dashboard Themes Performance Inspector and QR Codes
SQL 2: Database & SQL Basics - 1 DDL, DML, SELECT, DCL and TCL DDL, DML, SELECT, DCL and TCL Creating Databases with SQL Scripts Creating Tables. Int, Char Types Single Row and Multi Row Inserts Select. Where Condition, Operators And, Or, Not, Mathematical Operators In, Not In, Between, Not Between Creating Databases, Tables in GUI Data Inserts, Edits, T-SQL Scripts Utilities : Excel Imports and Exports Excel Sheet Data into SQL Tables SELECT TOP (n) Queries from GUI GUI Limitations, SQL Code Benefits	PBI 2: BASIC REPORT DESIGN Report Visual Types in Power BI Report Data Sources in Power BI Canvas, Fields and Report Data Data Import and Data Load Options In-Memory xvelocity Database Get Data and Memory Tables Design Reports in Power BI (Basic) Using Table and Tree Map Visuals SPOTLIGHT Option & CSV Exports Web View and Mobile View in PBI PBIX and PBIT File Formats Visual Interactions in Power BI Edit Interactions - Format Options Disabling Visual Interactions	PBI 10 : POWER QUERY LEVEL 2 Power Query Transformations Combine, MERGE Transformations Join Types, Options in Merge Replace, Split and ReduceRows Manage & Hide / Show Columns GroupBy, Aggregation, Formatting Transpose and Reverse Rows Structured Data in Power Query Power Query - Row Count, Replace Data Type Detection - Scenarios Data Conversions, Value Replace Fill Up / Down, Rename Options PIVOT, UNPIVOT Transformations MOVE, FILTER & ConvertToList()	PBI 18 : POWER BI CLOUD - 2 Incremental Loads, Gateway Versions Data Gateway and Privacy Levels PBIEngw Service, ODG Logs, Audits Dataset Operations @ Power BI Cloud Dataset Actions - Report Creation LIVE Report Edits, Downloads Quick Insights and PBIX Downloads Publishing App Workspace, Updates Dataset Refresh with DataSource Power BI Data Gateway - Architecture Gateway Installation, Configuration Using Gateways in Power BI Cloud SSO - Single Sign On Security Kerberos Authentication, Refresh
SQL 3: Database & SQL Basics - 2 Database Logical Implementation Database Physical Implementation Creating Databases with GUI Data Files in Real-time [mdf, ndf] Log Files (T-LOG) For Audits [ldf] CHAR Versus VARCHAR Data Types GO Statement, SQL BATCH Concept SELECT Statement. Is Null Not Null LIKE, NOT LIKE Operatiors. & and _ DISTINCT, TOP, FETCH, ORDER BY UNION, UNION ALL and Auto Orders UPDATE : With / Without Conditions DELETE Vs TRUNCATE Statements Alter, Drop, Add, Modify Statements	PBI 3 : SLICER & VISUAL SYNC Slicer Visual : Real-time Usage Slicer Visual Values, Drop-Downs Orientation, Selection Properties Single & Multi Select, CTRL Options Item Colors and Select All Options Filter and Slice Control Options Interactions with Related Data Slicer : Number, Text and Date Data Slicer List and Slicer Dropdowns Visual Sync Property - Limitations Visual Sync Limitations with Slicer Visual Sync Limitations in Reports Disabling Slicers with Interactions Clear Selections and Focus Mode	PBI 11 : POWER QUERY LEVEL 3 SPLIT, FORMAT and EXTRACT PARSE, NUMBER, COMBINE Date, Time Transformations Deriving Year, Quarter, Month, Day Creating Parameters in Power Query Intrinsic, Query Parameters, Usage Parameter Data Types, Default Lists Static/Dynamic Lists For Parameters Creating Parameters in Power Query Creating Parameters in Data Set Convert Columns to Lists Reports with Ranges - Bookmarks Dynamic Dropdown in PBIX Reports Parameters with PBIT Reports	PBI 19 : EXCEL, SECURITY, ALERTS Using Excel with Power BI Reports Using Excel Analyzer in Power BI Using Excel Publisher in PBI Cloud Datasets in Excel and Office 365 Cell Selection and PINS in Power BI Excel Online Service Edits & Pins Excel ODC Connections Power Pivot Excel Workbooks and Dashboards Import and Upload Options in Excel Power Pivot Reports in with Excel Security Levels in Power BI Cloud Dashboard Security, Report Security Dataset Security - Read and Reshare Creating, Managing Alerts in Cloud
SQL 4 : Constraints, Indexes - Basics Constraints and Keys - Data Integrity NULL, NOT NULL Property on Tables UNIQUE KEY Constraints: Importance PRIMARY KEY Constraint: Importance FOREIGN KEY Constraint: Importance REFERENCES, CHECK, DEFAULT Candidate Keys & Identity Property Generating Database Diagrams (ER) Self Referencing & Composite Keys Indexes : Basic Types & Creation Primary Key and Unique Key Indexes Composite Keys & Composite Indexes Self Referencing Keys and Indexes Working with Indexes and Constraints	PBI 4 : Groups, Bins, Hierarchies Grouping : Real-time Use, Examples List Grouping and Binning Options Grouping Static / Fixed Data Values Grouping Dynamic / Changing Data Bin Size and Biz Limits (Max, Min) Bin Count and Grouping Options Grouping Grouped Items, Limitations Creating Hierarchies in Power BI Independant Drill-Down Options Dependant Drill-Down Options Conditional Drilldowns, Data Points Drill Up, Include and Exclude Drill Thru Reports, Conditional Filters Show Data, Export Data, See Records	PBI 12 : POWER QUERY LEVEL 4 Creating Lists and Tables Multi Value Parameters @ Power BI Dynamic Expressions and Functions Structured Table Values & Reports Common Query & DataSet Options Creating Query Duplicates and use Creating Query References and Use FROWN, Token Comma Expression Applied Steps - Edits, Data Inserts New Step Inserts, Step Verifications DELETE and DELETE UNTIL END DATA LOAD Option in Power Query Query Validations, Query Groups Date Time Formats in Power Query	PBI 20: REST Api, Custom Visuals REST APIs with Power BI Cloud Streaming Datasets in Power BI API : Usage. SubKeys & Channels Push, Pubnub Datasets in Power BI Azure Stream for Real-time Reports Real-time Data Tracking in PBI Streaming Dataset Tiles in Cloud Power BI Dashboards with REST API Power BI Datasets in PBI Desktop Marketplace Visuals and PBIVIZ Files HeatMaps - Visual, Real-time Usage FlowMaps - Visual, Real-time Usage Preview Features - Power BI Desktop Shape Visual, JSON and XML Option
SQL 5: Joins & T-SQL Queries - 1 Purpose of Joins in Real-world JOINS - Types, Reporting Usage JOIN Types, JOIN Options in T-SQL Joins Queries @ Related Tables Joins Queries @ UnRelated Tables INNER JOIN Examples, Where, On OUTER JOIN Examples, Where, On LEFT / RIGHT / FULL Outer Joins MERGE, LOOP, HASH Join Options Tuning Options with Join Queries CROSS JOIN and CROSS APPLY Queries with 2, 3, 4 Table Joins Queries with 2, 3, 4 Table Joins Comparing Joins and Sub Queries Comparing Left, Right Outer Joins	PBI 5 : Bookmarks & Actions Drill-thru Filters, Page Navigations Bookmarks : Real-time Usage Bookmarks for Visual Filters Bookmarks for Page Navigations Selection Pane with Bookmarks Buttons, Images with Actions Buttons, Actions and URLs with Text Image Level Actions, Selection Pane Hide and UnHide in Selection Pane Bookmarks View for Testing Synonyms : Real-time Usage Creation and Use of Synonyms Creating Aliases and Synonyms Modeling Options in Data Tab Modeling Options with Synonyms	PBI 13 : POWER QUERY LEVEL 5 Grouping Queries in Realtime Query Transformations, Data Models Sort Directions, Data Statistics Mathematical Operation, Trignometry IF..ELSE Conditions in Power Query Data Modeling with Power Query Modeling Operations, Add Columns Columns from Examples in Real-time Conditional Column, Indexed Column Variables, Parameters - Power Query Date, Time Columns. String Functions Custom Functions in Power Query Variables, Text Formats in M Lang Loops & Iterations with M Lang Power Query Limitations For ETL	PBI 21: Power BI Report Server Power BI Admin and Settings Installing Power BI Report Server Report Server Configuration Manager Configure Power BI Report Server Report Server DB, Temp Database Webservice URL, Webportal URL Report Builder Installation Designing Paginated Reports (RDL) Deploy to Power BI Report Server Data Source Connections, Report Power BI Report Server to Cloud Tenant IDs Generation and Real-time Integrating Power BI Intranet Creating Hybrid Cloud with Power BI Paginated Vs Interactive Reports
SQL 6: Joins & T-SQL Queries - 2 GROUP BY Queries & Aggregations GROUP BY Queries & Having Clause Group By - Query Design Rules ROLLUP and CUBE - Summary Values GROUPING() Function for Row Status Replacing Nulls: ISNULL, COALESCE Joining Tables with Group By, Having Sub Queries with Joins and Group By Nested Sub Queries @ Group By, Joins Compare WHERE, HAVING Conditions Cast and Convert Functions - Usage DateTime, DateAdd, DateDiff Functions Date & Time Styles, Data Formatting Using Date & Time Formats in Queries	PBI 6 : Filters, DrillThru Actions Filters : Types and Usage in Real-time Visual Filter, Page Filter, Report Filter Basic, Advanced and TOP N Filters Category Level, Summary Level Filters DrillThru Filters and Drill Thru Reports Keep All Filters" Options in DrillThru CrossReport Filters in Real-time Drill-thru Filters, Page Navigations DrillThru Filters with Buttons Slicer Versus DrillThru Filters Visual Interactions, Drill - Thru Image Level Actions, Selection Pane Real-time Issues with Filters Alternatives To Power BI Filters	PBI 14 : DAX Functions Level 1 DAX : Importance in Real-time Real-world usage of DAX Real-world usage of Excel DAX Architecture, Entity Sets Formulation Rules for using DAX DAX Data Types & Working Options DAX Measures and Calculations ROW Context and Filter Context DAX Structures & Syntax Options DAX Functions, Types in Real-time Creating, Using Measures with DAX Creating, Using Columns with DAX Vertipaq Engine, Special Characters Operators in DAX - Realtime Usage	PBI 22 : POWER BI WITH MSBI SSRS Integration with Power BI SSRS Report URL to PBI Cloud Power BI Vs SSRS KPI Reports Converting with Mobile Reports Report Builder Reports to Powert BI IMPORT, CONNECT LIVE Options Query Mode and Cube Browser MDX with Power BI Reports KPIs in Power BI Reports, Usage Cube & Perspective Browsing in PBI MDX Queries, Filters with Power BI SSAS MDX with Power BI Visuals SSAS Tabular Mode in Power BI DAX Tabular Mode in Power BI
SQL 7: Joins & T-SQL Queries - 3 String Functions in SQL Server T-SQL CharIndex, PatIndex, Left and Right STUFF, REPLICATE, LTRIM, RTRIM LEN, STRING_AGG, STRING_SPLIT SUBSTRING,SOUNDEX,DIFFERENCE CAST, CONVERT & PARSE TRY_CONVERT and TRY_PARSE IIF, CHOOSE Functions & Queries CASE Statement - WHEN, ELSE, END ROW_NUMBER, RANK, DENSERANK PARTITION BY with RANK Functions MERGE Statement - Data Compare WHEN MATCHED, NOT MATCHED Incremental Loads with MERGE	PBI 7 : Big Data Access, Modeling Power BI Reports & OLTP Databases Power BI Reports & DWH Databases Power BI Reports & Big Data Sources Azure Database Access, Reports Import & Direct Query with Power BI SQL Queries in Power BI Desktop Data Modelling : Summary, Format Data Modelling : Currency, Relations Relations Management with OLTP 1:1, 1:M and M:1 Relations Views, Tables, Functions in PBI Synonyms : Creation and Usage Connection with Access Databases Connection with CSV, PDF Sources	PBI 15 : DAX FUNCTIONS LEVEL 2 Data Modeling Options in DAX Detecting Relations for DAX Power BI DAX Functions - Types DAX Functions - Cheat Sheet Calculated Columns in DAX Aggregated Measures in DAX Quick Measures in DAX PowerPivot xVelocity Vertipaq DB Date & Time & Text Functions Time Intelligence Functions - DAX Logical, Mathematical Functions Data Modeling with DAX SUM, DATEDIFF Examples in DAX TODAY, DATE, DAY with DAX	PBI 23 : POWER BI with R Introduction to R Language, Usage R Scripts, R Visuals Realtime Use MRO : Microsoft R Open Installation MKL : Math Kernel Library Options R Language Compiler from RMAN R Language License from Intel MKL Enabling R Script in Power BI Using R Script Visuals in Power BI Installing R Studio for R Scripts Install FORECAST Packages R Studio R Script Editor Window in R Studio R Scripts in Power BI. Executions R Visual in Power BI Desktop R Visuals - Limitations in Power BI
SQL 8: SQL Database Objects Basics Views : Types, Usage in Real-time System Predefined Views, Audits Listing Databases, Tables, Indexes Functions : Types, Usage in Real-time Scalar, Inline and Multi-Line Functions System Predefined Functions, Audits Variables & Parameters in SQL Server Procedures : Types, Usage in Real-time Sp_help, Sp_helpdb and sp_helptext Sp_recompile, sp_pkeys System SPs FOR/AFTER Triggers - Real time Use INSTEAD OF Triggers - Real time Use INSERTED, DELETED Memory Tables Server, DB DDL Triggers - Usage	PBI 8 : Visual Properties, Analytics Stacked Charts and Clustered Charts Line Charts, Area Charts, Bar Charts 100% Stacked Bar and Column Charts Map Visuals: Tree, Filled, Bubble Cards, Funnel, Table, Matrix Scatter Chart, Ribbon, KPI, Gauge Waterfall Chart and ArcGIS Maps Custom Visuals from Market Place Color Saturation, Sentiment Colors Column Series, Column Axis in Lines Join Types : Round, Bevel, Miter Shapes, Markers, Axis, Axis, Plot Area Display Units,Data Colors,Shapes Series, Custom Series and Legends	PBI 16 : DAX FUNCTIONS LEVEL 3 AVERAGEX and AVERAGE in DAX KEEPFILTERS and CALCUALTE COUNTROWS, RELATED, DIVIDE ALL, MAX and Differences PARALLELPERIOD, DATEDADD CALCULATE & PREVIOUSMONTH USERELATIONSHIP, DAX Variables TOTALYTD , TOTALQTD TOTALMTD, Time Intelligence DIVIDE, CALCULATE, Conditions IF..ELSE..THEN Statement SELECTEDVALUE, FORMAT RELATED & COUNTROWS in DAX CALCULATE, SUM, ALL Functions	PBI 24 : POWER BI & Data Science Power BI for Big Data Analytics Power BI Data Flows in Cloud Machine Learning Models : Power BI Adding ML models in Power BI "game" Console in Power BI Fields Console, Date, Search Options in R Executing and Testing R Scripts Power BI Limitations with R Visuals Duplicate Data Removal with R Power BI with R for Data Scientists Power BI App Publish Options Power BI App Security Options Power BI Datasets in PBI Desktop OneDrive and FB Integrations
SQL 9: Triggers, Transactions, Excel EXPLICIT & IMPLICIT Transactions COMMIT and ROLLBACK Statements Query Blocking and Lock Hints Excel Integration with SQL Databases Excel Pivot Tables and Pivot Charts Normal Forms : 1NF, 2NF, 3NF, BCNF 4 NF, EKNF, ETNF & FD 1:1, 1:M, M:1, M:M Relation Types SQL Server Architecture - in Detail	Real-time Case Study - 1 : Scenario : Sales & Customers Objective : Design Power BI Reports with Various Data Sources including Excel, DAT, CSV and TXT Files. Includes Basic Data Modeling. Solution in Chapter PBI 27	Real-time Case Study - 2 : Scenario : Sales & Customers Objective : Data Modeling With Power Query ETL Operations With DAX Functions and Expressions Includes Dynamic Reports with DAX Solution in Chapter PBI 27	Real-time Project : Scenario : Sales & Customers Objective : End-to-End Reports with PBIX, PBIT, RDL Types. Analytical, Paginated Reports Includes Basic Data Modeling. Includes Power BI Cloud Includes Power BI Report Server

Mod 1: SQL Server TSQL Queries

Applicable for Power BI Plan B, C

Mod 2: Power BI Report Design

Applicable for Power BI Plan A, B, C

Mod 3: ETL, Data Modelling

Applicable for Power BI Plan A, B, C

Mod 4: Power BI Cloud, Admin

Applicable for Power BI Plan A, B, C

SQL 1: SQL, Power BI Introduction

Data, Databases & BI Technologies
OLTP, DWH,OLAP,HTAP Databases
BI and Data Science Components
Power BI for Business Analysts
Power BI for Data Scientists
Real-time Job Responsibilities
Versions, Editions of SQL Server
Database Engine Service (OLTP)

SQL Server 2017,2019 Installation
Default and Named Instances
Master, Model, MSDB, TempDB
Resource Database, Login Types
SQL Server Authentication Modes
"sa" System Account, File Stream
Local & Remote Lab Connections

PBI 1 : POWER BI BASICS

Power BI Job Roles in Real-time
Power BI Data Analyst Job Roles
Business Analyst - Job Roles
Power BI Developer - Job Roles
Power BI for Data Scientists
Comparing MSBI and Power BI
Comparing Tableau and Power BI
MCSA 70-778, MCSA 70-779 Exam

Types of Reports in Real-World
Power BI EcoSystem, Architecture
Power BI Licensing Plans - Types
Power BI Desktop Installation
Power BI Desktop RS Installation
Report Builder & RS Mobile Install
Power BI Cloud Configuration

PBI 9 : POWER QUERY LEVEL 1

Power Query M Language Purpose
Power Query - Operation Types
Power Query Architecture and ETL
QUERY Concept, Data Validations
Power Query Mash Up Operations
Data Types, Literals and Values
M Language Expressions, Primitives
Structured Data in Power Query

LIST, RECORD and TABLE
Power Query Connection Formats
let, source, in statements @ M Lang
Power Query Functions, Parameters
Invoke Functions, Execution Results
Power Query Edits, Applied Steps
Promote/Demote Header Formatting

PBI 17 : POWER BI CLOUD - 1

Power BI Service Registration
Power BI Service Architecture
App Workspace Creation in Cloud
Publish from Power BI Desktop
Reports, Datasets in Power BI Cloud
Deployment Verifications in Cloud
Creating Dashboards, Realtime Use
Pin Visuals, Pin LIVE Report Pages

Dashboard Creation with Tiles, Media
Tiles - Images, Web Content, Chapters
Subscriptions, Insights and Refresh
Metrics, Distribution Methods, Actions
View Related & Featured Dashboards
Favorites, Shares, Dashboard Themes
Performance Inspector and QR Codes

SQL 2: Database & SQL Basics - 1

DDL, DML, SELECT, DCL and TCL
DDL, DML, SELECT, DCL and TCL
Creating Databases with SQL Scripts
Creating Tables. Int, Char Types
Single Row and Multi Row Inserts
Select. Where Condition, Operators
And, Or, Not, Mathematical Operators

In, Not In, Between, Not Between
Creating Databases, Tables in GUI
Data Inserts, Edits, T-SQL Scripts
Utilities : Excel Imports and Exports
Excel Sheet Data into SQL Tables
SELECT TOP (n) Queries from GUI
GUI Limitations, SQL Code Benefits

PBI 2: BASIC REPORT DESIGN

Report Visual Types in Power BI
Report Data Sources in Power BI
Canvas, Fields and Report Data
Data Import and Data Load Options
In-Memory xvelocity Database
Get Data and Memory Tables
Design Reports in Power BI (Basic)

Using Table and Tree Map Visuals
SPOTLIGHT Option & CSV Exports
Web View and Mobile View in PBI
PBIX and PBIT File Formats
Visual Interactions in Power BI
Edit Interactions - Format Options
Disabling Visual Interactions

PBI 10 : POWER QUERY LEVEL 2

Power Query Transformations
Combine, MERGE Transformations
Join Types, Options in Merge
Replace, Split and ReduceRows
Manage & Hide / Show Columns
GroupBy, Aggregation, Formatting
Transpose and Reverse Rows

Structured Data in Power Query
Power Query - Row Count, Replace
Data Type Detection - Scenarios
Data Conversions, Value Replace
Fill Up / Down, Rename Options
PIVOT, UNPIVOT Transformations
MOVE, FILTER & ConvertToList()

PBI 18 : POWER BI CLOUD - 2

Incremental Loads, Gateway Versions
Data Gateway and Privacy Levels
PBIEngw Service, ODG Logs, Audits
Dataset Operations @ Power BI Cloud
Dataset Actions - Report Creation
LIVE Report Edits, Downloads
Quick Insights and PBIX Downloads

Publishing App Workspace, Updates
Dataset Refresh with DataSource
Power BI Data Gateway - Architecture
Gateway Installation, Configuration
Using Gateways in Power BI Cloud
SSO - Single Sign On Security
Kerberos Authentication, Refresh

SQL 3: Database & SQL Basics - 2

Database Logical Implementation
Database Physical Implementation
Creating Databases with GUI
Data Files in Real-time [mdf, ndf]
Log Files (T-LOG) For Audits [ldf]
CHAR Versus VARCHAR Data Types
GO Statement, SQL BATCH Concept

SELECT Statement. Is Null Not Null
LIKE, NOT LIKE Operatiors. & and _
DISTINCT, TOP, FETCH, ORDER BY
UNION, UNION ALL and Auto Orders
UPDATE : With / Without Conditions
DELETE Vs TRUNCATE Statements
Alter, Drop, Add, Modify Statements

PBI 3 : SLICER & VISUAL SYNC

Slicer Visual : Real-time Usage
Slicer Visual Values, Drop-Downs
Orientation, Selection Properties
Single & Multi Select, CTRL Options
Item Colors and Select All Options
Filter and Slice Control Options
Interactions with Related Data

Slicer : Number, Text and Date Data
Slicer List and Slicer Dropdowns
Visual Sync Property - Limitations
Visual Sync Limitations with Slicer
Visual Sync Limitations in Reports
Disabling Slicers with Interactions
Clear Selections and Focus Mode

PBI 11 : POWER QUERY LEVEL 3

SPLIT, FORMAT and EXTRACT
PARSE, NUMBER, COMBINE
Date, Time Transformations
Deriving Year, Quarter, Month, Day
Creating Parameters in Power Query
Intrinsic, Query Parameters, Usage
Parameter Data Types, Default Lists

Static/Dynamic Lists For Parameters
Creating Parameters in Power Query
Creating Parameters in Data Set
Convert Columns to Lists
Reports with Ranges - Bookmarks
Dynamic Dropdown in PBIX Reports
Parameters with PBIT Reports

PBI 19 : EXCEL, SECURITY, ALERTS

Using Excel with Power BI Reports
Using Excel Analyzer in Power BI
Using Excel Publisher in PBI Cloud
Datasets in Excel and Office 365
Cell Selection and PINS in Power BI
Excel Online Service Edits & Pins
Excel ODC Connections Power Pivot

Excel Workbooks and Dashboards
Import and Upload Options in Excel
Power Pivot Reports in with Excel
Security Levels in Power BI Cloud
Dashboard Security, Report Security
Dataset Security - Read and Reshare
Creating, Managing Alerts in Cloud

SQL 4 : Constraints, Indexes - Basics

Constraints and Keys - Data Integrity
NULL, NOT NULL Property on Tables
UNIQUE KEY Constraints: Importance
PRIMARY KEY Constraint: Importance
FOREIGN KEY Constraint: Importance
REFERENCES, CHECK, DEFAULT
Candidate Keys & Identity Property

Generating Database Diagrams (ER)
Self Referencing & Composite Keys
Indexes : Basic Types & Creation
Primary Key and Unique Key Indexes
Composite Keys & Composite Indexes
Self Referencing Keys and Indexes
Working with Indexes and Constraints

PBI 4 : Groups, Bins, Hierarchies

Grouping : Real-time Use, Examples
List Grouping and Binning Options
Grouping Static / Fixed Data Values
Grouping Dynamic / Changing Data
Bin Size and Biz Limits (Max, Min)
Bin Count and Grouping Options
Grouping Grouped Items, Limitations

Creating Hierarchies in Power BI
Independant Drill-Down Options
Dependant Drill-Down Options
Conditional Drilldowns, Data Points
Drill Up, Include and Exclude
Drill Thru Reports, Conditional Filters
Show Data, Export Data, See Records

PBI 12 : POWER QUERY LEVEL 4

Creating Lists and Tables
Multi Value Parameters @ Power BI
Dynamic Expressions and Functions
Structured Table Values & Reports
Common Query & DataSet Options
Creating Query Duplicates and use
Creating Query References and Use

FROWN, Token Comma Expression
Applied Steps - Edits, Data Inserts
New Step Inserts, Step Verifications
DELETE and DELETE UNTIL END
DATA LOAD Option in Power Query
Query Validations, Query Groups
Date Time Formats in Power Query

PBI 20: REST Api, Custom Visuals

REST APIs with Power BI Cloud
Streaming Datasets in Power BI
API : Usage. SubKeys & Channels
Push, Pubnub Datasets in Power BI
Azure Stream for Real-time Reports
Real-time Data Tracking in PBI
Streaming Dataset Tiles in Cloud

Power BI Dashboards with REST API
Power BI Datasets in PBI Desktop
Marketplace Visuals and PBIVIZ Files
HeatMaps - Visual, Real-time Usage
FlowMaps - Visual, Real-time Usage
Preview Features - Power BI Desktop
Shape Visual, JSON and XML Option

SQL 5: Joins & T-SQL Queries - 1

Purpose of Joins in Real-world
JOINS - Types, Reporting Usage
JOIN Types, JOIN Options in T-SQL
Joins Queries @ Related Tables
Joins Queries @ UnRelated Tables
INNER JOIN Examples, Where, On
OUTER JOIN Examples, Where, On

LEFT / RIGHT / FULL Outer Joins
MERGE, LOOP, HASH Join Options
Tuning Options with Join Queries
CROSS JOIN and CROSS APPLY
Queries with 2, 3, 4 Table Joins
Queries with 2, 3, 4 Table Joins
Comparing Joins and Sub Queries
Comparing Left, Right Outer Joins

PBI 5 : Bookmarks & Actions

Drill-thru Filters, Page Navigations
Bookmarks : Real-time Usage
Bookmarks for Visual Filters
Bookmarks for Page Navigations
Selection Pane with Bookmarks
Buttons, Images with Actions
Buttons, Actions and URLs with Text

Image Level Actions, Selection Pane
Hide and UnHide in Selection Pane
Bookmarks View for Testing
Synonyms : Real-time Usage
Creation and Use of Synonyms
Creating Aliases and Synonyms
Modeling Options in Data Tab
Modeling Options with Synonyms

PBI 13 : POWER QUERY LEVEL 5

Grouping Queries in Realtime
Query Transformations, Data Models
Sort Directions, Data Statistics
Mathematical Operation, Trignometry
IF..ELSE Conditions in Power Query
Data Modeling with Power Query
Modeling Operations, Add Columns

Columns from Examples in Real-time
Conditional Column, Indexed Column
Variables, Parameters - Power Query
Date, Time Columns. String Functions
Custom Functions in Power Query
Variables, Text Formats in M Lang
Loops & Iterations with M Lang
Power Query Limitations For ETL

PBI 21: Power BI Report Server

Power BI Admin and Settings
Installing Power BI Report Server
Report Server Configuration Manager
Configure Power BI Report Server
Report Server DB, Temp Database
Webservice URL, Webportal URL
Report Builder Installation

Designing Paginated Reports (RDL)
Deploy to Power BI Report Server
Data Source Connections, Report
Power BI Report Server to Cloud
Tenant IDs Generation and Real-time
Integrating Power BI Intranet
Creating Hybrid Cloud with Power BI
Paginated Vs Interactive Reports

SQL 6: Joins & T-SQL Queries - 2

GROUP BY Queries & Aggregations
GROUP BY Queries & Having Clause
Group By - Query Design Rules
ROLLUP and CUBE - Summary Values
GROUPING() Function for Row Status
Replacing Nulls: ISNULL, COALESCE

Joining Tables with Group By, Having
Sub Queries with Joins and Group By
Nested Sub Queries @ Group By, Joins
Compare WHERE, HAVING Conditions
Cast and Convert Functions - Usage
DateTime, DateAdd, DateDiff Functions
Date & Time Styles, Data Formatting
Using Date & Time Formats in Queries

PBI 6 : Filters, DrillThru Actions

Filters : Types and Usage in Real-time
Visual Filter, Page Filter, Report Filter
Basic, Advanced and TOP N Filters
Category Level, Summary Level Filters
DrillThru Filters and Drill Thru Reports
Keep All Filters" Options in DrillThru
CrossReport Filters in Real-time

Drill-thru Filters, Page Navigations
DrillThru Filters with Buttons
Slicer Versus DrillThru Filters
Visual Interactions, Drill - Thru
Image Level Actions, Selection Pane
Real-time Issues with Filters
Alternatives To Power BI Filters

PBI 14 : DAX Functions Level 1

DAX : Importance in Real-time
Real-world usage of DAX
Real-world usage of Excel
DAX Architecture, Entity Sets
Formulation Rules for using DAX
DAX Data Types & Working Options

DAX Measures and Calculations
ROW Context and Filter Context
DAX Structures & Syntax Options
DAX Functions, Types in Real-time
Creating, Using Measures with DAX
Creating, Using Columns with DAX
Vertipaq Engine, Special Characters
Operators in DAX - Realtime Usage

PBI 22 : POWER BI WITH MSBI

SSRS Integration with Power BI
SSRS Report URL to PBI Cloud
Power BI Vs SSRS KPI Reports
Converting with Mobile Reports
Report Builder Reports to Powert BI
IMPORT, CONNECT LIVE Options

Query Mode and Cube Browser
MDX with Power BI Reports
KPIs in Power BI Reports, Usage
Cube & Perspective Browsing in PBI
MDX Queries, Filters with Power BI
SSAS MDX with Power BI Visuals
SSAS Tabular Mode in Power BI
DAX Tabular Mode in Power BI

SQL 7: Joins & T-SQL Queries - 3

String Functions in SQL Server T-SQL
CharIndex, PatIndex, Left and Right
STUFF, REPLICATE, LTRIM, RTRIM
LEN, STRING_AGG, STRING_SPLIT
SUBSTRING,SOUNDEX,DIFFERENCE
CAST, CONVERT & PARSE
TRY_CONVERT and TRY_PARSE

IIF, CHOOSE Functions & Queries
CASE Statement - WHEN, ELSE, END
ROW_NUMBER, RANK, DENSERANK
PARTITION BY with RANK Functions
MERGE Statement - Data Compare
WHEN MATCHED, NOT MATCHED
Incremental Loads with MERGE

PBI 7 : Big Data Access, Modeling

Power BI Reports & OLTP Databases
Power BI Reports & DWH Databases
Power BI Reports & Big Data Sources
Azure Database Access, Reports
Import & Direct Query with Power BI
SQL Queries in Power BI Desktop
Data Modelling : Summary, Format

Data Modelling : Currency, Relations
Relations Management with OLTP
1:1, 1:M and M:1 Relations
Views, Tables, Functions in PBI
Synonyms : Creation and Usage
Connection with Access Databases
Connection with CSV, PDF Sources

PBI 15 : DAX FUNCTIONS LEVEL 2

Data Modeling Options in DAX
Detecting Relations for DAX
Power BI DAX Functions - Types
DAX Functions - Cheat Sheet
Calculated Columns in DAX
Aggregated Measures in DAX
Quick Measures in DAX

PowerPivot xVelocity Vertipaq DB
Date & Time & Text Functions
Time Intelligence Functions - DAX
Logical, Mathematical Functions
Data Modeling with DAX
SUM, DATEDIFF Examples in DAX
TODAY, DATE, DAY with DAX

PBI 23 : POWER BI with R

Introduction to R Language, Usage
R Scripts, R Visuals Realtime Use
MRO : Microsoft R Open Installation
MKL : Math Kernel Library Options
R Language Compiler from RMAN
R Language License from Intel MKL
Enabling R Script in Power BI

Using R Script Visuals in Power BI
Installing R Studio for R Scripts
Install FORECAST Packages R Studio
R Script Editor Window in R Studio
R Scripts in Power BI. Executions
R Visual in Power BI Desktop
R Visuals - Limitations in Power BI

SQL 8: SQL Database Objects Basics

Views : Types, Usage in Real-time
System Predefined Views, Audits
Listing Databases, Tables, Indexes
Functions : Types, Usage in Real-time
Scalar, Inline and Multi-Line Functions
System Predefined Functions, Audits
Variables & Parameters in SQL Server

Procedures : Types, Usage in Real-time
Sp_help, Sp_helpdb and sp_helptext
Sp_recompile, sp_pkeys System SPs
FOR/AFTER Triggers - Real time Use
INSTEAD OF Triggers - Real time Use
INSERTED, DELETED Memory Tables
Server, DB DDL Triggers - Usage

PBI 8 : Visual Properties, Analytics

Stacked Charts and Clustered Charts
Line Charts, Area Charts, Bar Charts
100% Stacked Bar and Column Charts
Map Visuals: Tree, Filled, Bubble
Cards, Funnel, Table, Matrix
Scatter Chart, Ribbon, KPI, Gauge
Waterfall Chart and ArcGIS Maps

Custom Visuals from Market Place
Color Saturation, Sentiment Colors
Column Series, Column Axis in Lines
Join Types : Round, Bevel, Miter
Shapes, Markers, Axis, Axis, Plot Area
Display Units,Data Colors,Shapes
Series, Custom Series and Legends

PBI 16 : DAX FUNCTIONS LEVEL 3

AVERAGEX and AVERAGE in DAX
KEEPFILTERS and CALCUALTE
COUNTROWS, RELATED, DIVIDE
ALL, MAX and Differences
PARALLELPERIOD, DATEDADD
CALCULATE & PREVIOUSMONTH
USERELATIONSHIP, DAX Variables

TOTALYTD , TOTALQTD
TOTALMTD, Time Intelligence
DIVIDE, CALCULATE, Conditions
IF..ELSE..THEN Statement
SELECTEDVALUE, FORMAT
RELATED & COUNTROWS in DAX
CALCULATE, SUM, ALL Functions

PBI 24 : POWER BI & Data Science

Power BI for Big Data Analytics
Power BI Data Flows in Cloud
Machine Learning Models : Power BI
Adding ML models in Power BI
"game" Console in Power BI Fields
Console, Date, Search Options in R
Executing and Testing R Scripts

Power BI Limitations with R Visuals
Duplicate Data Removal with R
Power BI with R for Data Scientists
Power BI App Publish Options
Power BI App Security Options
Power BI Datasets in PBI Desktop
OneDrive and FB Integrations

SQL 9: Triggers, Transactions, Excel

EXPLICIT & IMPLICIT Transactions
COMMIT and ROLLBACK Statements
Query Blocking and Lock Hints
Excel Integration with SQL Databases
Excel Pivot Tables and Pivot Charts
Normal Forms : 1NF, 2NF, 3NF, BCNF
4 NF, EKNF, ETNF & FD
1:1, 1:M, M:1, M:M Relation Types
SQL Server Architecture - in Detail

Real-time Case Study - 1 :
Scenario : Sales & Customers
Objective : Design Power BI Reports
with Various Data Sources including
Excel, DAT, CSV and TXT Files.
Includes Basic Data Modeling.
Solution in Chapter PBI 27

Real-time Case Study - 2 :
Scenario : Sales & Customers
Objective : Data Modeling
With Power Query ETL Operations
With DAX Functions and Expressions
Includes Dynamic Reports with DAX
Solution in Chapter PBI 27

Real-time Project :
Scenario : Sales & Customers
Objective : End-to-End Reports
with PBIX, PBIT, RDL Types.
Analytical, Paginated Reports
Includes Basic Data Modeling.
Includes Power BI Cloud
Includes Power BI Report Server

Note : Above course curriculum applicable for registrations from August 6th, 2019.

EVERY SESSION IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY SESSION. Register Today

Who can benefit from this Power BI Classroom Training course?

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!