Azure SQL Video
13 page views
131 video views
2024, June 08, Saturday

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;