Loading...

Course Description

Learn to design effective SQL queries to extract business information from your databases in order to do effective data analysis. Discover how to pull data for survival analysis of customers to better understand your active customer base in order to predict future revenue. Understand the factors that affect customer tenure and how to use SQL to calculate the probabilities of customers staying or leaving. Learn to investigate purchasing patterns and methods for identifying customers. Use SQL to help analyze the frequency of purchases and understand where sales are increasing or decreasing. Additional topics include market basket analysis to better understand customers and what they might purchase.

In this class, you will learn how to: 

  • Determine Customer Survival Analysis 

  • Predict future revenues based on your active customer base 

  • Find the factors that affect customer tenure 

  • Calculate the probabilities that a customer will stay (or leave) 

  • Identify customers 

  • Determine average number of orders and sales 

  • Determine if sales are increasing or decreasing 

  • Determine the frequency of purchases 

  • Discover purchasing patterns 

  • Do market basket analysis 

Prerequisites

Advanced SQL Queries: Level 2 or equivalent experience.

Applies Towards the Following Certificates

Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .