{"id":7539,"date":"2023-03-03T20:54:35","date_gmt":"2023-03-03T20:54:35","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/customer-data-set-managerial-report-and-excel\/"},"modified":"2023-03-03T20:54:35","modified_gmt":"2023-03-03T20:54:35","slug":"customer-data-set-managerial-report-and-excel","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/customer-data-set-managerial-report-and-excel\/","title":{"rendered":"\u201ccustomer data set\u201d  managerial report  and excel"},"content":{"rendered":"<div class=\"col-sm-12 messageContent\">\n <b>Learning Goal: <\/b>I&#8217;m working on a data analytics case study and need guidance to help me learn.<\/p>\n<p>The excel file \u00e2\u20ac\u0153customer data set\u00e2\u20ac\ufffd 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:<\/p>\n<ul>\n<li>Customer demographic &#8211; Gender and age of the customer<\/li>\n<li>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)<\/li>\n<li>Customer support reach-out method \u00e2\u20ac\u201c Email or Phone<\/li>\n<li>Type of service \u00e2\u20ac\u201c sign-up\/cancellation or Support<\/li>\n<li>Product type \u00e2\u20ac\u201c annual or monthly<\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Learning Goal: I&#8217;m working on a data analytics case study and need guidance to help me learn. The excel file \u00e2\u20ac\u0153customer data set\u00e2\u20ac\ufffd 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 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[735],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/7539"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=7539"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/7539\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=7539"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=7539"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=7539"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=7539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}