Azure SQL Video
13 page views
154 video views
2024, October 26, Saturday

#125 Get correlation between values in Azure SQL Server

Learn how to calculate the correlation between variables using Azure SQL. Essential techniques and functions for efficient statistical analysis

We will know the techniques:

🔹Pearson's correlation formula;
🔹Declare variable of type table (DECLARE, TABLE, INSERT INTO, VALUES);
🔹Calculate the average of the values (AVG, CTE);
🔹Cartesian product of values (FROM, CROSS JOIN);
🔹Calculate square root and power value (SQRT, POWER);
🔹Retrieve table rows (SELECT, COLUMNS, FROM, TABLE);
Transform rows into columns (PIVOT, MAX, FOR, IN); 🔹
🔹Obtain the correlation between two variables;