Global Tech Learn

SQL Stored Procedure and Functions - Basic to Advance

Power BI Transform Data/Query Editor - Group By

Microsoft SQL Server and Management Studio Installation

SQL Default, Check Constraint & Sequence

Power BI - Direct Query Decode Workshop

Power BI - Create Date Table using DAX Calendar() and Calendarauto()

Power BI - Connect to SQL Server Datasource

Power BI - Import vs Direct Query vs Live Connection

Power BI - How to create Report in Power BI

Power BI -Use Fuzzy Match for merging queries

Microsoft Power BI 2023 update - Dynamic format strings for measures

Power BI - Import Basic to Advance(Nested) JSON

PL 300 : Q55 - Power BI Reduce Model Size

Power BI Data Transform - Append Queries

PL 300 : Q65 - Power BI Split DateTime into Date & Time Columns

Database Keys - Primary, Foreign, Unique, Composite keys and Computed & Identity Columns

SQL Case Statement - Basic to advance

Basic SQL - Alias, Distinct, Order by, Group by, Having, Truncate

Basic SQL - Create Table, Select, Data Types, Insert, Delete, Top, Where Statements

Power BI -Use Parameter in Power Query Editor-part 1

PL 300 : Q2 - Power BI Aggregate Measure in One-to-Many Relationship

SQL Server - Create and drop Database, Schema, Table

SQL Alter Table Commands

SQL Joins and Union - Left, Right, Full, Inner, Self, Left Anti, Right Anti , Union and Union All

PL 300 : Q40 - Power BI Organizational Data Types and Feature Tables

SQL Delete vs Truncate

PL 300 : Q7 - Power BI Change Column Data Type to Reduce Model Size

PL300 : Q33 - Power BI Merge Order Header and Order Detail Tables

Power BI - Data Modelling basic to advance

Power BI Update June 2023- New Card Visual

PL 300 : Q31 - Power BI MQuery - Combine Text and Number Fields in Custom Column