Перейти к основному содержимому

Analyzing Product Demand in SQL

Find out how to unlock a new dimension of your analytical power by bringing simple linear regression into SQL!
Josef Waples
Josef Waples

Создать бесплатный аккаунт

Практикуйтесь и следите за своим прогрессом.

Продолжить с GoogleПродолжая, вы принимаете нашу Условия использования, наши Политику конфиденциальности и то, что ваши данные хранятся в США.

Пишите код вместе с нами на

Code Along ↗

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.

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, which is finding the price that maximizes revenue
  • Become good at SQL aggregate functions and common table expressions (CTEs)

Session Resources

Темы

SQLData AnalysisDataLab

Связанное

Учебное руководство

SQL: Reporting and Analysis

совместная сессия кодирования

Free Trial Performance Analysis in SQL

Показать больше →