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 Plans

	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 (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 7,000/-	INR 10,000/-	INR 22,000/-

Trainer & Profile : Mr. Sai Phanindra T

Timings (IST)		Course Start Date
Schedules for Power BI Training
1	9 AM - 10 AM	August 6th	Register
2	11:30 AM - 12:30 PM	August 27th	Register
3	6:30 PM - 7:30 PM	July 22nd	Register
4	10 AM - 12 PM (Wkn)	Aug 10th	Register
Schedules for SQL Server & T-SQL Training
1	6:30 AM - 7:30 AM	July 24th	Register
2	9:00 AM - 10:00 AM	September 4th	Register
3	10:15 AM - 11:15 AM	August 7th	Register
4	11:30 AM - 12:30 PM	July 30th	Register
5	6:30 PM - 7:30 PM	August 13th	Register
6	7:30 PM - 8:30 PM	Aug 20th	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	Mod 2: Power BI Report Design	Mod 3: ETL, Data Modelling	Mod 4: Power BI Cloud, Admin
SQL 1: SQL, Power BI Introduction Data, Databases and BI Technologies OLTP, DWH, OLAP, HTAP Databases BI and Data Science Components Power BI for Business Analysts Power BI for Data Scientists Power BI for IT(ES) Managers SQL and Databases in Power BI Real-time Job Responsibilities Power BI Work Environment Power BI Design Components Power BI Deployment Components Powe BI Cloud, Report Server Power BI with MS SQL Server SQL, SQL Database Basics Intro SQL Server, SSMS Installation Plan	PBI 1 : POWER BI BASICS BI Technologies - Role of Power BI Power BI as a Self-Service BI Data Analyst - Job Roles Business Analyst - Job Roles Power BI Developer - Job Roles Comparing MSBI & Power BI Comparing Tableau & Power BI MCSA 70-778 Exam - Power BI Types of Reports in Real-World Power BI EcoSystem, Architecture Power BI Licensing Plans - Types Report Design Tools, PreRequisites Power BI Cloud Service Operations Power BI Desktop, DesktopRS Power BI Training - Lab Plan	PBI 11 : POWER QUERY - LEVEL 1 Power Query M Language - Purpose Power Query - Operation Types Power Query Architecture and Usage QUERY Concept and Data Validations Power Query - Mash Up Operations Basic Data Types, Literals & Values Expressions, Primitives @ M Language Structured Data in Power Query LIST, RECORD and TABLE Power Query Connection Formats let, source, in statements @ M Lang Functions, Parameters in Power Query INVOKE Functions, Execution Results Power BI Canvas: Edits, Applied Steps Frowns, Query Header Row Formatting	PBI 21 : POWER BI CLOUD - 1 Power BI Service (Cloud) Registration Power BI Service (Cloud) Architecture App Workspace Creation in Real-time Publish Reports from Power BI Desktop Reports, Datasets in Power BI Cloud Deployment Verifications in Cloud Creating Dashboards and Realtime Use Pin Visuals and 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: SQL Server Installations SQL Server 2017 Installation SQL Server 2019 Installation Versions, Editions of SQL Server WMI, MS XML, SSMS Installation System Configuration Checker Tool Default and Named Instances Database Engine Service (OLTP) SQL Server Agent, Full Text Search SQL Browser Service, Collation Master, Model, MSDB, TempDB Resource Database, Login Types SQL Server Authentication Modes "sa" System Account, File Stream Local & Remote Lab Connections	PBI 2: BASIC REPORT DESIGN Power BI Desktop Tool Installation PBI Desktop Tool - Overview Report Visualizations Types in PBI Canvas, Fields and Report Data Data Sources in Power BI Desktop Enter Data & Get Data Options Data Import and Data Load Options In-Memory xvelocity Database Memory Tables and Field Queries 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	PBI 12 : POWER QUERY - LEVEL 2 Power Query Transformations Combine and MERGE Transformations Join Options in Merge Transformation Truncate, Replace, Split, ReduceRows Manage Columns, Hide/Show Columns GroupBy, Aggregation, Column Format Transpose and Reverse Rows Structured Data in Power Query Power Query - Row Count, Replace Data Type Detection - Scenarios, Use Data Type Conversions, Value Replace Fill Up and Fill Down, Rename Options PIVOT and UNPIVOT Transformations MOVE, FILTER and ConvertToList()	PBI 22 : 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 Content Packs in PBI Cloud Creating and Using Content Packs Organizational, Service Content Packs 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 - 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 3 : Interactions, Sync, Groups Visual Interactions in Power BI Edit Interactions - Format Options Filter and Slice Control Options Interactions with Related Data Slicer : Number, Text, Date Data Slicer Orientation, List, Dropdowns Visual Sync Property - Limitations Grouping and Binning with Fields Grouping Static / Fixed Data Values Grouping Dynamic / Changing Data Bin Size and Biz Limits (Max, Min) Bin Count and Grouping Options Min and Max Value Computations Value Distributions and Ranges	PBI 13 : 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 23 : EXCEL, SECURITY, ALERTS Using Excel with Power BI Reports Using Excel Analyzer in Power BI Using Excel Publisher in PBI Cloud Creating Datasets in Excel, Office 365 Cell Selection and PINS in Power BI Excel Online Service - Edits and Pins Excel ODC Connections - Power Pivot Excel Workbooks, Reports, 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 App Workspace Security Management Creating, Managing Alerts in Cloud Row Level Security (RLS) with DAX
SQL 4: 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 4 : Hierarchies, Drilldowns Creating Hierarchies in Power BI Hierarchies with Field Groups Using Hierarchies in Table Visuals Using Hierarchies in Matrix, Charts Using Hierarchies with Date, Time Built-In Hierarchy Labels in Visuals Inline Hierarchy Labels in Visuals Hierarchies: Issues and Solutions 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 14 : POWER QUERY - LEVEL 4 Report Design with Dynamic WebPages Creating Lists and Tables in Power BI Data Conversions and toText() Functions Multi Valued Parameters. Table Columns Dynamic Table Expressions and Functions Report Design - Structured Table Values Common Query & DataSet Options Creating Query Duplicates and use Creating Query References and Use FROWN and Token Comma Expression Applied Steps - Edits and Data Inserts New Step Inclusions using Power Query DELETE and DELETE UNTIL END ENABLE LOAD Options in Power Query	PBI 24: REST API, CUSTOM VISUALS REST APIs with Power BI Cloud Service Streaming Datasets Creation in Power BI API : Usage. SubKeys and Channels Push and Pubnub Datasets in Power BI Azure Stream for Real-time Data Reports Real-time Data Tracking Visuals in PBI Power BI Database @ Streaming Datasets Use Streaming Datasets in Tiles in Cloud Use Power BI Dashboards with REST API Power BI Datasets Usage in PBI Desktop Marketplace Visuals and PBIVIZ Files HeatMaps - Visual, Real-time Usage FlowMaps - Visual, Real-time Usage Preview Features in Power BI Desktop Shape Visual, JSON and XML Option
SQL 5: SQL Server Architecture Client Server Architecture & TDS SQL Native Client, OLE DB Driver Query Optimizer (QO), SQL Manager Storage Engine, File, DB Manager Transaction Manager, Lock Manager Buffer Manager, Memory, IO Buffer Write Ahead Log (WAL), Lazy Writer SQL OS Components, MDAC, CLR Temporary Tables : Real-time Use Local & Global Temporary Tables Schemas : Grouping Tables, Usage Schema - Table Migration, Transfer Synonyms. 2P, 3P and 4P Naming Date, Time, Datetime, sql_variant Float, Decimal, Numeric, nvarchar	PBI 5 : Filters, DrillThru, Bookmarks Filters : Types and Usage in Real-time Visual Filter, Page Filter, Report Filter Basic, Advanced and TOP N Filters Category Level, Summary Level Filters Slicer Versus Filters - Comparisons DrillThru Filters and Drill Thru Reports Keep All Filters" Options in DrillThru Drill-thru Options with Page Navigations Bookmarks : Navigations, Real-time Use Using Bookmarks for Visual Filters Using Bookmarks for Page Navigations Using Selection Pane with Bookmarks Using Buttons, Images with Actions Buttons, Actions and URLs with Text Image Level Actions, Selection Pane	PBI 15 : POWER QUERY - LEVEL 5 Grouping Queries - Usage in Realtime Query Level Transformations, Data Models Sort Direction, Statistics in Power Query Mathematical Operations, Trignometry IF..ELSE Conditions in Power Query Data Modeling Options with Power Query Modeling Operations - Custom Columns Columns From Examples in Real-time Conditional Column, Indexed Column Variables, Parameters - Power Query Date and Time Columns. String Functions Custom Functions in Power Query M Lang Variables, Text Formats with M Lang Loops and Iterations with M Lang Power Query Limitations - Need for DAX	PBI 25: POWER BI REPORT SERVER Power BI Admin Console and Settings Installing Power BI Report Server Report Server Configuration Manager Configuring Power BI Report Server Report Server Database TempDB Database Webservice URL, Webportal URL - Usage Report Builder Installation & Usage SQL Server Data Tools (SSDT) Tool Usage Designing Paginated Reports (RDL), Tests Deploy to Power BI Report Server, Settings Data Source Connections, Report Options Register Power BI Report Server to Cloud Tenant IDs Generation and Real-time Usage Integrating Power BI Intranet & Cloud Creating Hybrid Cloud with Power BI Publish RDL Reports to Power BI Cloud Paginated Reports Vs Interactive Reports
SQL 6 : 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 6 : Big Data Access, Modeling Power BI Reports with OLTP Databases Power BI Reports with DWH Databases Power BI Reports with Big Data Sources Azure Cloud Database Access, Reports Import and Direct Query with Power BI Using SQL Queries in Power BI Desktop Using Views, Tables, Functions in PBI Data Modelling : Summary, Format Data Modelling : Currency, Relations Relationship Management with OLTP 1:1, 1:M, M:1 Relations in Power BI Synonyms : Creation and Usage Connection with MS Access Databases Connection with CSV & PDF Sources	PBI 16 : DAX FUNCTIONS - LEVEL 1 DAX : Importance and Real-time Usage DAX as library of Functions, Operators Real-world usage of DAX with Power BI Real-world usage of Excel, MSBI SSAS DAX Architecture and Entity Sets Formulation Rules for using DAX DAX Data Types and Working Options Syntax, Functions, Context Options Concept of Measures and Calculations ROW Context and Filter Context in DAX DAX Structures and Syntax Options DAX Functions and Types in Real-time Creating and Using Measures with DAX Creating and Using Columns with DAX Vertipaq Engine & Special Characters Operators in DAX - Real-time Usage DAX Formulas Limitations in Power BI	PBI 26 : POWER BI WITH SSAS, SSRS MSBI SSRS Integration with Power BI SSRS Report Portal URL to Power BI Cloud Power BI KPI Reports Vs SSRS KPI Reports Converting and Working with Mobile Reports Report Builder Reports to Powert BI IMPORT and CONNECT LIVE Options Query Mode and Complete Cube Browse Using MDX Queries with Power BI Queries MDX SELECT and Perspective Access KPIs and MDX Expressions with Power BI Using KPIs in Power BI Reports, Usage Cube & Perspective Browsing in PBI MDX Queries and Filters with Power BI SSAS MDX Scripts with Power BI Visuals Using KPI Fields in Power BI Visuals KPI Visual : Goals, Status and Trends SSAS Tabular Mode Options in Power BI MDX @ Tabular Mode OLAP in Power BI DAX @ Tabular Mode OLAP in Power BI DAX Filters in Tabular Mode SSAS MDX, DAX Tabular Mode OLAP in Power BI
SQL 7: 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 7 : Power BI Visuals - Level 1 Power BI Visualizations and Types Fields, Formats & Analytics Options Table Visuals & Properties, Filters Field Formatting, Outline Property Conditional Formatting, Grid Lines Divergent Colors and Data Labelling Data Bar and Data Scaling Options Matrix : Sub Totals, Grand Totals Drilldown Options : Row and Column Row Groups, Column Groups in Matrix Word Wrap and Lock Aspect Options Banded Row Style and Visual Styles Single Row Card and MultiRowCard Background, Border, Data Analytics Power BI Visual Header Properties	PBI 17 : DAX FUNCTIONS - LEVEL 2 Data Modeling Options in DAX Detecting & Adding Relations for DAX Power BI DAX Functions - Types, Usage Power BI DAX Functions - Cheat Sheet Power BI Reports - DAX Functionalities Calculated Columns, Aggregated Measures Quick Measures in DAX - Auto validations PowerPivot xVelocity & Vertipaq Store In-Memory Processing : DAX Performance Date and Time & Text Functions Time Intelligence Functions in DAX Logical & Mathematical Functions Data Modeling with DAX. Creating Roles SUM and DATEDIFF Examples in DAX TODAY, DATE, DAY Arguments with DAX DIVIDE, CALCULATE, Conditions Using Variables in DAX, Calculations IF..ELSE..THEN Statement in DAX SELECTEDVALUE, FORMAT Functions RELATED & COUNTROWS in DAX CALCULATE, SUM, ALL Functions	PBI 27 : POWER BI with R Introduction to R Language, Usage R Scripts and R Visuals - Realtime Use MRO : Microsoft R Open - Installation MKL : Math Kernel Library Usage 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 in R Studio Using R Script Editor Window in R Studio Writing R Scripts in Power BI. Executions Using R Visual in Power BI Desktop "game" Console in Power BI Report Fields Console, Date and Search Options with R Executing and Testing R Scripts Power BI Limitations with R Visuals Duplicate Data Removal with R Visuals Power BI with R for Data Scientists R Visuals - Limitations in Power BI
SQL 8: 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 8 : Power BI Visuals - Level 2 Chart Reports - Axis, Legend, Value Stacked Bar and Clustered Bar Chart Stacked and Clustered Column Chart 100% Stacked Bar and Column Charts Data Labels, Legend, Color Saturation Line Chart and Area Chart Properties Stacked Area Chart - Properties, Usage Line and Stacked Column Charts Usage Line and Clustered Column Chart Usage Column Series & Column Axis in Lines Join Types, Lines: Round, Bevel, Miter Shapes, Markers, Axis, Axis, Plot Area Display Units, Data Colors, Shapes Series, Custom Series and Legends	PBI 18 : DAX FUNCTIONS - LEVEL 3 AVERAGEX and AVERAGE in DAX KEEPFILTERS and CALCUALTE COUNTROWS and FILTER Functions Using RELATED with FILTER Function DIVIDE with FILTER, ALLSELECTED Using ALL, MAX DAX Functions in FILTER Using ALLSELCTED and Differences Using Numeric and Text Conditions PARALLELPERIOD, DATEDADD in DAX CALCULATE with PREVIOUSMONTH FILTER Conditions with ROWCOUNT USERELATIONSHIP Function in DAX TOTALYTD , TOTALQTD, TOTALMTD Time Intelligence with DIVIDE Functions Time Intelligence with CALCULATE DATESINPERIOD and AVERAGEX EARLIER for Time Based Comparisons Using Variables in DAX Computations Time Type Dimensions - DAX Expressions Considerations for Quick Measures
SQL 9: 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 9 : Power BI Visuals - Level 3 Tree Map, Funnel and Gauge Reports Group and Values in Tree Map Visuals Min. Max Values and Goal Indicators Callout Values in KPI Reports and Use KPI : Indicator, Trend and Target Goal Scatter Chart - Play Area and Axes Pie Chart, Donut Charts - Radius Waterfall Chart - Sentiment Colors Breakdown Count. Decrease / Increase Map Reports and Filled Map Reports Map Visual and Filled Map Visual ArcGIS Maps - Latitudes, Longitudes Regions and Geographical Data Constant Lines and Threshold Values	PBI 19 : DAX FUNCTIONS - LEVEL 4 DAX Variables, Joins and Usage Value Assignments with DAX CONCATENATE Function in DAX HOUR, NOW, SWITCH, TRUE RETURN Values with DAX Functions Numeric and Other DAX Options DAX Modeling Components - use TABLES, COLUMNS, RELATIONS MEASURES and HIERARCHIES INTELLISENSE with DAX Editors Comments in DAX - Syntax Options DISTINCTCOUNT and DIVIDE SAMEPERIODLASTYEAR and IF Revenue and Budget with DAX VARIANCE Calculations in DAX TOTALYTD, YTD, QTD and MTD
SQL 10: Views,Functions,Procedure 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 DBId, DBName, ObjectID, ObjectName Variables & Parameters in SQL Server Procedures : Types, Usage in Real-time User SPs, System SPs, Extended SPs System Predefined Procedures, Audits Sp_help, Sp_helpdb and sp_helptext Sp_recompile, sp_pkeys System SPs	PBI 10 : Power BI Visuals - Level 4 Marketplace Visuals and PBIVIZ Files HeatMaps - Visual, Real-time Usage FlowMaps - Visual, Real-time Usage Power BI Infographics Custom Visuals PBI Infographics @ Big Data Sources Custom Visual Limitations, Migrations Table HeatMaps with Real-time Usage GanttChart - Visual, Real-time Usage Analysics & Line Properties in PBI Visualization Categories, Usage Comparing Visuals & Properties When to use Which Visual ? Visual Selection & Data Labels
Ch 11: Triggers, Transactions DML Triggers - Events, Practical Use FOR/AFTER Triggers - Real time Use INSTEAD OF Triggers - Real time Use INSERTED, DELETED Memory Tables Database Level DDL Triggers - Usage Server Level DDL Triggers - Usage COMMIT and ROLLBACK Statements EXPLICIT & IMPLICIT Transactions Autocommit Transaction, ACID Options Open Transactions and Query Blocking NOLOCK and READPAST Lock Hints
Ch 12 : Excel, Integrations, ER Models Real-time Case Study : SALES SCENARIO Excel Integration with SQL Databases Excel Pivot Tables and Pivot Charts Using Linked Servers, Remote Joins Storing Queries with Joins in Views Excel ODC Files with Joins, Sub Queries Normal Forms : 1 NF, 2 NF, 3 NF, BCNF 4 NF, EKNF, ETNF. Functional Dependency Multi-Valued & Transitive Dependency 1:1, 1:M, M:1, M:M Relation Types UPDATE Cascades, DELETE Cascades

Mod 1: SQL Server TSQL Queries

Mod 2: Power BI Report Design

Mod 3: ETL, Data Modelling

Mod 4: Power BI Cloud, Admin

SQL 1: SQL, Power BI Introduction

Data, Databases and BI Technologies
OLTP, DWH, OLAP, HTAP Databases
BI and Data Science Components
Power BI for Business Analysts
Power BI for Data Scientists
Power BI for IT(ES) Managers
SQL and Databases in Power BI
Real-time Job Responsibilities

Power BI Work Environment
Power BI Design Components
Power BI Deployment Components
Powe BI Cloud, Report Server
Power BI with MS SQL Server
SQL, SQL Database Basics Intro
SQL Server, SSMS Installation Plan

PBI 1 : POWER BI BASICS

BI Technologies - Role of Power BI
Power BI as a Self-Service BI
Data Analyst - Job Roles
Business Analyst - Job Roles
Power BI Developer - Job Roles
Comparing MSBI & Power BI
Comparing Tableau & Power BI
MCSA 70-778 Exam - Power BI

Types of Reports in Real-World
Power BI EcoSystem, Architecture
Power BI Licensing Plans - Types
Report Design Tools, PreRequisites
Power BI Cloud Service Operations
Power BI Desktop, DesktopRS
Power BI Training - Lab Plan

PBI 11 : POWER QUERY - LEVEL 1

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

LIST, RECORD and TABLE
Power Query Connection Formats
let, source, in statements @ M Lang
Functions, Parameters in Power Query
INVOKE Functions, Execution Results
Power BI Canvas: Edits, Applied Steps
Frowns, Query Header Row Formatting

PBI 21 : POWER BI CLOUD - 1

Power BI Service (Cloud) Registration
Power BI Service (Cloud) Architecture
App Workspace Creation in Real-time
Publish Reports from Power BI Desktop
Reports, Datasets in Power BI Cloud
Deployment Verifications in Cloud
Creating Dashboards and Realtime Use
Pin Visuals and 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: SQL Server Installations

SQL Server 2017 Installation
SQL Server 2019 Installation
Versions, Editions of SQL Server
WMI, MS XML, SSMS Installation
System Configuration Checker Tool
Default and Named Instances
Database Engine Service (OLTP)

SQL Server Agent, Full Text Search
SQL Browser Service, Collation
Master, Model, MSDB, TempDB
Resource Database, Login Types
SQL Server Authentication Modes
"sa" System Account, File Stream
Local & Remote Lab Connections

PBI 2: BASIC REPORT DESIGN

Power BI Desktop Tool Installation
PBI Desktop Tool - Overview
Report Visualizations Types in PBI
Canvas, Fields and Report Data
Data Sources in Power BI Desktop
Enter Data & Get Data Options
Data Import and Data Load Options

In-Memory xvelocity Database
Memory Tables and Field Queries
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

PBI 12 : POWER QUERY - LEVEL 2

Power Query Transformations
Combine and MERGE Transformations
Join Options in Merge Transformation
Truncate, Replace, Split, ReduceRows
Manage Columns, Hide/Show Columns
GroupBy, Aggregation, Column Format
Transpose and Reverse Rows

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

PBI 22 : 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
Content Packs in PBI Cloud
Creating and Using Content Packs
Organizational, Service Content Packs

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 - 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 3 : Interactions, Sync, Groups

Visual Interactions in Power BI
Edit Interactions - Format Options
Filter and Slice Control Options
Interactions with Related Data
Slicer : Number, Text, Date Data
Slicer Orientation, List, Dropdowns
Visual Sync Property - Limitations

Grouping and Binning with Fields
Grouping Static / Fixed Data Values
Grouping Dynamic / Changing Data
Bin Size and Biz Limits (Max, Min)
Bin Count and Grouping Options
Min and Max Value Computations
Value Distributions and Ranges

PBI 13 : 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 23 : EXCEL, SECURITY, ALERTS

Using Excel with Power BI Reports
Using Excel Analyzer in Power BI
Using Excel Publisher in PBI Cloud
Creating Datasets in Excel, Office 365
Cell Selection and PINS in Power BI
Excel Online Service - Edits and Pins
Excel ODC Connections - Power Pivot
Excel Workbooks, Reports, 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
App Workspace Security Management
Creating, Managing Alerts in Cloud
Row Level Security (RLS) with DAX

SQL 4: 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 4 : Hierarchies, Drilldowns

Creating Hierarchies in Power BI
Hierarchies with Field Groups
Using Hierarchies in Table Visuals
Using Hierarchies in Matrix, Charts
Using Hierarchies with Date, Time
Built-In Hierarchy Labels in Visuals
Inline Hierarchy Labels in Visuals
Hierarchies: Issues and Solutions

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 14 : POWER QUERY - LEVEL 4

Report Design with Dynamic WebPages
Creating Lists and Tables in Power BI
Data Conversions and toText() Functions
Multi Valued Parameters. Table Columns
Dynamic Table Expressions and Functions
Report Design - Structured Table Values
Common Query & DataSet Options
Creating Query Duplicates and use

Creating Query References and Use
FROWN and Token Comma Expression
Applied Steps - Edits and Data Inserts
New Step Inclusions using Power Query
DELETE and DELETE UNTIL END
ENABLE LOAD Options in Power Query

PBI 24: REST API, CUSTOM VISUALS

REST APIs with Power BI Cloud Service
Streaming Datasets Creation in Power BI
API : Usage. SubKeys and Channels
Push and Pubnub Datasets in Power BI
Azure Stream for Real-time Data Reports
Real-time Data Tracking Visuals in PBI
Power BI Database @ Streaming Datasets
Use Streaming Datasets in Tiles in Cloud
Use Power BI Dashboards with REST API
Power BI Datasets Usage in PBI Desktop
Marketplace Visuals and PBIVIZ Files
HeatMaps - Visual, Real-time Usage
FlowMaps - Visual, Real-time Usage
Preview Features in Power BI Desktop
Shape Visual, JSON and XML Option

SQL 5: SQL Server Architecture

Client Server Architecture & TDS
SQL Native Client, OLE DB Driver
Query Optimizer (QO), SQL Manager
Storage Engine, File, DB Manager
Transaction Manager, Lock Manager
Buffer Manager, Memory, IO Buffer
Write Ahead Log (WAL), Lazy Writer
SQL OS Components, MDAC, CLR

Temporary Tables : Real-time Use
Local & Global Temporary Tables
Schemas : Grouping Tables, Usage
Schema - Table Migration, Transfer
Synonyms. 2P, 3P and 4P Naming
Date, Time, Datetime, sql_variant
Float, Decimal, Numeric, nvarchar

PBI 5 : Filters, DrillThru, Bookmarks

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

Bookmarks : Navigations, Real-time Use
Using Bookmarks for Visual Filters
Using Bookmarks for Page Navigations
Using Selection Pane with Bookmarks
Using Buttons, Images with Actions
Buttons, Actions and URLs with Text
Image Level Actions, Selection Pane

PBI 15 : POWER QUERY - LEVEL 5

Grouping Queries - Usage in Realtime
Query Level Transformations, Data Models
Sort Direction, Statistics in Power Query
Mathematical Operations, Trignometry
IF..ELSE Conditions in Power Query
Data Modeling Options with Power Query
Modeling Operations - Custom Columns
Columns From Examples in Real-time

Conditional Column, Indexed Column
Variables, Parameters - Power Query
Date and Time Columns. String Functions
Custom Functions in Power Query M Lang
Variables, Text Formats with M Lang
Loops and Iterations with M Lang
Power Query Limitations - Need for DAX

PBI 25: POWER BI REPORT SERVER

Power BI Admin Console and Settings
Installing Power BI Report Server
Report Server Configuration Manager
Configuring Power BI Report Server
Report Server Database TempDB Database
Webservice URL, Webportal URL - Usage
Report Builder Installation & Usage
SQL Server Data Tools (SSDT) Tool Usage
Designing Paginated Reports (RDL), Tests
Deploy to Power BI Report Server, Settings
Data Source Connections, Report Options
Register Power BI Report Server to Cloud
Tenant IDs Generation and Real-time Usage
Integrating Power BI Intranet & Cloud
Creating Hybrid Cloud with Power BI
Publish RDL Reports to Power BI Cloud
Paginated Reports Vs Interactive Reports

SQL 6 : 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 6 : Big Data Access, Modeling

Power BI Reports with OLTP Databases
Power BI Reports with DWH Databases
Power BI Reports with Big Data Sources
Azure Cloud Database Access, Reports
Import and Direct Query with Power BI
Using SQL Queries in Power BI Desktop
Using Views, Tables, Functions in PBI

Data Modelling : Summary, Format
Data Modelling : Currency, Relations
Relationship Management with OLTP
1:1, 1:M, M:1 Relations in Power BI
Synonyms : Creation and Usage
Connection with MS Access Databases
Connection with CSV & PDF Sources

PBI 16 : DAX FUNCTIONS - LEVEL 1

DAX : Importance and Real-time Usage
DAX as library of Functions, Operators
Real-world usage of DAX with Power BI
Real-world usage of Excel, MSBI SSAS
DAX Architecture and Entity Sets
Formulation Rules for using DAX
DAX Data Types and Working Options
Syntax, Functions, Context Options
Concept of Measures and Calculations
ROW Context and Filter Context in DAX
DAX Structures and Syntax Options
DAX Functions and Types in Real-time
Creating and Using Measures with DAX
Creating and Using Columns with DAX
Vertipaq Engine & Special Characters
Operators in DAX - Real-time Usage
DAX Formulas Limitations in Power BI

PBI 26 : POWER BI WITH SSAS, SSRS

MSBI SSRS Integration with Power BI
SSRS Report Portal URL to Power BI Cloud
Power BI KPI Reports Vs SSRS KPI Reports
Converting and Working with Mobile Reports
Report Builder Reports to Powert BI
IMPORT and CONNECT LIVE Options
Query Mode and Complete Cube Browse
Using MDX Queries with Power BI Queries
MDX SELECT and Perspective Access
KPIs and MDX Expressions with Power BI
Using KPIs in Power BI Reports, Usage
Cube & Perspective Browsing in PBI
MDX Queries and Filters with Power BI
SSAS MDX Scripts with Power BI Visuals
Using KPI Fields in Power BI Visuals
KPI Visual : Goals, Status and Trends
SSAS Tabular Mode Options in Power BI
MDX @ Tabular Mode OLAP in Power BI
DAX @ Tabular Mode OLAP in Power BI
DAX Filters in Tabular Mode SSAS
MDX, DAX Tabular Mode OLAP in Power BI

SQL 7: 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 7 : Power BI Visuals - Level 1

Power BI Visualizations and Types
Fields, Formats & Analytics Options
Table Visuals & Properties, Filters
Field Formatting, Outline Property
Conditional Formatting, Grid Lines
Divergent Colors and Data Labelling
Data Bar and Data Scaling Options

Matrix : Sub Totals, Grand Totals
Drilldown Options : Row and Column
Row Groups, Column Groups in Matrix
Word Wrap and Lock Aspect Options
Banded Row Style and Visual Styles
Single Row Card and MultiRowCard
Background, Border, Data Analytics
Power BI Visual Header Properties

PBI 17 : DAX FUNCTIONS - LEVEL 2

Data Modeling Options in DAX
Detecting & Adding Relations for DAX
Power BI DAX Functions - Types, Usage
Power BI DAX Functions - Cheat Sheet
Power BI Reports - DAX Functionalities
Calculated Columns, Aggregated Measures
Quick Measures in DAX - Auto validations
PowerPivot xVelocity & Vertipaq Store
In-Memory Processing : DAX Performance
Date and Time & Text Functions
Time Intelligence Functions in DAX
Logical & Mathematical Functions
Data Modeling with DAX. Creating Roles
SUM and DATEDIFF Examples in DAX
TODAY, DATE, DAY Arguments with DAX
DIVIDE, CALCULATE, Conditions
Using Variables in DAX, Calculations
IF..ELSE..THEN Statement in DAX
SELECTEDVALUE, FORMAT Functions
RELATED & COUNTROWS in DAX
CALCULATE, SUM, ALL Functions

PBI 27 : POWER BI with R

Introduction to R Language, Usage
R Scripts and R Visuals - Realtime Use
MRO : Microsoft R Open - Installation
MKL : Math Kernel Library Usage 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 in R Studio
Using R Script Editor Window in R Studio
Writing R Scripts in Power BI. Executions
Using R Visual in Power BI Desktop
"game" Console in Power BI Report Fields
Console, Date and Search Options with R
Executing and Testing R Scripts
Power BI Limitations with R Visuals
Duplicate Data Removal with R Visuals
Power BI with R for Data Scientists
R Visuals - Limitations in Power BI

SQL 8: 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 8 : Power BI Visuals - Level 2

Chart Reports - Axis, Legend, Value
Stacked Bar and Clustered Bar Chart
Stacked and Clustered Column Chart
100% Stacked Bar and Column Charts
Data Labels, Legend, Color Saturation
Line Chart and Area Chart Properties

Stacked Area Chart - Properties, Usage
Line and Stacked Column Charts Usage
Line and Clustered Column Chart Usage
Column Series & Column Axis in Lines
Join Types, Lines: Round, Bevel, Miter
Shapes, Markers, Axis, Axis, Plot Area
Display Units, Data Colors, Shapes
Series, Custom Series and Legends

PBI 18 : DAX FUNCTIONS - LEVEL 3

AVERAGEX and AVERAGE in DAX
KEEPFILTERS and CALCUALTE
COUNTROWS and FILTER Functions
Using RELATED with FILTER Function
DIVIDE with FILTER, ALLSELECTED
Using ALL, MAX DAX Functions in FILTER
Using ALLSELCTED and Differences
Using Numeric and Text Conditions
PARALLELPERIOD, DATEDADD in DAX
CALCULATE with PREVIOUSMONTH
FILTER Conditions with ROWCOUNT
USERELATIONSHIP Function in DAX
TOTALYTD , TOTALQTD, TOTALMTD
Time Intelligence with DIVIDE Functions
Time Intelligence with CALCULATE
DATESINPERIOD and AVERAGEX
EARLIER for Time Based Comparisons
Using Variables in DAX Computations
Time Type Dimensions - DAX Expressions
Considerations for Quick Measures

SQL 9: 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 9 : Power BI Visuals - Level 3

Tree Map, Funnel and Gauge Reports
Group and Values in Tree Map Visuals
Min. Max Values and Goal Indicators
Callout Values in KPI Reports and Use
KPI : Indicator, Trend and Target Goal
Scatter Chart - Play Area and Axes
Pie Chart, Donut Charts - Radius

Waterfall Chart - Sentiment Colors
Breakdown Count. Decrease / Increase
Map Reports and Filled Map Reports
Map Visual and Filled Map Visual
ArcGIS Maps - Latitudes, Longitudes
Regions and Geographical Data
Constant Lines and Threshold Values

PBI 19 : DAX FUNCTIONS - LEVEL 4

DAX Variables, Joins and Usage
Value Assignments with DAX
CONCATENATE Function in DAX
HOUR, NOW, SWITCH, TRUE
RETURN Values with DAX Functions
Numeric and Other DAX Options
DAX Modeling Components - use
TABLES, COLUMNS, RELATIONS
MEASURES and HIERARCHIES
INTELLISENSE with DAX Editors
Comments in DAX - Syntax Options
DISTINCTCOUNT and DIVIDE
SAMEPERIODLASTYEAR and IF
Revenue and Budget with DAX
VARIANCE Calculations in DAX
TOTALYTD, YTD, QTD and MTD

SQL 10: Views,Functions,Procedure 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
DBId, DBName, ObjectID, ObjectName
Variables & Parameters in SQL Server

Procedures : Types, Usage in Real-time
User SPs, System SPs, Extended SPs
System Predefined Procedures, Audits
Sp_help, Sp_helpdb and sp_helptext
Sp_recompile, sp_pkeys System SPs

PBI 10 : Power BI Visuals - Level 4

Marketplace Visuals and PBIVIZ Files
HeatMaps - Visual, Real-time Usage
FlowMaps - Visual, Real-time Usage

Power BI Infographics Custom Visuals
PBI Infographics @ Big Data Sources
Custom Visual Limitations, Migrations
Table HeatMaps with Real-time Usage
GanttChart - Visual, Real-time Usage

Analysics & Line Properties in PBI
Visualization Categories, Usage
Comparing Visuals & Properties
When to use Which Visual ?
Visual Selection & Data Labels

Ch 11: Triggers, Transactions

DML Triggers - Events, Practical Use
FOR/AFTER Triggers - Real time Use
INSTEAD OF Triggers - Real time Use
INSERTED, DELETED Memory Tables
Database Level DDL Triggers - Usage
Server Level DDL Triggers - Usage

COMMIT and ROLLBACK Statements
EXPLICIT & IMPLICIT Transactions
Autocommit Transaction, ACID Options
Open Transactions and Query Blocking
NOLOCK and READPAST Lock Hints

Ch 12 : Excel, Integrations, ER Models

Real-time Case Study : SALES SCENARIO

Excel Integration with SQL Databases
Excel Pivot Tables and Pivot Charts
Using Linked Servers, Remote Joins
Storing Queries with Joins in Views
Excel ODC Files with Joins, Sub Queries

Normal Forms : 1 NF, 2 NF, 3 NF, BCNF
4 NF, EKNF, ETNF. Functional Dependency
Multi-Valued & Transitive Dependency
1:1, 1:M, M:1, M:M Relation Types
UPDATE Cascades, DELETE Cascades

Note : Above course curriculum applicable for registrations from April 11th, 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!