Enqurious LogoTM

Use coupon code 'ENQSPARKS25' to get 100 credits for FREE

0
0
Days
0
0
Hours
0
0
Minutes
0
0
Seconds
Go back

Customer Loyalty Report

10 Inputs
1 Hour
Advanced
scenario poster
Industry
e-commerce
Skills
approach
data-wrangling
quality
Tools
sql

Learning Objectives

Extract and manipulate relevant data to generate the required report.
Present data in a clear and easy-to-understand tabular format.
Enhance SQL skills with complex queries for data extraction and manipulation.

Overview

GlobalMart aims to design a loyalty program by categorizing customers into Promoters, Potentials, and Detractors based on calculated scores derived from purchase behavior metrics to enhance customer insights and engagement.

Prerequisites

  • Understanding of basic SQL queries, joins, and aggregate functions.
  • Ability to accurately calculate and present data.