Analyzing Product Demand in SQL
Key Takeaways:- Learn how to find the coefficients for a simple linear regression in SQL
- Discover how to use SQL to analyze pricing data and find the answer to an interesting optimization problem
- Become good at SQL aggregate functions and common table expressions (CTEs)
Description
Data skills are the cornerstone of the 21st-century workforce, and SQL is foundational for any role that involves data. Understanding and effectively using SQL can open doors to greater productivity, better decision-making capabilities, and more career opportunities in this era of digital transformation.
You might know SQL as a querying tool, but in this live training, you will see how SQL can help with predictive modeling. In this live training, we will teach you how to unlock a new dimension of your analytical power by bringing simple linear regression into SQL! Specifically, we will use a sales dataset and learn how to create a regression to find the quantity sold as a function of price. Furthermore, we will do a more sophisticated pricing anlaysis by finding the theoretical price that maximizes revenue —all within SQL.
Presenter Bio
I'm a data science writer and editor with a history of contributions to research articles in scientific journals. I'm especially interested in linear algebra, statistics, R, and the like. I also play a fair amount of chess!