Piyush Agrawal Sql Server, MSBI, Power BI, ADF Developer
No reviews yet

I am a SQL Server, Power BI, and Microsoft Business Intelligence (MSBI) expert with 13+ years of overall IT experience and 8+ years of dedicated experience in training, mentoring, and consulting IT professionals and students worldwide.

To date, I have successfully trained more than 60,000 professionals across India, the USA, and Canada, including freshers, working professionals, and corporate teams. I am associated with multiple reputed technical training institutes as a lead trainer and subject matter expert.

I also manage a team of experienced developers and actively work on real-time industry projects, which allows me to deliver practical, job-oriented training aligned with current industry standards.

Along with training, I provide hands-on technical consulting and production-level support to IT professionals across the globe and have delivered stable, scalable solutions with zero post-delivery issues.

All sessions are conducted online via Zoom, Microsoft Teams, GoToMeeting, or similar platforms.

📘 What You Will Get in My Training

✔ Detailed explanation of basic to advanced concepts
✔ Assignments after every session for practical exposure
✔ Dedicated doubt-clearing session at the end of the course
✔ Real-time project implementation
✔ Interview guidance and best industry practices

🛠️ Subjects & Expertise

Power BI

SQL Server

DAX (Data Analysis Expressions)

SSIS (SQL Server Integration Services)

SSAS (Tabular & Multidimensional)

SSRS (SQL Server Reporting Services)

End-to-End MSBI Solutions

Azure Data Factory

Subjects

SQL Server Beginner-Expert
SSIS (SQL Server Integration Services) Beginner-Expert
MSBI Beginner-Expert
Power BI Beginner-Expert
Microsoft Fabric Beginner-Expert

Experience

Freelancer (Jan, 2016–Present) at Freelancer

Provides Training in Sql Server, MSBI, Power BI
BI Developer (Feb, 2012–Jan, 2016) at MNC in Pune

I was a Sql Server and MSBI Developer

Education

CDAC (Feb, 2012–Nov, 2012) from CDAC-ACTS
BE (Jun, 2006–Jun, 2010) from RGPV BHOPAL

Fee details

₹400–2,500/hour (US$4.21–26.31/hour)

Courses offered

Sql Server
- US$100
- Duration: 15 Hours
- Delivery mode: Online
- Group size: Individual
- Instruction language: English, Hindi
- Certificate provided: Yes
Sql Server Course Details
100% Practical Classes
Introduction To SQL Server
Connecting To Server
Sql Server Management Studio and Tools In Management Studio
Object Explorer
Object Explorer Details
Query Editor
TSQL (Transact-Structured Query Language)
Introduction To TSQL
History and Features of TSQL
Types Of TSQL Commands
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Database
Creating Database
Altering Database
Deleting Database
Constrains
Primary Key and Referential Integrity or foreign key constraints
Data Types In TSQL
Table
Creating Table
Altering Table
Deleting Table
Data Manipulation Language
Insert
Identity
Creating A Table From Another Table
Inserting Rows From One Table To Another
Update
Delete
Truncate
Differences Between Delete and Truncate
Data Query Language (DQL)
Select
Where clause
Order By Clause
Distinct Keyword
Column aliases
Between … And
In
Like
Is Null
Built In Functions
Aggregate Functions
Group By and Having Clauses
Over(partition by …) Clause
Ranking Functions
Common Table Expressions (CTE)
Top n Clause
SQL Operators
Sub queries

Set Operators
Union
Union All
Intersect
Except
Joins
Inner Join
Outer Join
Left Outer Join
Right Outer Join
Full Outer Join
Cross Join
Indexes
Clustered Index
NonClustered Index
Views
TSQL Programming
Cursors
Stored Procedures
User Defined Functions
Triggers
Power BI
- US$100
- Duration: 15 Hours
- Delivery mode: Online
- Group size: Individual
- Instruction language: English, Hindi
- Certificate provided: Yes
Power BI Course Details
100% Practical Classes

Power BI

Module 1: Power BI Desktop & Power Query
Getting Started
Class Introduction (BI Basics)
Class Introduction (Power BI Desktop Overview)
Data Discovery with Power BI Desktop
Transforming Data (Basic Transforms)
Transforming Data (Add Column From Example)
Transforming Data (Appending Queries)
Transforming Data (Merging Queries)
Transforming Data (Combine Files)
Transforming Data (Other Query Features)
Introduction to Modeling Data
Creating the Data Model (Modeling Basics)
Creating Calculated Columns and Tables (DAX Basics)
Creating Calculated Columns and Tables (Navigation Function)
Creating Calculated Columns and Tables (Calculated Tables)
Creating Calculated Measures (Measure Basics)
Creating Calculated Measures (Time Intelligence Functions)

Module 2: Power BI Service & Visualizations & Power BI Mobile
Introduction to Visualizing Data
Creating Basic Reports with the Power BI Desktop
Creating Interactive Reports (Adding Slicers for Filters)
Creating Interactive Reports (Visualizing Tabular Data)
Creating Interactive Reports (Visualizing Categorical Data)
Creating Interactive Reports (Visualizing Data Trends)
Creating Interactive Reports (Visualizing Categorical and Trend Data Together)
Creating Interactive Reports (Visualizing Geographical Data with Maps)
Creating Interactive Reports (Visualizing Goal Tracking)
Creating Interactive Reports (Using Custom Visuals)
Creating Interactive Reports (Digital Storytelling)
Creating Interactive Reports (Other Features)
Using the Power BI Service (Deploying to the Power BI Service)
Using the Power BI Service (Creating and Sharing Dashboards)
Using the Power BI Service (Using Power BI Q&A)
Using the Power BI Service (Excel Integration)
Refreshing the Data (Refreshing Data Overview)
Refreshing the Data (Installing the Data Gateway)
Refreshing the Data (Scheduling a Data Refresh)
Mobile BI (Power BI Mobile Overview)
Mobile BI (Designing Reports and Dashboards for Mobile)
Mobile BI (Interacting with the Power BI Mobile App)

Module 3: Get Data
Excel
CSV
Sql Server
SSAS Multidimensional
SSAS Tabular

Module 4:Baisc DAX
Getting Started
Data Modeling Basics (Overview)
Data Modeling Basics (Tabular)
What is DAX (Overview)
What is DAX (Tabular)
Creating Calculated Columns (Basics)
Creating Calculated Columns (Basics Continued)
Navigation Functions
Conditional and Logical Functions
Creating Calculated Measures
Time Intelligence (Overview)
Time Intelligence (Time Intelligence Functions)
Table Functions
DAX as a Query Language

Module 5:Advanced DAX
Class Introduction (Class Files)
Class Introduction (Why Advanced DAX)
Working with Filter Context (CALCULATE)
Working with Filter Context (FILTER)
Working with Filter Context (FILTER and ALL)
Working with Filter Context (ALLEXCEPT)
CALCULATE and Time Intelligence (YTD and MTD)
Security (Implementing Basic Security)
Security (Implementing Basic Security – Tabular)
Advanced DAX Function (CONTAINS)
Advanced DAX Function (FIND)
Advanced DAX Function (SEARCH and SUBSTITUTE)
Advanced DAX Function (ALLSELECTED)

Projects
MSBI
- US$200
- Duration: 20 Hours
- Delivery mode: Online
- Group size: Individual
- Instruction language: English, Hindi
- Certificate provided: Yes
MSBI Course Details
100% Practical Classes
SSIS
100 % Practical Classes

Introduction to SQL Server Integration Services

SSIS Package Architecture Overview
Introduction to SSIS & Data Warehouse
Basic ETL Entities in SSIS
Data and Management Tools

Introduction to Data Flow
Data Flow Overview
Data Sources
Data Destinations
Data Flow Transformations
Data Viewers

Data Sources

Excel Source
Flat File Source
OLE DB Source
XML Source

Data Flow Transformations

Aggregate Transformation
Audit Transformation
Character Map Transformation
Conditional Split Transformation
Copy Column Transformation
Derived Column Transformation
Data Conversion Transformation
Multicast Transformation
OLE DB Command Transformation
Percentage Sampling Transformation
Row Count Transformation
Sort Transformation
Union All Transformation
Audit Transformation
Character Map Transformation
Copy Column Transformation

Advanced Data Flow

Lookup Transformation
Merge Transformation
Merge Join Transformation
Slowly Changing Dimension Transformation
Pivot Transformation
Export Transformation
Import Transformation
Unpivot Transformation
Term Extraction Transformation
Term Lookup Transformation
Fuzzy Lookup Transformation
Fuzzy Grouping Transformation

Data Flow Destinations

Data Reader Destination
Excel Destination
Flat File Destination
OLE DB Destination

Introduction to Control Flow

Control Flow Overview
Precedence Constraints
The Execute SQL Task
The Bulk Insert Task
The File System Task
The FTP Task
The Send Mail Task
Bulk Insert Task
Data Flow Task
Execute Package Task
Execute Process Task
Web Service Task
Backup database Task
Analysis Services Processing Task

Advanced Control Flow

For Loop Container
For Each Loop Container
Sequence Container

Variables and Configurations

Variables Overview
Variable scope
SSIS system variables
Using variables in control flow
Using variables in data flow
Property expressions
Configuration Overview
Configuration options
Configuration discipline

Error Handling and Logging

Control Flow: The On Error event handler
Data Flow: Error data flow
Built-in log providers

SSIS Package Deployment
Configurations and deployment
Deployment options

SSIS Package Management
The SSIS Service
Managing packages with SQL Server Management Studio
Scheduling packages with SQL Server Agent

Projects

SSAS
100 % Practical Classes

What Is Microsoft Business Intelligence?
Defining Microsoft Business Intelligence
Viewing a Cube Using Excel
Using SSAS in SSDT
Understanding SSDT
Creating Data Sources
Creating Data Source Views
Creating a multidimensional cube
Creating a TabularModel

Intermediate SSAS

KPI
Action
Aggregation
Creating Perspectives
Creating Translations
Working with Multiple Fact Tables
Using the Business Intelligence Wizard

SSRS
100 % Practical Classes
Creating basic reports

Tabular
List
Matrix
Chart
Parameterized
Drilldown
DrillThrough
Constructing data sources and Datasets
Data Analyst Without coding
- US$600
- Duration: 60 Hours
- Delivery mode: Online
- Group size: Individual
- Instruction language: English, Hindi
- Certificate provided: Yes
Data Analyst Course Details
100% Practical Classes
Introduction To SQL Server
Connecting To Server
Sql Server Management Studio and Tools In Management Studio
Object Explorer
Object Explorer Details
Query Editor
TSQL (Transact-Structured Query Language)

Introduction To TSQL
History and Features of TSQL
Types Of TSQL Commands
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Database
Creating Database
Altering Database
Deleting Database
Constrains
Primary Key and Referential Integrity or foreign key constraints
Data Types In TSQL
Table
Creating Table
Altering Table
Deleting Table
Data Manipulation Language
Insert
Identity
Creating A Table From Another Table
Inserting Rows From One Table To Another
Update
Delete
Truncate
Differences Between Delete and Truncate
Data Query Language (DQL)
Select
Where clause
Order By Clause
Distinct Keyword
Column aliases
Between … And
In
Like
Is Null
Built In Functions
Aggregate Functions
Group By and Having Clauses
Over(partition by …) Clause
Ranking Functions
Common Table Expressions (CTE)
Top n Clause
SQL Operators
Sub queries

Set Operators
Union
Union All
Intersect
Except
Joins
Inner Join
Outer Join
Left Outer Join
Right Outer Join
Full Outer Join
Cross Join
Indexes
Clustered Index
NonClustered Index
Views
TSQL Programming
Cursors
Stored Procedures
User Defined Functions
Triggers

SSIS
100 % Practical Classes

Introduction to SQL Server Integration Services

SSIS Package Architecture Overview
Introduction to SSIS & Data Warehouse
Basic ETL Entities in SSIS
Data and Management Tools

Introduction to Data Flow
Data Flow Overview
Data Sources
Data Destinations
Data Flow Transformations
Data Viewers

Data Sources

Excel Source
Flat File Source
OLE DB Source
XML Source

Data Flow Transformations

Aggregate Transformation
Audit Transformation
Character Map Transformation
Conditional Split Transformation
Copy Column Transformation
Derived Column Transformation
Data Conversion Transformation
Multicast Transformation
OLE DB Command Transformation
Percentage Sampling Transformation
Row Count Transformation
Sort Transformation
Union All Transformation
Audit Transformation
Character Map Transformation
Copy Column Transformation

Advanced Data Flow

Lookup Transformation
Merge Transformation
Merge Join Transformation
Slowly Changing Dimension Transformation
Pivot Transformation
Export Transformation
Import Transformation
Unpivot Transformation
Term Extraction Transformation
Term Lookup Transformation
Fuzzy Lookup Transformation
Fuzzy Grouping Transformation

Data Flow Destinations

Data Reader Destination
Excel Destination
Flat File Destination
OLE DB Destination

Introduction to Control Flow

Control Flow Overview
Precedence Constraints
The Execute SQL Task
The Bulk Insert Task
The File System Task
The FTP Task
The Send Mail Task
Bulk Insert Task
Data Flow Task
Execute Package Task
Execute Process Task
Web Service Task
Backup database Task
Analysis Services Processing Task

Advanced Control Flow

For Loop Container
For Each Loop Container
Sequence Container

Variables and Configurations

Variables Overview
Variable scope
SSIS system variables
Using variables in control flow
Using variables in data flow
Property expressions
Configuration Overview
Configuration options
Configuration discipline

Error Handling and Logging

Control Flow: The On Error event handler
Data Flow: Error data flow
Built-in log providers

SSIS Package Deployment
Configurations and deployment
Deployment options

SSIS Package Management
The SSIS Service
Managing packages with SQL Server Management Studio
Scheduling packages with SQL Server Agent

Projects

SSAS
100 % Practical Classes

What Is Microsoft Business Intelligence?
Defining Microsoft Business Intelligence
Viewing a Cube Using Excel
Using SSAS in SSDT
Understanding SSDT
Creating Data Sources
Creating Data Source Views
Creating a multidimensional cube
Creating a TabularModel

Intermediate SSAS

KPI
Action
Aggregation
Creating Perspectives
Creating Translations
Working with Multiple Fact Tables
Using the Business Intelligence Wizard

SSRS
100 % Practical Classes
Creating basic reports

Tabular
List
Matrix
Chart
Parameterized
Drilldown
DrillThrough
Constructing data sources and Datasets

Power BI

Module 1: Power BI Desktop & Power Query
Getting Started
Class Introduction (BI Basics)
Class Introduction (Power BI Desktop Overview)
Data Discovery with Power BI Desktop
Transforming Data (Basic Transforms)
Transforming Data (Add Column From Example)
Transforming Data (Appending Queries)
Transforming Data (Merging Queries)
Transforming Data (Combine Files)
Transforming Data (Other Query Features)
Introduction to Modeling Data
Creating the Data Model (Modeling Basics)
Creating Calculated Columns and Tables (DAX Basics)
Creating Calculated Columns and Tables (Navigation Function)
Creating Calculated Columns and Tables (Calculated Tables)
Creating Calculated Measures (Measure Basics)
Creating Calculated Measures (Time Intelligence Functions)

Module 2: Power BI Service & Visualizations & Power BI Mobile
Introduction to Visualizing Data
Creating Basic Reports with the Power BI Desktop
Creating Interactive Reports (Adding Slicers for Filters)
Creating Interactive Reports (Visualizing Tabular Data)
Creating Interactive Reports (Visualizing Categorical Data)
Creating Interactive Reports (Visualizing Data Trends)
Creating Interactive Reports (Visualizing Categorical and Trend Data Together)
Creating Interactive Reports (Visualizing Geographical Data with Maps)
Creating Interactive Reports (Visualizing Goal Tracking)
Creating Interactive Reports (Using Custom Visuals)
Creating Interactive Reports (Digital Storytelling)
Creating Interactive Reports (Other Features)
Using the Power BI Service (Deploying to the Power BI Service)
Using the Power BI Service (Creating and Sharing Dashboards)
Using the Power BI Service (Using Power BI Q&A)
Using the Power BI Service (Excel Integration)
Refreshing the Data (Refreshing Data Overview)
Refreshing the Data (Installing the Data Gateway)
Refreshing the Data (Scheduling a Data Refresh)
Mobile BI (Power BI Mobile Overview)
Mobile BI (Designing Reports and Dashboards for Mobile)
Mobile BI (Interacting with the Power BI Mobile App)

Module 3: Get Data
Excel
CSV
Sql Server
SSAS Multidimensional
SSAS Tabular

Module 4:Baisc DAX
Getting Started
Data Modeling Basics (Overview)
Data Modeling Basics (Tabular)
What is DAX (Overview)
What is DAX (Tabular)
Creating Calculated Columns (Basics)
Creating Calculated Columns (Basics Continued)
Navigation Functions
Conditional and Logical Functions
Creating Calculated Measures
Time Intelligence (Overview)
Time Intelligence (Time Intelligence Functions)
Table Functions
DAX as a Query Language

Module 5:Advanced DAX
Class Introduction (Class Files)
Class Introduction (Why Advanced DAX)
Working with Filter Context (CALCULATE)
Working with Filter Context (FILTER)
Working with Filter Context (FILTER and ALL)
Working with Filter Context (ALLEXCEPT)
CALCULATE and Time Intelligence (YTD and MTD)
Security (Implementing Basic Security)
Security (Implementing Basic Security – Tabular)
Advanced DAX Function (CONTAINS)
Advanced DAX Function (FIND)
Advanced DAX Function (SEARCH and SUBSTITUTE)
Advanced DAX Function (ALLSELECTED)

Projects