top of page

Create Your First Project

Start adding your projects to your portfolio. Click on "Manage Projects" to get started

Customer Cancellations Dataset

Project Type

SQL

In these screenshots, I have shown of my written SQL, using a data set from my current position, detailing customer cancellations. Throughout the query, I answered questions such as, "Which branch is losing the most customers?", "Which salesperson's customers cancelled the most?", "When were we experiencing the most cancellations?" and "Where are the cancellations largely happening?". Throughout the script I use the phrase "RMR", standing for Recurring Monthly Rate, which is the rate the customer was paying, and that we are now losing due to their cancelling.

bottom of page