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 (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 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 (IS / AS/ RS) 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 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:

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!

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