Power BI Training Classes

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.

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 Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Desktop, Custom Visuals Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Data Modelling with Power Query Check-Symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Data Modelling with DAX Check-Symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Cloud, Excel Analysis Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Mobile, R, REST API Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Python Integration, Data Flows Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Real-Time Project in Power BI Check-Symbol-for-No Croos-symbol-for-Yes Croos-symbol-for-Yes
SQL Database, T-SQL Queries Check-Symbol-for-No Check-Symbol-for-No Check-Symbol-for-Yes
Normal Forms, Joins, Query Tuning Check-Symbol-for-No Check-Symbol-for-No Check-Symbol-for-Yes
Sub Queries, Stored Procedures Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Excel Pivot Tables, Pivot Charts Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Complete MSBI (SSIS, SSAS, SSRS) Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
ETL with DWH Database Design Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
OLAP Cube Design. MDX, DAX Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
SSRS Reports, Cube Reports Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
MSBI with Power BI Integration Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
MCSA Certification Guidance Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
End-to-End Project, Resume Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
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:

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!

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer : Mr. Sai Phanindra T