Learning Goal: I’m working on a data analytics case study and need guidance to help me learn.
The excel file “customer data set� includes customer subscription data for a digital product companywhich provides financial advisory services. This company offers an annual and monthlysubscription. Customer support services, including product-related questions andsignup/cancellation-related queries, are provided via email and phone. This database includes thefollowing variables:
- Customer demographic – Gender and age of the customer
- Start and end date of the subscription (to reduce the complexity of the calculations for you, weselected Aug 16, 2022, as the end date of the current active customers)
- Customer support reach-out method – Email or Phone
- Type of service – sign-up/cancellation or Support
- Product type – annual or monthly