This is the sixth part of the ML series. For your convenience you can find other parts in the table of contents in Part 1 – Linear regression in MXNet Today we are going to implement a matrix multiplication in Redshift. Let’s go. First, let’s see what we want to calculate: Nothing fancy. … Continue reading Machine Learning Part 6 — Matrix multiplication in SQL

# Tag: SQL

# Machine Learning Part 4 — Linear regression in T-SQL

This is the fourth part of the ML series. For your convenience you can find other parts in the table of contents in Part 1 – Linear regression in MXNet This time we are going to implement linear regression as a function. This gives us a little more flexibility in terms of debugging the code … Continue reading Machine Learning Part 4 — Linear regression in T-SQL

# Machine Learning Part 3 — Linear regression in SQL revisited

This is the third part of the ML series. For your convenience you can find other parts in the table of contents in Part 1 – Linear regression in MXNet Last time we saw how to calculate linear regression for the Iris dataset. However, we had to hardcode all the featuers. Today we are going … Continue reading Machine Learning Part 3 — Linear regression in SQL revisited

# Machine Learning Part 2 — Linear regression in SQL

This is the second part of the ML series. For your convenience you can find other parts in the table of contents in Part 1 – Linear regression in MXNet Image that you have only a data warehouse with SQL capabilities to train and evaluate your models. Last time we ran Python code to calculate … Continue reading Machine Learning Part 2 — Linear regression in SQL

# Executing SQL query inside Excel spreadsheet

Did you know that you can execute almost any SQL query directly in your Excel spreadsheet? This can be very useful for executing queries with GROUP BY and aggregates since they cannot be generated that easily. Let’s begin. I will use Excel 2013 but this method should work in other editions as well. First, create … Continue reading Executing SQL query inside Excel spreadsheet