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...
Enroll Now - Select a section to enroll in
Section Title
Advanced SQL Queries: Level 3-Data Analysis
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
Sep 20, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Sep 18, 2024
Transfer Request Deadline
Sep 18, 2024
Section Title
Advanced SQL Queries: Level 3-Data Analysis
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
Sep 20, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Sep 18, 2024
Transfer Request Deadline
Sep 18, 2024
Required fields are indicated by .