Ex & Co.Tech

Power BI Class 5 Mathematical Aggregation DAX Function

Power BI Class 4 - Incremental Refresh

Power BI Class 3 - Power Query (ETL Tool)

Power BI Class 2 - Power Query (ETL Tool)

Power BI Class 1 - Introduction of Power BI

How to use Append and Merge Query

# 2 How to use Sum Series Like Sum, Sumif, Sumifs, Aggregate and Subtotal

# 4 How to use Average Series Like Average, Averageif, Averageifs, Aggregate and Subtotal

# 3 How to use Count Series Like Count, Countif, Countifs, Aggregate and Subtotal

# 1 What is MIS | Row | Column | Type of Reference

#6 How to Use Window Function in SQL

#20 How to Use Intersect,Except,Left,Right and Substring in SQL Query

#7 How to Use Min,Max,Count,Avg and Sum in SQL

#1 Create Database and Table Using in SQL Query

#4 How to Use Not,Order By,ASCENDING and DESCENDING Order in SQL

# 10 How to Use Select Into and Insert Into Select in SQL Query

#11 How to Use Group By and Having in SQL Query

#5 How to Use Update ,Delete,Null and Not Null Function in SQL

#9 How to Use Between,Alias Union and Union All in SQL Query

#8 How to Change Database,Table,Column Name and Insert Data through SQL Query