You have been given a report from the CRM system used by Sophia's Software, Inc. Sophia's is a software-as-a-service company that licenses its software products to customers. Sophia's is trying to better understand its customer attrition (customers who do not review their subscriptions.) Custom Name SC Product Subscription End Date Custom 132 Custom & Lustom 133 Customer 43 Banner Ad Callin Banner Ad Trade Show Webste Referral Pine Pine Pine Cherry Cherry Wahut Sales Rep Man Pennypkes Costanza Morgan Costanza Pennypacker Senfeld Newman Costanza Morgan Seinfeld Drake Costanza Location Industry Vermont Ute Scences New Hampshire Technology Maine Financial Services Vermont Technology Massachusetts Technology Connecticut Technology Subscription Start Date 5/8/2017 SA1/2012 11/23 2012 9/16/2012 SA 2/2012 3/7/2017 30,000 53 800 31.100 51.700 50.900 18,700 3/17/2018 If a customer has a subscription end date, the customer has attritted (or not renewed its subscription). If the customer does not have a subscription end date, the customer is active and has renewed its subscription. In the table above, Customer 62 is active; whereas Customer 43 has attritted. In addition the information from Sophia's CRM system, the Company also categorizes its customers by annual revenue range as follows: Pricing Tier Tier 1 Tier 2 Tier 3 Tier 4 Annual Revenue Range $ to $ 10,000 $ 10,000 to $ 20,000 $ 20,000 to $ 30,000 $ 30,000 to $ 40,000 $ 40,000 to $ 60,000 | | Tier 5 Your assignment is to seek insights regrading Sophia's customer attrition by creating and analyzing pivot tables. Create as many pivot table analyses as you deem necessary to help you understand customer attrition. You have been given a report from the CRM system used by Sophia's Software, Inc. Sophia's is a software-as-a-service company that licenses its software products to customers. Sophia's is trying to better understand its customer attrition (customers who do not review their subscriptions.) Custom Name SC Product Subscription End Date Custom 132 Custom & Lustom 133 Customer 43 Banner Ad Callin Banner Ad Trade Show Webste Referral Pine Pine Pine Cherry Cherry Wahut Sales Rep Man Pennypkes Costanza Morgan Costanza Pennypacker Senfeld Newman Costanza Morgan Seinfeld Drake Costanza Location Industry Vermont Ute Scences New Hampshire Technology Maine Financial Services Vermont Technology Massachusetts Technology Connecticut Technology Subscription Start Date 5/8/2017 SA1/2012 11/23 2012 9/16/2012 SA 2/2012 3/7/2017 30,000 53 800 31.100 51.700 50.900 18,700 3/17/2018 If a customer has a subscription end date, the customer has attritted (or not renewed its subscription). If the customer does not have a subscription end date, the customer is active and has renewed its subscription. In the table above, Customer 62 is active; whereas Customer 43 has attritted. In addition the information from Sophia's CRM system, the Company also categorizes its customers by annual revenue range as follows: Pricing Tier Tier 1 Tier 2 Tier 3 Tier 4 Annual Revenue Range $ to $ 10,000 $ 10,000 to $ 20,000 $ 20,000 to $ 30,000 $ 30,000 to $ 40,000 $ 40,000 to $ 60,000 | | Tier 5 Your assignment is to seek insights regrading Sophia's customer attrition by creating and analyzing pivot tables. Create as many pivot table analyses as you deem necessary to help you understand customer attrition