4 ms·
>"throw the tabular data into a relational data warehouse, and ask your questions in the form of SQL queries." You can ask SQL descriptive questions. Can you a
by closeparen 3y ago
>"throw the tabular data into a relational data warehouse, and ask your questions in the form of SQL queries."
You can ask SQL descriptive questions. Can you ask it for predictions? How?
- asdff 3y agoThis is called extrapolation and can be done with simple linear regression in some cases
- itsoktocry 3y ago>simple linear regression in some cases You're correct, but "in some cases" is doing a lot of work here. With the tooling where it's at, how much harder is it to apply xGBoost vs a linear model?
- hazbot 3y agomodel.predict() is pretty easy to call, but judging the validity of the model is still hard and very manual. Linear model is less flexible and powerful, but easier to analyse/validate.
- taway_6PplYu5 3y agohttps://www.red-gate.com/simple-talk/blogs/statistics-sql-simple-linear-regressions/ https://www.red-gate.com/simple-talk/blogs/statistics-sql-si... One of several examples of implementing linear regression in SQL.